Data Analyst Career Roadmap
Data analysis is the discipline of turning the question 'what actually happened?' into an answer that changes how a business acts. SQL, Python, dashboards, and the underrated skill of knowing which question is worth asking in the first place. The stereotype is a person in a spreadsheet. The reality is a person translating between what data can show and what decision-makers can act on — a translation that requires both technical depth and an unsentimental read of organizational dynamics.
Is this the right path for you?
Data analysts come from Excel power users who discovered SQL, from BI tool specialists who wanted more depth, from operations and finance people who got comfortable with data, and from CS graduates who wanted to stay closer to the business than engineering roles allow. The role is one of the most accessible analytical careers — the skills are learnable without a math-heavy background, and the tools are approachable.
If you find patterns in data that make you want to change something — if you're more interested in what the numbers mean for the decision than in the numbers themselves — you're already thinking like a data analyst. The job is storytelling with evidence. The analysis is just the research.
SQL fluency is the true entry gate. Not certifications. Not Excel. Not Tableau. If you can't write a reasonably complex query from scratch — joins, aggregations, window functions, subqueries — you are not ready to apply for most analyst roles. This is non-negotiable and widely misunderstood by people who took a data analytics bootcamp that didn't teach SQL seriously.
Career Progression
Where does this role lead?
Click any role to explore timeline, key skills and, where the Department of Labor publishes it, pay.
Entry
Junior Data Analyst
~1 yr
$62,546 (Level I)
You're pulling reports and answering one-off questions from stakeholders. Learning to QA your own outputs before anyone else sees them is what builds trust early.
Key skills
Pay shown is the U.S. Department of Labor prevailing wage for Level I (entry), Level III (mid) and Level IV (senior) in the nearest BLS occupation, base wage for the typical metro, wage year 2025, shown for the main track only. It is a benchmark, not an offer; branches and lead, staff and executive stages have no official figure.
Visual roadmap
Data Analyst learning path
Work down the line, one step at a time. Tick each skill as you can do it.
- 1
Spreadsheet Mastery with Excel & Google Sheets
4–6 weeksExcel is still the most used data tool in business. Master formulas (VLOOKUP, INDEX/MATCH, XLOOKUP), pivot tables, charts, and conditional formatting. Learn to clean and reshape data quickly. These skills get you hired at the entry level.
Skills to learn
- Excel Formulas (XLOOKUP, INDEX/MATCH)
- Pivot Tables & Pivot Charts
- Power Query (data import & transform)
- Conditional Formatting & Validation
- Google Sheets & ARRAYFORMULA
- Data Cleaning (dedup, text functions)
- Basic Statistics (mean, median, STDEV)
- Excel Charts & Dashboards
Start with
- 2
SQL for Data Analysis
5–7 weeksSQL is the core language of data analysis. Learn SELECT, WHERE, GROUP BY, HAVING, JOINs, subqueries, CTEs, and window functions (ROW_NUMBER, RANK, LAG, LEAD). Practice on real datasets in PostgreSQL or BigQuery.
Skills to learn
- SELECT, WHERE, GROUP BY, HAVING
- INNER, LEFT, RIGHT, FULL OUTER JOINs
- Aggregations (COUNT, SUM, AVG)
- CTEs (Common Table Expressions)
- Window Functions (ROW_NUMBER, LAG, LEAD)
- Subqueries
- Date/Time Functions
- Query Optimisation (EXPLAIN, indexes)
- PostgreSQL / BigQuery / Snowflake
Start with
- 3
Data Visualisation with Tableau or Power BI
5–7 weeksBuild interactive dashboards that tell stories. Learn chart selection principles: when to use bar, line, scatter, or map charts. Create KPI scorecards, trend analyses, and drill-down dashboards. Publish to Tableau Public or Power BI Service.
Skills to learn
- Tableau Desktop (LOD expressions)
- Power BI (DAX, Power Query, data model)
- Looker / Looker Studio
- Dashboard Design Principles
- KPI Scorecards & Trend Analysis
- Chart Selection (bar, line, scatter)
- Data Storytelling (narrative structure)
- Figma for Dashboard Wireframing
Start with
- 4
Python for Data Analysis (Pandas & Matplotlib)
5–7 weeksGo beyond Excel with Python. Learn pandas for data manipulation, Matplotlib/Seaborn for visualisation, and NumPy for numerical operations. Automate repetitive reporting tasks and handle datasets too large for spreadsheets.
Skills to learn
- Python pandas (merge, groupby, pivot)
- Matplotlib & Seaborn
- Plotly (interactive charts)
- NumPy (array ops, statistics)
- Jupyter Notebooks
- Data Cleaning Automation
- Scheduled Reporting Scripts
- Web Scraping basics (requests, BeautifulSoup)
Start with
- 5
Build a Portfolio & Land Your First Analyst Role
4–6 weeksCreate 3–5 end-to-end analysis projects: pull data from a public source, clean it, analyse it, and build a dashboard or report. Post on Tableau Public and GitHub. Practise SQL interview questions. Apply broadly — data analysts are needed in every industry.
Skills to learn
- End-to-End Portfolio Projects (GitHub)
- Tableau Public (published dashboards)
- StrataScratch / DataLemur (SQL practice)
- A/B Test Analysis & Presentation
- Stakeholder Communication
- dbt Fundamentals (data modeling)
- Google Analytics 4 basics
- Google Data Analytics Certificate
Start with
jobroadmaps.com/roadmaps/data-analyst · Pay, demand and employer data for this role are further down the page.
Job Market Insights for Data Analyst
Data-backed
What do employers actually ask for?
Read from live job postings — how often each credential is named, from rare to almost always.
"Bachelor's degree" is the most common credential named, yet it appears only occasionally in what we could read. Postings that state it are the minority, but these counts are a floor, so do not read this as "no one asks".
Some postings say outright that equivalent experience or a self-taught route is accepted. That wording is worth reading closely when you see it.
Our read: a portfolio that proves the skill, and a referral from someone inside the company, usually carry more weight than a credential match on paper. That is judgement, not something these counts measure.
Requirement
How often named
Bachelor's degree
Master's degree
Computer Science background
Equivalent experience accepted
Our read: how often a credential is named is not how strictly it is enforced. Equivalent experience, a standout portfolio, or a referral often counts for more than the credential listed.
Data-backed
Which skills appear most in job postings?
Read from live job postings, ranked from most to least often named.
SQL is the most-named skill. Common, but not universal: many postings do not list it.
Past the fundamentals, 3 specialisation skills (SQL included) start separating candidates who can do the job from candidates who have done it. The 13 niche skills are named rarely enough that knowing them is upside, not prerequisite.
Skill
How often named
Data quality
Automation
Documentation
Data governance
Data visualization
Business acumen
ETL development
People analytics
Product analytics
A/B testing
Compliance analytics
Root cause analysis
Pricing strategy
Data storytelling
Sorted by how often named · JobRoadmaps
Data-backed
Which tools and artifacts appear most in job postings?
Read from live job postings, ranked from most to least often named.
Tableau is the most-named tool, but no tool is a universal requirement here.
Industry overlay
Targeting a specific industry?
The core roadmap gets you through the door anywhere. The difference between "qualified" and "they hired someone else" often lives in industry-specific context — the norms, the compliance floors, the tools assumed fluent in that sector.
Transaction data analysis
Payment and transaction datasets have unique structures (reversals, chargebacks, splits) — analysts must model them correctly.
Risk metric monitoring
Fraud rates, delinquency rates, and loss rates are monitored daily — analysts build the dashboards and own the alert thresholds.
Regulatory & compliance reporting
Financial regulators require precise, reproducible data reports — analysts produce these on strict deadlines with audit trails.
Customer acquisition cost (CAC) analysis
Fintech growth teams obsess over CAC/LTV ratios across channels — analysts attribute acquisition spend to eventual revenue.
Data governance & lineage
Financial data must be traceable to its source — analysts document transformations and flag discrepancies before reports go to regulators.
Companies hiring:
StripeBrexKlarnaChimeRobinhoodProduct funnel analysis
SaaS growth teams live in activation and conversion funnels — analysts define events, build funnels, and diagnose drop-off.
Cohort & retention analysis
Subscription businesses track cohort retention curves obsessively — building and interpreting these in SQL is table stakes.
Self-serve dashboard tooling (Looker/Mode)
SaaS data teams build internal dashboards for PMs and executives — LookML modelling and Looker Studio fluency are expected.
A/B test result interpretation
Product experiments run continuously — analysts calculate statistical significance, guard against peeking, and write readable reports.
Data quality monitoring
Tracking events break silently — analysts build dbt tests, anomaly detectors, and schema change alerts.
Companies hiring:
AmplitudeMixpanelHubSpotIntercomCanvaIndustry premiums based on aggregated job posting data · Updated quarterly
Interactive
How ready are you right now?
Check the skills you already have to see your current job-market fit.
The most-named skill for this role is SQL, so a gap there costs you the most. No single skill dominates, but each gap narrows which postings fit you. Check what you already have to see your biggest current gap.
Readiness Check
Check the skills you already have
0/5
base skills
Your biggest gap: SQL, the most often named of the skills you have not ticked.
Start there, then work down the list.
Books worth reading as a Data Analyst
Where to start, in order. The full list of 11, grouped by career stage, is on its own page.
Getting started
Practical SQL: A Beginner's Guide to Storytelling with Data, 2nd Edition
by Anthony DeBarros · 2018
~390 pages~10 hrs to read
Teaches SQL through real public datasets, covering joins, aggregation, statistics functions and data cleaning in PostgreSQL. A good first book for analysts who learn best by working on real data.
View book →
Naked Statistics: Stripping the Dread from the Data
by Charles Wheelan · 2013
~300 pages~8 hrs to read
A plain-language tour of averages, correlation, sampling, regression and inference using everyday examples. Read it early to build the statistical judgement that keeps analyses honest.
View book →
Doing the job
Python for Data Analysis, 3rd Edition
by Wes McKinney · 2011
~550 pages~14 hrs to read
Written by the creator of pandas, it covers loading, cleaning, reshaping and summarising tabular data in Python. Read it early, alongside real datasets, because nearly every later data task starts with these skills.
View book →SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition
by Anthony Molinaro, Robert de Graaf · 2005
~500 pages~13 hrs to read
Task-based recipes for window functions, pivoting, hierarchical queries, date handling and other problems that come up in real analysis. Keep it open once you are writing SQL daily.
View book →
Senior and leading
Trustworthy Online Controlled Experiments: A Practical Guide to A/B Testing
by Ron Kohavi, Diane Tang, Ya Xu · 2020
~200 pages~5 hrs to read
The reference on running A/B tests that you can believe: metric choice, pitfalls, sample ratio checks and experiment platforms. Read it when you own experimentation or advise a team on it.
View book →
Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
by Foster Provost, Tom Fawcett · 2013
~410 pages~10 hrs to read
Frames data science as a way to make business decisions, covering problem framing, evaluation and the trade-offs behind predictive models. A good fit for senior data scientists who must scope projects and explain their value to non-technical leaders.
View book →
All 11 books for a Data Analyst →Browse all books →
Some book links are affiliate links: we earn a small commission if you buy, at no cost to you. It does not affect what we list.
Courses and certifications for a Data Analyst
15 courses, tutorials and certifications, each read on the provider's own page. One from each stage to start; the full list, with a guide to choosing, is on its own page.
Getting started · Course
Google Data Analytics Professional Certificate
Google (on Coursera)
Doing the job · Course
Pandas
Kaggle Learn
Senior and leading · Course
Google Advanced Data Analytics Professional Certificate
Google (on Coursera)
Prerequisites & Education
What credentials do employers look for?
These are the most common paths into this role — no single one is required.
Education Level
View list — coming soon- Bachelor's in Statistics, Mathematics, Economics, or Computer Science
- Bachelor's in Business, Finance, or Psychology with strong quantitative coursework
- Bachelor's in any discipline with a data analytics bootcamp or self-study path
- No degree — demonstrated SQL, Python, and visualisation skills can substitute at many companies
Data Analyst is one of the most accessible data roles for career changers. SQL proficiency, solid Excel skills, and a portfolio demonstrating insight extraction carry significant weight.
Certifications
View list — coming soon- Google Data Analytics Professional Certificate (Coursera) — the most cited entry-level data cert in JDs
- Microsoft Power BI Data Analyst Associate (PL-300) — near-required for BI-heavy analyst roles
- Google Associate Data Practitioner — Google's entry-level data cert covering BigQuery, Looker Studio, and core data workflows; good first step for analysts working with Google Cloud data tools ($200)
- Google Cloud Professional Data Engineer — builds on Associate level; covers Dataflow, Pub/Sub, and large-scale pipeline design; valued at companies running analytics on GCP ($200)
- Tableau Desktop Specialist — valued wherever Tableau is the primary BI tool
- IBM Data Analyst Professional Certificate (Coursera) — broader coverage including Python and SQL
Google Data Analytics and Power BI Associate are the two most commonly listed certifications in data analyst job postings. Both are achievable in under 6 months with consistent effort.
Bootcamps & Training
View list — coming soon- DataCamp Data Analyst career track — structured, practical, covers SQL, Python, and visualisation
- Mode Analytics SQL Tutorial — free, hands-on SQL training respected in the industry
- Springboard Data Analytics Bootcamp — mentored with job-placement guarantee
- Khan Academy Statistics and Probability — essential foundations if your background is non-quantitative
DataCamp is widely used as supplemental training. More important is building real analysis projects — a portfolio of insights, not just completed exercises.
Portfolio & Other
View list — coming soon- SQL analysis project with a public dataset (NYC Taxi, Spotify, Stack Overflow) — hosted on GitHub with a clear findings summary
- Interactive Tableau or Power BI dashboard published to Tableau Public or Power BI service
- Python or R analysis notebook (Jupyter) with exploratory data analysis and visualisations
- End-to-end project: data cleaning → analysis → actionable recommendation with quantified impact
- Kaggle profile with completed datasets and notebooks showing analytical thinking
Data analyst portfolios live and die by the quality of insights, not just technical execution. Always frame findings as "what this means for the business" — not just what the data says.
Your Roadmap
5 stepsSpreadsheet Mastery with Excel & Google Sheets
4–6 weeksExcel is still the most used data tool in business. Master formulas (VLOOKUP, INDEX/MATCH, XLOOKUP), pivot tables, charts, and conditional formatting. Learn to clean and reshape data quickly. These skills get you hired at the entry level.
Skills to learn
SQL for Data Analysis
5–7 weeksSQL is the core language of data analysis. Learn SELECT, WHERE, GROUP BY, HAVING, JOINs, subqueries, CTEs, and window functions (ROW_NUMBER, RANK, LAG, LEAD). Practice on real datasets in PostgreSQL or BigQuery.
Skills to learn
Data Visualisation with Tableau or Power BI
5–7 weeksBuild interactive dashboards that tell stories. Learn chart selection principles: when to use bar, line, scatter, or map charts. Create KPI scorecards, trend analyses, and drill-down dashboards. Publish to Tableau Public or Power BI Service.
Skills to learn
Python for Data Analysis (Pandas & Matplotlib)
5–7 weeksGo beyond Excel with Python. Learn pandas for data manipulation, Matplotlib/Seaborn for visualisation, and NumPy for numerical operations. Automate repetitive reporting tasks and handle datasets too large for spreadsheets.
Skills to learn
Build a Portfolio & Land Your First Analyst Role
4–6 weeksCreate 3–5 end-to-end analysis projects: pull data from a public source, clean it, analyse it, and build a dashboard or report. Post on Tableau Public and GitHub. Practise SQL interview questions. Apply broadly — data analysts are needed in every industry.
Skills to learn
Start here this week
This week: find a public dataset that genuinely interests you — something you'd actually want to understand — and write 10 SQL queries against it. Not SELECT *. Real questions: which group had the highest rate? What changed between these two periods? Turn the output into a short document with a recommendation. That's your first portfolio piece.
For structured entry, Mode Analytics' SQL tutorial and Khan Academy's statistics courses are the free foundations. Google's Data Analytics Certificate on Coursera covers the full toolkit and is recognized at many companies as a signal of baseline competence. The portfolio matters more than the certificate — build it alongside the coursework, not after.
Pay
U.S. Department of Labor data for the nearest BLS occupation, Data scientists. BLS has no occupation for this exact title, so treat these as a benchmark.
Median: U.S. Bureau of Labor Statistics, Occupational Employment and Wage Statistics (median wage, May 2024) and Employment Projections (2024–34). Levels: U.S. Department of Labor Office of Foreign Labor Certification prevailing wage levels (wage year 2025, typical metro), a base-wage benchmark for the metro in the middle of 339 areas, not an offer. See every metro.
Job Titles at Each Level
Entry
Junior Data Analyst
Mid
Data Analyst / BI Analyst
Senior
Senior Data Analyst / Analytics Manager
Steps Overview
- 1
Spreadsheet Mastery with Excel & Google Sheets
4–6 weeks
- 2
SQL for Data Analysis
5–7 weeks
- 3
Data Visualisation with Tableau or Power BI
5–7 weeks
- 4
Python for Data Analysis (Pandas & Matplotlib)
5–7 weeks
- 5
Build a Portfolio & Land Your First Analyst Role
4–6 weeks
Explore more roadmaps
Not sure this is the right path? Browse all business career roadmaps.
View Similar RoadmapsBuilt a project while following this roadmap?
Turn it into a hiring-ready case study in 10 seconds — free.
Ready to explore more?
Browse all career roadmaps across tech, business, and creative fields.