Data Analytics Roadmap India 2026
Zero to Job-Ready in 6 Months — Week by Week
A month-by-month, week-by-week learning plan built for the Indian job market — SQL, Excel, statistics, Python, Power BI, and portfolio. Each month ends with a concrete skill checkpoint you can test yourself against before moving forward.
Follow This Roadmap with a Mentor →This roadmap assumes 1.5–2 hours of daily practice. That is 45–60 hours per month, or about 270–360 hours over 6 months. This is the minimum investment for confident interview performance, not passive watching of tutorials.
The most important rule: practise on real data, not toy examples. Every skill module below has a suggested Indian dataset. Use it. The difference between someone who completes the roadmap and someone who does not is consistently whether they did the practice or just watched the explanations.
SQL — The Foundation
Goal: Write confident queries on real datasets — the skill tested in 85% of Indian DA interviews.
- Understand tables, rows, columns, data types
- Write SELECT with WHERE, ORDER BY, LIMIT
- Filter with AND/OR/NOT, BETWEEN, IN, LIKE
- Practice tool: MySQL Workbench or SQLiteOnline (free, no install)
- Master INNER, LEFT, RIGHT JOIN — know when each applies
- GROUP BY + HAVING for aggregated filtering
- Window functions: ROW_NUMBER, RANK, LAG, LEAD
- Practice: write 5 queries on the Sakila sample database
Excel + Statistics Fundamentals
Goal: Excel proficiency + the statistical intuition that separates analysts from data entry operators.
- VLOOKUP / XLOOKUP, SUMIFS, COUNTIFS, IF/IFERROR
- Pivot tables: group by, filter, calculated field
- Data validation, conditional formatting
- Clean a messy real-world CSV — fix dates, remove duplicates, standardise city names
- Central tendency: mean vs median vs mode — when each misleads
- Spread: standard deviation, IQR, percentiles
- Correlation: when two columns move together (and when that is not causation)
- Outlier detection: IQR method + z-score in Excel
Python for Data Analysis
Goal: Automate what you can already do in Excel — and handle datasets that Excel cannot.
- Variables, lists, loops, functions — 5 hours then move on
- pandas: read_csv, head, info, describe, value_counts
- Filter rows, select columns, handle NaN
- GroupBy + aggregation: same logic as SQL GROUP BY
- Handle dates in pandas (pd.to_datetime, .dt.month)
- Merge DataFrames (like JOIN in SQL)
- Matplotlib + Seaborn: bar chart, line chart, histogram, heatmap
- Build a mini analysis on Indian dataset: 10 questions, 10 visualisations
Power BI — Dashboards That Tell Stories
Goal: Build a 3-page interactive dashboard that an interviewer can open and explore in 5 minutes.
- Connect CSV and Excel files. Transform in Power Query (fix data types, remove nulls, unpivot month columns)
- Build star schema: one fact table + Date, Product, Region dimensions
- Create a Date Table in DAX. Mark it as Date Table
- Understand filter context — why the same measure gives different results in different visuals
- Write 5 core measures: Total Revenue, MoM Growth, YTD Revenue, Unique Customers, Return Rate
- Add slicers, drill-through, cross-filter behaviour
- Design a 3-page dashboard: Executive Overview, Regional Detail, Product Analysis
- Publish to Power BI Service (free account) and share the view link
Portfolio — Show Your Work
Goal: Two completed, documented projects that prove business thinking, not just technical skill.
- Download Indian e-commerce dataset from Kaggle
- Write 10 SQL queries answering business questions (Pareto, MoM, cohort)
- Import into Power BI. Build 3-page dashboard
- Write a 150-word executive summary: what you found and what the business should do
- Choose Indian AQI, NSE, or IPL dataset
- Define a business question first, then analyse
- Jupyter notebook: clean → analyse → 3 visualisations → conclusion
- Push to GitHub with a full README (business question, data source, finding, tools used)
Interview Prep + Job Search
Goal: Land 3–5 technical interviews and convert at least one to an offer.
- SQL: practice 20 medium-level questions on LeetCode or HackerRank
- Python: solve 10 pandas problems (filter, merge, pivot, clean)
- Power BI: practise explaining your dashboard in 90 seconds without looking at it
- Statistics: prepare answers for "how would you detect an outlier" and "explain p-value to a non-technical person"
- 1-page resume: Summary + Skills + Projects (with links) + Education. No generic objective statement.
- Apply to 5 roles per day: LinkedIn, Naukri, Instahyre, AngelList for startups
- HR round prep: career switch story in 60 seconds, salary expectation (cite market data: ₹5–7 LPA fresher range in NCR)
- Mock interview: have a friend or mentor ask you "walk me through your project" — answer without notes
Month-End Checkpoints — Test Yourself Before Moving Forward
Do not move to the next month until you can honestly answer yes to the checkpoint. These are not gatekeeping tests — they are the minimum signals that you have internalised the skill, not just watched it.
Can you write a SQL query that finds the top 5 products by revenue in each city, using only one query?
Can you take a dirty CSV and produce a pivot table summary without Googling the formula?
Can you load a CSV in Python, clean it, group by category, and plot a bar chart — in under 20 minutes?
Do you have a Power BI dashboard link you can share from the Service, with slicers and at least 1 DAX measure?
Do you have 2 GitHub repos, each with a README that answers: business question, data source, key finding?
Can you explain your portfolio project in 90 seconds, answer follow-up questions, and state your salary expectation with market data?
Common Mistakes That Derail This Roadmap
Watching the same topic on 3 different YouTube channels before doing any practice. One resource + daily practice beats 5 resources + no practice.
SQL is faster to learn, more tested in interviews, and builds the data intuition that makes Python easier. Do not skip it.
Pair statistics with data — calculate mean, outliers, and correlation on a real dataset at the same time you read the definition. Theory without application does not stick.
A notebook full of visualisations is not a portfolio. Every project must start with "I want to find out whether..." and end with a specific, numbered finding.
Apply at the end of Month 5 while Month 6 interview prep is underway. You will not feel ready — that is normal. Recruiters do not see what you know; they see what you have built.
In the Indian market, LinkedIn Easy Apply, instahyre, and warm referrals collectively produce better interview-to-application ratios than Naukri for data analyst roles in 2026.
Frequently Asked Questions
How long does it take to become a data analyst in India from scratch?
With 1.5–2 hours of daily focused practice, most learners can reach interview-ready skill in 5–6 months. The key milestones are: Month 2 (SQL proficiency — can write queries companies actually test), Month 3 (Excel + basic Python — can handle real-world data tasks), Month 4 (Power BI dashboard and statistics fundamentals), Month 5 (first portfolio project complete), Month 6 (job search ready — resume, portfolio, interview prep). Learners with a quantitative background (BCom, BBA, BSc Stats, engineering) often progress faster. Learners from pure arts or humanities backgrounds take a month longer on average but reach the same destination.
Which skill should I learn first — SQL, Python, or Excel — to become a data analyst in India?
Learn SQL first. SQL appears in over 85% of Indian data analyst job descriptions, is the fastest to learn to a useful level (4–6 weeks), and is tested in nearly every technical interview. Once you can write confident SELECT, JOIN, GROUP BY, and subquery statements in SQL, switch to Excel (2–3 weeks to a useful level) and then Python. This order builds a mental model of data operations that makes Python and Power BI significantly easier to learn. The mistake most beginners make is starting with Python — it is a more powerful tool but takes longer to reach usefulness, and it will be interrupted by confusion if you have no data intuition yet.
Do I need a mathematics or statistics degree to become a data analyst in India?
No. The level of statistics required for a data analyst role in India is practical, not theoretical — you need to understand mean, median, standard deviation, correlation, and basic concepts like outliers and distributions. You do not need calculus, linear algebra, or probability theory for most data analyst roles (those are required for data scientist and ML engineer roles). The statistics you need can be learned in 3–4 weeks as a dedicated module. A BCom or BBA graduate with a good grasp of business context often performs better in interviews than an engineering graduate who knows the math but cannot explain what a finding means for a business decision.
Is Power BI or Tableau more important to learn for data analyst jobs in India?
Power BI is more important for the Indian market in 2026. It appears in roughly 3–4x more Indian job descriptions than Tableau, is used by the majority of Indian enterprises, banks, and GCCs, and is significantly cheaper (free desktop version vs Tableau Creator at ₹5,000+/month). Tableau has a stronger presence in multinational product companies and some BFSI firms. The recommendation: learn Power BI to interview-ready level first, then add Tableau as a secondary tool if the roles you are targeting specifically require it. The core skill — building a clean, insightful dashboard — transfers between tools; the syntax and interface are learnable in 1–2 weeks once you know one tool well.
What is the right order to learn data analytics topics in India?
The optimal learning order for Indian data analyst jobs is: (1) SQL — 4–6 weeks, (2) Excel with pivot tables and basic formulas — 2–3 weeks, (3) Statistics fundamentals — 3–4 weeks concurrent with Excel, (4) Python with pandas for data analysis — 4–5 weeks, (5) Power BI for dashboards — 3–4 weeks, (6) Portfolio project — 3–4 weeks, (7) Interview preparation and job search. This order is designed so each skill builds on the previous one, and so you have something concrete to show a recruiter by month 4 even before the full roadmap is complete.
EVIKA ACADEMY · NOIDA SECTOR 51 · LIVE TRAINING + MENTORSHIP
Follow this roadmap with expert guidance
Our structured programme follows exactly this 6-month roadmap with live classes, doubt sessions, guided portfolio projects, and mock interviews — so you do not have to figure out the path alone.
Book Free Demo Class →