🗺️ Complete Roadmap · India · August 2026 · 14 min read

Data Analytics Roadmap
India 2026 — Zero to Job

5 phases · 6 months · the exact skills, projects and actions that get freshers and career changers hired as data analysts in India.

By Prashant Shukla · Data Analyst & Trainer, EVIKA Academy Noida Sector 51

🟢 Book Free Guidance Session

The 6-Month Timeline at a Glance

Month 1
Excel
✓ Sales dashboard project live on GitHub
Month 2
SQL
✓ E-commerce SQL analysis project
Month 3
Power BI
✓ HR dashboard published to Power BI Service
Month 4
Python (Part 1)
✓ EDA project on Kaggle dataset
Month 5
Python (Part 2) + AI Tools
✓ AI-assisted reporting workflow project
Month 6
Job Search
✓ 15–20 applications/week, mock interviews, offer

The 5-Phase Skill Roadmap — In Detail

📗
Phase 1
Excel & Spreadsheet Thinking
⏱ 4 Weeks
Why this phase matters: Excel is not just a tool — it teaches you how to think about data in rows, columns, aggregations and summaries. Every concept you learn here maps directly to SQL and Power BI later. Skip this and you will build on a weak foundation.
What you will learn
✓Cell references & named ranges (Week 1)
✓IF, IFS, nested IF logic (Week 1)
✓VLOOKUP, XLOOKUP, INDEX-MATCH (Week 2)
✓SUMIF, COUNTIF, AVERAGEIF (Week 2)
✓Pivot Tables & Pivot Charts (Week 3)
✓Power Query — cleaning & transforming data (Week 4)
✓Dashboard design basics (Week 4)
📁 Build this project: Build a Sales Performance Dashboard — monthly targets vs actuals, top products, region comparison, dynamic slicers.
💼 MIS Analyst, Reporting Analyst, Excel Operator — ₹3–5 LPA fresher roles.
View course →
🗄️
Phase 2
SQL — The Language of Data
⏱ 6 Weeks
Why this phase matters: SQL is asked in 85% of data analyst job descriptions in India. It is the single skill that unlocks your ability to pull, filter and aggregate data from any company database. No data analyst job is truly accessible without SQL.
What you will learn
✓SELECT, WHERE, ORDER BY, LIMIT (Week 1)
✓Aggregate functions — COUNT, SUM, AVG, MAX (Week 1–2)
✓GROUP BY and HAVING (Week 2)
✓INNER JOIN, LEFT JOIN, RIGHT JOIN (Week 3)
✓Subqueries and nested queries (Week 4)
✓CTEs — Common Table Expressions (Week 5)
✓Window functions — ROW_NUMBER, RANK, LAG, LEAD (Week 6)
📁 Build this project: E-commerce Order Analysis — top customers by revenue, monthly growth, return rate by product category, cohort retention.
💼 Data Analyst, Business Analyst — ₹4–7 LPA fresher roles. SQL alone opens 60% of analyst job applications.
View course →
📊
Phase 3
Power BI — Business Dashboards
⏱ 6 Weeks
Why this phase matters: Power BI appears in 70%+ of data analyst job descriptions in Delhi NCR. It is how businesses visualise data for decisions. Learning Power BI after SQL means you can pull the data AND present it — which is exactly the end-to-end workflow companies want.
What you will learn
✓Data import and transformation (Power Query in Power BI) (Week 1)
✓Data modelling — relationships between tables (Week 2)
✓DAX basics — calculated columns and measures (Week 3)
✓Intermediate DAX — CALCULATE, FILTER, time intelligence (Week 4)
✓Report design — charts, cards, slicers, drill-throughs (Week 5)
✓Publishing to Power BI Service and sharing (Week 6)
📁 Build this project: HR Attrition Dashboard — which departments have highest attrition, at what salary band, age group, and tenure level. With drill-through to individual department view.
💼 Data Analyst, BI Analyst, MIS Analyst — ₹5–9 LPA. SQL + Power BI together opens 75% of analyst job applications in India.
View course →
🐍
Phase 4
Python — Automation & Advanced Analysis
⏱ 8 Weeks
Why this phase matters: Python is what separates ₹6 LPA analysts from ₹12 LPA analysts. It handles datasets too large for Excel, automates repetitive reporting, and opens up machine learning. You do not need to know everything — you need Pandas, NumPy and Matplotlib well.
What you will learn
✓Python basics — variables, lists, loops, functions (Week 1–2)
✓Pandas — loading, filtering, grouping, merging data (Week 3–4)
✓NumPy — numerical operations and arrays (Week 4)
✓Exploratory Data Analysis (EDA) (Week 5)
✓Matplotlib & Seaborn — data visualisation in Python (Week 6)
✓Handling missing data and outliers (Week 7)
✓Connecting Python to SQL databases (Week 8)
📁 Build this project: Zomato or IPL Dataset EDA — distribution analysis, outlier detection, correlation heatmap, business insights summary with charts.
💼 Senior Data Analyst, Data Scientist (junior) — ₹7–14 LPA. Full stack (Excel + SQL + Power BI + Python) opens 90%+ of analyst JDs.
View course →
🤖
Phase 5
AI Tools & Prompt Engineering
⏱ 3–4 Weeks
Why this phase matters: In 2026, companies expect analysts to use AI tools to work faster. Knowing how to use ChatGPT to write SQL, Copilot to summarise dashboards, and prompt engineering to automate reporting gives you a visible edge over candidates who do the same things manually.
What you will learn
✓ChatGPT and Claude for SQL writing and debugging (Week 1)
✓Microsoft Copilot in Excel and Power BI (Week 2)
✓Prompt engineering techniques for business use (Week 2–3)
✓AI for data cleaning and EDA automation (Week 3)
✓Building AI-assisted reporting workflows (Week 4)
📁 Build this project: Build an AI-assisted monthly reporting workflow — SQL pulls data, Python cleans it, Power BI visualises it, and AI summarises the key findings automatically.
💼 AI-enabled Data Analyst — ₹8–15 LPA. This is the profile most in demand at Delhi NCR companies in 2026.
View course →

Do These in Parallel — Throughout the Roadmap

Action
Upload projects to GitHub
When: After each project (Phases 1–4)
GitHub is your portfolio. Recruiters and interviewers check it. A clean repo with a good README makes your project count 10× more than a certificate.
Action
Build your LinkedIn profile
When: After Phase 2 (SQL done)
Add every skill as you learn it. Set headline to "Data Analyst | Excel · SQL · Power BI · Python." Turn on Open to Work. Recruiters search for these keywords every day.
Action
Start applying from Phase 3
When: Do not wait until Phase 5
Interview rejections teach you faster than any course. Apply from Phase 3 onwards. Feedback from real interviews tells you exactly what to practise next.
Action
Practise SQL daily for 20 minutes
When: Throughout Phases 3–5
SQL questions appear in 85% of data analyst technical rounds. Speed and confidence come from repetition, not from reading.

5 Mistakes That Slow Most People Down

✗Trying to learn all tools at the same time
✓One tool, one month. Depth before breadth.
✗Watching tutorials without practising
✓For every 1 hour of watching, spend 2 hours practising on a real dataset.
✗Waiting until you feel "ready" to apply
✓Start applying from Month 3. Interview feedback is faster learning than any course.
✗Building weak projects on toy datasets
✓Use real, messy datasets from Kaggle or data.gov.in. The harder the data, the better the project.
✗No GitHub profile
✓Every project goes on GitHub with a README. This is your portfolio — your certificate alone is not.

Frequently Asked Questions

Q: How long does it take to become a data analyst in India from scratch?
With focused daily practice of 1.5–2 hours, the foundational roadmap (Excel, SQL, Power BI, Python basics) takes about 5 months. Adding AI tools and job search, most people land their first role in 7–9 months from complete zero. People with some existing Excel or programming experience can move faster — some complete the core roadmap in 4 months.
Q: Which tool should I learn first — SQL or Excel?
Excel first. Excel teaches you to think about data in a visual, intuitive way — rows, columns, filters, aggregations — before you write a single line of code. This mental model makes SQL much easier to learn as the second step. People who jump straight into SQL without Excel often struggle with the logical structure of queries.
Q: Is Python necessary to get a data analyst job in India?
No — not for your first job. Excel + SQL + Power BI is enough to apply to and clear the majority of entry-level data analyst roles in India. Python becomes essential for senior analyst, data scientist and automation-focused roles. Learn it in Month 4–5 to expand your options and increase your starting salary target.
Q: Can I follow this roadmap while working a full-time job?
Yes. Each phase requires about 1.5–2 hours of daily practice. If you give 1.5 hours on weekdays and 3 hours on weekends, the 5-phase roadmap takes about 7–8 months instead of 6. The weekend batch at EVIKA Academy is specifically designed for working professionals who are upskilling alongside a job.
Q: Do I need to know mathematics to become a data analyst?
Basic mathematics — percentages, averages, ratios, growth rates — is used regularly. Advanced calculus or linear algebra is not needed for analyst roles (it is needed for data scientist and ML engineer roles). If you can calculate a percentage change in Excel, you have enough maths for most data analyst work.
Deep-Dive Guides — One for Each Phase
→ 📗 Excel Course Noida — Full Details→ 🗄️ SQL Course Noida — Full Details→ 📊 Power BI Course Noida — Full Details→ 🐍 Python Course Noida — Full Details→ 🤖 AI Course Noida — Full Details→ 🎓 4-Month Bootcamp — All Phases Combined→ 🗄️ SQL Interview Questions 2026→ 🚀 Get a Data Analyst Job — No Experience→ 📁 Portfolio Projects for Freshers→ 💰 Data Analyst Salary in India 2026
📍 EVIKA ACADEMY · NOIDA SECTOR 51 · ONLINE ACROSS INDIA

Follow This Roadmap With Live Guidance — Not Just a Video

EVIKA Academy covers all 5 phases — live classes, real projects, placement support. Join as individual modules or the full 4-month Bootcamp.

📗 Excel ₹4,999🗄️ SQL ₹5,999📊 Power BI ₹5,999🐍 Python ₹6,999🤖 AI ₹5,999🎓 Bootcamp ₹19,999
🟢 WhatsApp — Book Free Demo📞 Call Now