Business Analytics Roadmap 2026
This 12-week Business Analytics roadmap takes you from the basics to a job-ready portfolio in 6 steps: Business Fundamentals, Excel & Modelling, SQL & Data Handling, Requirements & Process, Visualization & Storytelling, Case Studies & Capstone. 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: Business Fundamentals
Business modelsUnit economicsKPIs & metricsProblem structuring
Weeks 3–4
Step 2: Excel & Modelling
Advanced formulasScenario analysisForecastingWhat-if analysis
Weeks 5–6
Step 3: SQL & Data Handling
QueryingJoinsAggregationsData quality
Weeks 7–8
Step 4: Requirements & Process
BRD / FRDUser storiesProcess mapping (BPMN)Stakeholder management
Weeks 9–10
Step 5: Visualization & Storytelling
Tableau / Power BIExecutive decksInsight writing
Weeks 11–12
Step 6: Case Studies & Capstone
Market sizingPricing casesGuesstimatesCapstone
Job-ready!
Finish with the 7-day interview plan and start applying as Business Analyst, Product Analyst, Strategy Analyst.
Open 7-Day Job Prep