What Data Analysts Actually Do
Strip away the job-title mystique and a data analyst's job usually comes down to three things: pulling data from somewhere, making sense of it, and communicating what it means to people who'll make decisions based on it. That could mean a weekly sales dashboard, a one-off analysis for a marketing campaign, or answering "why did conversions drop last month?"
Core Skills You Need
| Skill | Why It Matters |
|---|---|
| Excel | Still the baseline expectation in almost every analyst job posting |
| SQL | How you actually pull data out of company databases |
| Power BI or Tableau | How you turn that data into reports people can use |
| Basic statistics | Understanding averages, trends, and what "significant" actually means |
| Communication | The most underrated skill — a great analysis nobody understands is wasted |
Do You Need A Degree?
Not necessarily. Many working data analysts come from non-technical backgrounds — commerce, operations, even teaching — and picked up the technical skills through courses, self-study, and practice projects. What actually gets you hired is being able to demonstrate you can do the work, most commonly through a portfolio of real projects.
A Realistic Path In
- Get comfortable in Excel — pivot tables, VLOOKUP/XLOOKUP, basic charts
- Learn SQL basics — SELECT, WHERE, GROUP BY, JOINs cover most real queries
- Learn Power BI — this is what turns raw analysis into something a manager can actually use
- Build 2–3 portfolio projects — see below
- Apply to analyst or junior analyst roles, and don't discount internal transfers if you're already at a company in a different role
Building A Portfolio
You don't need permission or a job to start building proof of skill. Pick a public dataset (sports stats, retail sales, government open data), ask a real question of it, and build a complete Power BI dashboard that answers that question clearly. Two or three of these, done well, say more in an interview than a resume line ever will.