CM
The Career Machine
Skip to main content
All Roadmaps
Free Career Roadmap

Become a Data Analyst

Turn raw numbers into business decisions

Duration
12 months
Salary Range
$50k – $130k
Difficulty
entry friendly
Job Demand
high
4
Phases
17
Skills to Learn
10
Projects
2
Certifications
Phase 1 · Months 1–2

Data Fundamentals

Excel, SQL, and statistical thinking.

Recommended Projects

Public dataset analysis in Excel
100 SQL exercises on HackerRank
Monthly sales report template

Industry Certifications

Google Data Analytics (Coursera)

Key Milestones (3)

SQL joins & aggregations mastered
Google Data Analytics cert
2 Excel case studies
Phase 2 · Months 3–5

Visualization & Python

Tableau, Power BI, and Python for data.

Junior Data Analyst: $50k – $75k

Recommended Projects

Interactive Tableau dashboard
Python EDA notebook
Customer segmentation analysis

Industry Certifications

Tableau Desktop Specialist ($100)

Key Milestones (3)

Tableau certified
3 published Tableau Public dashboards
Python portfolio on GitHub
Phase 3 · Months 6–9

Advanced Analytics

A/B testing, statistical modeling, business analytics.

Data Analyst: $75k – $110k

Recommended Projects

Statistical A/B test analysis
Marketing campaign ROI model
Customer LTV calculator

Key Milestones (3)

Designs statistically valid A/B tests
5 analytical case studies
Contributing to team decisions
Phase 4 · Months 10–12

Land Your Analyst Role

Target data-driven scaleups and tech giants.

Data Analyst: $70k – $130k

Recommended Projects

Portfolio case study deck

Key Milestones (3)

30+ applications
10+ interviews
First data analyst role

Job Ready — Data Analyst

Completing this pathway equips you with verified projects, assessment scores, and the exact skills required by current hiring managers.