Data Analytics Roadmap 2026
This 14-week Data Analytics roadmap takes you from the basics to a job-ready portfolio in 6 steps: Excel for Analysis, SQL, Python for Analysis, Statistics for Analysts, Power BI / Tableau, Capstone & Portfolio. Each step has a free practice sheet and links to the interview questions you should be able to answer.
Your progressStart practicing
Weeks 1–2
Step 1: Excel for Analysis
Formulas & lookupsPivot tablesChartsData cleaning
Weeks 3–5
Step 2: SQL
SELECT & filteringJoinsGROUP BY & HAVINGWindow functionsCTEs
Weeks 6–7
Step 3: Python for Analysis
PandasCleaning pipelinesMatplotlibAutomation scripts
Week 8
Step 4: Statistics for Analysts
Mean, median, modeDistributionsCorrelationA/B testing basics
Weeks 9–11
Step 5: Power BI / Tableau
Data modellingDAX basicsDashboardsStorytelling
Weeks 12–14
Step 6: Capstone & Portfolio
Sales dashboardBusiness case studyGitHub portfolio
Job-ready!
Finish with the 7-day interview plan and start applying as Data Analyst, MIS Analyst, Reporting Analyst.
Open 7-Day Job Prep