Data Analyst After B.Tech

The fastest route into data roles: SQL, spreadsheets, visualisation and business storytelling.

7 milestones · ~220 hours total

1. 1

   Spreadsheets and statistics

   ~25h

   Excel or Sheets formulas, pivot tables, descriptive statistics, distributions and basic probability.

   Practice this →
2. 2

   SQL in depth

   ~40h

   Joins, grouping, window functions, CTEs and writing queries that answer a business question.

   Practice this →
3. 3

   Python for data

   ~40h

   pandas and NumPy for cleaning, reshaping and summarising real, messy datasets.

   Practice this →
4. 4

   Visualisation and dashboards

   ~30h

   Choose the right chart, build dashboards in Power BI, Tableau or Python, and avoid misleading visuals.

   Practice this →
5. 5

   Experiment and metrics thinking

   ~20h

   Define metrics, A/B testing basics, cohorts, funnels and retention.

   Practice this →
6. 6

   Portfolio projects

   ~40h

   Three analyses on public data with a clear question, method and recommendation each.

   Practice this →
7. 7

   Interview preparation

   ~25h

   SQL puzzles, case questions, statistics questions and explaining a chart to a non-technical manager.

   Practice this →