🗺️ Career Guide · June 2026 · 10 min read

How to Become a Data Analyst in India — Complete 2026 Roadmap

A step-by-step guide from Prashant Shukla — Data Analyst with 10+ years of experience at leading MNCs

Data analyst is one of the most in-demand jobs in India right now. Companies across Noida, Gurgaon, Bangalore and Hyderabad are actively hiring — and the salaries have jumped significantly in the past 3 years.

But the question I get from every student is: "I don't know where to start. There is so much online — SQL, Python, Power BI, Tableau, R, statistics. What do I actually do first?"

In this guide I will give you the exact roadmap I would follow if I were starting fresh in 2026.

Who Can Become a Data Analyst?

Anyone with basic computer skills. I have trained students with backgrounds in engineering, commerce, arts, biology, and even hotel management. Your degree does not matter as much as your ability to learn tools and solve problems with data.

The 5-Step Roadmap to Your First Data Analyst Job

STEP 01

Excel — Start Here (Month 1)

  • Master formulas: VLOOKUP, INDEX-MATCH, IF, SUMIF, COUNTIF
  • Build pivot tables and pivot charts
  • Create business dashboards with conditional formatting
  • Learn Power Query for data cleaning
  • Timeline: 3–4 weeks of daily practice
STEP 02

SQL — Your Most Hired Skill (Month 2)

  • Write SELECT, WHERE, GROUP BY, ORDER BY queries
  • Master JOINs — INNER, LEFT, RIGHT, FULL OUTER
  • Subqueries, CTEs, window functions (ROW_NUMBER, RANK)
  • Practice on real databases: MySQL or PostgreSQL
  • Timeline: 4–5 weeks
STEP 03

Power BI — Make Your Data Visual (Month 3)

  • Connect to Excel, SQL databases, and CSV files
  • Build interactive reports with slicers and filters
  • Learn DAX basics: CALCULATE, SUMX, RELATED
  • Publish dashboards and share with stakeholders
  • Timeline: 3–4 weeks
STEP 04

Python — Add Automation (Month 4)

  • Pandas — read, clean, filter, merge datasets
  • NumPy — numerical operations and statistics
  • Matplotlib / Seaborn — create visualizations
  • Jupyter Notebook — document your analysis
  • Timeline: 4 weeks
STEP 05

Portfolio + Job Hunt (Month 4–5)

  • Build 3–4 projects on real datasets (sales, HR, e-commerce, finance)
  • Upload everything to GitHub with clear README files
  • Optimize your LinkedIn profile with keywords recruiters search
  • Practice 50+ interview questions: SQL, Excel, scenario-based
  • Apply to 20+ jobs per week — do not wait until you feel "ready"

How Long Does It Take to Get a Data Analyst Job?

  • Freshers with 3–5 hours/day of focused practice: 4–5 months
  • Working professionals with 1–2 hours/day: 6–8 months
  • With good placement support and a strong portfolio: first interview calls usually start in month 4

Data Analyst Salary in India 2026

₹3.5–6 LPA
Entry Level (0–2 yrs)
₹6–12 LPA
Mid Level (2–5 yrs)
₹12–25 LPA
Senior Level (5+ yrs)

The Most Common Mistakes I See From Beginners

  1. Trying to learn everything at once — Excel, Python, Tableau, R, ML simultaneously. Focus on one tool at a time.
  2. Only watching videos without practicing — you must write SQL queries every day, not just watch someone else do it.
  3. Not building a portfolio — certificates alone will not get you hired. Real projects on GitHub will.
  4. Waiting until you feel "ready" to apply — start applying when you finish steps 1–3. Interviews teach you what to learn next.
  5. Choosing the wrong course — a theoretical course with no placement support sets you back 6 months.

Start Your Data Analyst Journey at EVIKA Academy

4-month bootcamp — Excel, SQL, Power BI, Python — Noida Sector 51 + Online. July batch open.

🟢 Book Free Demo on WhatsApp
← Back to Blog