Excel is still the most-used data tool in Indian companies. Master pivot tables, VLOOKUP, conditional formatting, and data cleaning before anything else.
By the end, you'll be able to
Mini-project
Analyze a sales dataset in Excel: create a dashboard with pivot tables showing revenue by region, product, and month. Add slicers for interactivity.
SQL is the #1 skill for data analysts. Learn SELECT, JOINs, GROUP BY, window functions, CTEs, and how to extract insights from databases.
By the end, you'll be able to
Mini-project
Solve 40 SQL problems on HackerRank/LeetCode. Then write queries to answer 10 business questions on a sample dataset.
Python automates what Excel can't. Learn Pandas for data manipulation, Matplotlib/Seaborn for visualization, and Jupyter notebooks for analysis workflows.
By the end, you'll be able to
Mini-project
Analyze the Swiggy or Zomato restaurant dataset: pricing trends, ratings by cuisine, delivery times. Create 10 insightful visualizations.
Learn the stats that matter for analysis: averages, distributions, correlation, hypothesis testing, and A/B testing. Skip the theoretical proofs — focus on practical application.
By the end, you'll be able to
Mini-project
Analyze an A/B test from a sample e-commerce dataset. Present your findings as a 1-page business memo.
Dashboards are how analysts communicate. Learn one BI tool deeply: connecting data, building charts, creating interactive dashboards, and publishing them.
By the end, you'll be able to
Mini-project
Build a COVID-19 India dashboard in Tableau Public: state-wise trends, vaccination progress, and recovery rates. Publish it.
80% of analysis is cleaning data. Learn to handle missing values, duplicates, inconsistent formats, and how to build reliable data pipelines.
By the end, you'll be able to
Mini-project
Take a deliberately messy dataset and clean it: fix dates, handle nulls, remove duplicates, standardize categories. Document every step.
Know what to measure. Learn common business metrics: CAC, LTV, churn, retention, conversion funnels, unit economics, and how to track them.
By the end, you'll be able to
Mini-project
Build a product analytics dashboard for a fictional SaaS company: MRR, churn, DAU/MAU, funnel conversion, and cohort retention.
Build 3 analysis projects that showcase your skills: one with SQL, one with Python, one with a BI tool. Write clear narratives explaining your insights.
By the end, you'll be able to
Mini-project
Create a portfolio with 3 projects: (1) SQL analysis of an e-commerce dataset, (2) Python EDA of a public dataset, (3) Tableau dashboard of Indian economic data.
Data analyst interviews test: SQL (heavy), Excel, statistics, case studies, and behavioral questions. SQL is the most important — practice it daily.
By the end, you'll be able to
Mini-project
Solve 50 SQL problems, practice 5 case studies, and do 2 mock interviews. Apply to 20+ analyst roles.
Not sure if this is the right roadmap? Browse all our career paths and find the one that matches your goals.