Business and Data Analyst Roadmap for Freshers

Excel, SQL and a dashboard tool, plus the thinking to turn numbers into recommendations.

7 milestones · ~155 hours total

1. 1

   Excel and statistics basics

   ~25h

   Formulas, pivot tables, charts, mean, median, spread and correlation.

   Practice this →
2. 2

   SQL

   ~30h

   SELECT, WHERE, GROUP BY, joins and window functions on a real dataset.

   Practice this →
3. 3

   Data cleaning

   ~15h

   Handle missing values, duplicates and outliers in Excel or Python.

   Practice this →
4. 4

   Dashboards

   ~25h

   Build a dashboard in Power BI or Tableau with 5 useful KPIs.

   Practice this →
5. 5

   Business thinking

   ~20h

   Cohorts, churn, lifetime value, A/B tests and how to explain a finding to a manager.

   Practice this →
6. 6

   Capstone

   ~30h

   Analyse a public dataset, write a one-page recommendation and publish it.

   Practice this →
7. 7

   Interview rounds

   ~10h

   Take the Business Analytics rated tests; practise explaining a chart in 60 seconds.

   Practice this →