← Blog
🎯 COMPLETE CAREER GUIDE · INDIA 2026

How to Become a Data Analyst
in India in 2026 — Step by Step

A practical, no-fluff guide to going from zero to your first data analyst job in India — what skills to learn, in what order, how to build a portfolio, and how to find your first role in Delhi NCR or anywhere in India.

Updated August 2026India job market25 min read7 FAQs
Jump to:Who can become one?5-Phase RoadmapSkills neededDegree vs SkillsPortfolioJob searchSalaryCommon mistakesFAQ

Who Can Become a Data Analyst in India?

The short answer: almost anyone willing to invest 4–6 months in learning the right skills. Data analytics is one of the few tech-adjacent careers in India where your degree matters less than what you can demonstrate.

BCA⭐⭐⭐⭐⭐Computer application background — picks up SQL and Python fastest. Very strong fit.
BTech (CS / IT)⭐⭐⭐⭐⭐Strong technical base. Needs to focus specifically on analytics tools and business context.
BTech (non-CS)⭐⭐⭐⭐Logical thinking transfers well. Excel and SQL are learnable — some extra effort needed.
BBA / MBA⭐⭐⭐⭐Business context is a genuine advantage. SQL and Power BI are learnable. Business analyst roles are a natural fit.
BCom / MCom⭐⭐⭐⭐Finance and accounting domain knowledge is valuable. Excel is familiar. SQL and Power BI are the additions needed.
BSc Math / Statistics⭐⭐⭐⭐⭐Statistical foundation is the hardest part — already there. Python and SQL make you extremely competitive.
BA / Other arts⭐⭐⭐More learning required, but absolutely doable. Many successful analysts in India come from non-quantitative backgrounds.

The real barrier is not your degree — it is whether you can write a SQL query, build a Power BI dashboard, and explain your analysis clearly. A motivated BCom graduate who learns these skills will out-interview a BTech graduate who relies only on their degree.

The 5-Phase Data Analyst Roadmap for India 2026

Most online advice gives you a confusing mix of tools without a clear sequence. This roadmap is specific to the Indian job market — what employers in Noida, Gurugram, Mumbai, and Bangalore actually test in interviews.

Phase 1Weeks 1–6

Master Excel

What to learn
  • VLOOKUP / XLOOKUP / INDEX-MATCH
  • SUMIF, COUNTIF, pivot tables
  • Power Query — connect, clean, transform
  • Dashboard design with slicers
Milestone

Build a complete MIS dashboard. This alone qualifies you for MIS Analyst roles (₹2.5–4 LPA).

Free Excel Tutorials →
Phase 2Weeks 7–14

Learn SQL

What to learn
  • SELECT, WHERE, GROUP BY, ORDER BY
  • INNER JOIN, LEFT JOIN, subqueries
  • Window functions: ROW_NUMBER, RANK, LAG
  • CTEs and query optimisation basics
Milestone

Write complex queries on real databases. SQL + Excel is the combination that gets you into interviews at most companies.

Free SQL Tutorials →
Phase 3Weeks 15–22

Add Power BI

What to learn
  • Power Query — advanced transforms
  • Star schema data modelling
  • DAX: CALCULATE, FILTER, time intelligence
  • Interactive reports and row-level security
Milestone

Build a professional BI report with DAX measures. SQL + Excel + Power BI = strong candidate for ₹4–7 LPA analyst roles.

Free Power BI Tutorials →
Phase 4Parallel — start applying

Build Your Portfolio

What to learn
  • Choose 2–3 real datasets (IPL, e-commerce, finance)
  • Complete EDA: cleaning → analysis → visualisation
  • Publish on GitHub with a clear README
  • Screenshot your Power BI dashboard for LinkedIn
Milestone

One strong project beats 10 certificates. Portfolio is what gets you callbacks, not qualifications.

Portfolio project ideas →
Phase 5Month 5–6

Add Python (for mid-level)

What to learn
  • Pandas: DataFrames, groupby, merging
  • NumPy for numerical analysis
  • Matplotlib and Seaborn for visualisation
  • Automating Excel reports with openpyxl
Milestone

Python opens mid-level roles (₹7–12 LPA). Not required for entry-level — add it after you are earning.

Free Python Tutorials →

Data Analyst Skills — Hard vs Soft

Hard Skills (Technical)

SQL95% of jobs
Excel / Power Query90% of jobs
Power BI / Tableau85% of jobs
Python (Pandas)70% of jobs
Statistics basics60% of jobs

Soft Skills (Often Overlooked)

✓
Communication — explaining data to non-technical stakeholdersCritical
✓
Business understanding — knowing what the numbers mean in contextCritical
✓
Attention to detail — catching errors in data before presentingHigh
✓
Problem framing — defining the right question before analysingHigh
✓
Time management — delivering reports on deadlineHigh

Building a Portfolio — What Actually Gets You Hired

Certificates tell interviewers you completed a course. A portfolio tells them you can do the job. In the Indian job market, a strong portfolio project consistently beats an extra certification.

✗

Bad portfolio project

  • "I analysed the Titanic dataset" — every data course uses this. Interviewers are bored of it.
  • "I built a sales dashboard" — no context, no business question, no insight. Just pretty charts.
  • A project from a tutorial you followed step-by-step without changing anything.
✓

Good portfolio project

  • "I analysed 3 years of IPL data to find which batting position has the highest win contribution in T20 chases."
  • "I cleaned and analysed Swiggy/Zomato data from Kaggle to identify peak demand hours by city — with a Power BI dashboard."
  • "I automated our college fee collection MIS report (with permission) — reduced manual work from 4 hours to 20 minutes."

Where to publish your portfolio

GitHub
Upload your Python / SQL code. Write a clear README explaining your project.
LinkedIn
Post a screenshot of your Power BI dashboard with 3 key findings. This gets seen by recruiters.
Novypro
Free platform to publish Power BI reports online without a paid Microsoft subscription.
Kaggle
Post your EDA as a notebook. Kaggle profiles are checked by data-savvy interviewers.

How to Find Your First Data Analyst Job in India

1

Fix your LinkedIn headline

Change it from "Looking for opportunities" to "Data Analyst | SQL · Power BI · Excel | Open to roles in Delhi NCR". Recruiters search by skills, not intent.

2

Apply on Naukri first

Naukri.com is the primary job portal for data analyst roles in Delhi NCR. Set up job alerts for "data analyst Noida", "MIS analyst Noida", "business analyst Noida". Apply within 24 hours of posting — recency matters.

3

Target BPOs and KPOs first

Genpact, EXL, WNS, Concentrix, and similar firms in Noida hire analysts in batches. Easier to get the first job here — then move up. Entry-level volumes are high and they actively hire freshers with the right skills.

4

Prepare for SQL rounds

Most analyst interviews in India include a live SQL test. Practice writing queries without looking at notes. The 30-day SQL series on this site covers 150+ interview-level questions.

5

Prepare a 5-minute project walkthrough

Be ready to share your screen and walk the interviewer through your portfolio project. Explain: what data you used, what question you answered, what you found, what business decision it enables.

6

Network on LinkedIn actively

Connect with data analysts at companies you want to work for. Comment on their posts. This gets your profile seen by recruiters at those companies — often before a job is even posted.

Data Analyst Salary Progression in India 2026

Fresher — 0 experience, Excel + SQL skills
MIS analyst, junior data analyst, reporting analyst
₹3 – 5 LPA
Junior — 1–2 years, SQL + Power BI + Excel
Data analyst at BPO, bank, or mid-size company
₹5 – 8 LPA
Mid — 3–4 years, all tools + Python + business context
Senior analyst, business intelligence analyst
₹8 – 14 LPA
Senior — 5–7 years, leading projects and juniors
Lead analyst, analytics manager track
₹14 – 22 LPA
Analytics Manager — 8+ years, owning function
Head of analytics, VP of data at larger companies
₹20 – 40 LPA

Salary data based on Delhi NCR job market as of 2026. Figures vary by company size, sector, location, and individual negotiation skills.

7 Mistakes Beginners Make (and How to Avoid Them)

✗Learning tools in the wrong order
✓Start with Excel → SQL → Power BI. Python comes 4th. Most beginners jump to Python first and struggle because they lack data intuition.
✗Collecting certificates instead of building skills
✓One real project beats five certificates. Stop hoarding Udemy completions — build something and publish it.
✗Studying theory without writing code
✓You learn SQL by writing queries, not reading about them. Practice with a real database from day one.
✗Waiting until you feel "ready" to apply
✓Apply for jobs when you have Phase 1–3 complete (Excel + SQL + Power BI). The interview process itself teaches you what gaps to fill.
✗Ignoring business context
✓An analyst who says "I found this pattern in the data" without explaining what it means for the business is half-done. Always connect your analysis to a decision.
✗Not practising SQL live
✓Most analyst interviews involve writing SQL in front of the interviewer. Practice on paper and in a live editor — not just in tutorials.
✗Applying to 200 jobs with the same generic CV
✓Tailor your CV headline and summary to each role. Three targeted applications outperform thirty generic ones.

Frequently Asked Questions

Can I become a data analyst without a computer science degree in India?

Yes — many successful data analysts in India come from commerce, arts, economics, and non-CS engineering backgrounds. What matters is your skill set: SQL, Excel, Power BI, and Python. Companies like Genpact, EXL, and most BPOs in Delhi NCR actively hire non-CS graduates for analyst roles. A structured course and a strong project portfolio matter more than your degree in most hiring decisions.

How long does it take to become a data analyst in India?

With dedicated daily practice of 2–3 hours, most beginners become job-ready in 4–6 months. If you follow a structured course (like EVIKA ACADEMY's programme), you can get interview-ready in 3–4 months. The fastest path: Excel (4–6 weeks) → SQL (6–8 weeks) → Power BI (6–8 weeks) → apply for entry-level roles while learning Python.

What is the starting salary for a data analyst fresher in India?

Fresher data analyst salaries in India range from ₹2.5 LPA to ₹5 LPA depending on the company, city, and skills. In Delhi NCR (Noida, Gurugram), entry-level analyst roles with Excel + SQL skills typically start at ₹3–4 LPA. Adding Power BI to your profile often pushes starting offers to ₹4–5 LPA.

Which degree is best for data analytics in India?

There is no single "best" degree — BCA, BBA, BCom, BTech, BSc in Math/Stats, and MBA graduates all work in data analytics. What matters is the skills you build on top of your degree. A BCom graduate with strong SQL, Excel, and Power BI will get more calls than a BTech graduate who only knows Python theory. Skills beat degree every time in the Indian analytics job market.

Is data analytics in demand in India in 2026?

Yes — data analytics is among the top 5 most in-demand skill areas in India in 2026. Job portals like Naukri and LinkedIn show tens of thousands of open data analyst positions across India at any given time. Delhi NCR, Mumbai, Bangalore, Hyderabad, and Pune have the highest concentration of roles. Demand consistently outpaces supply of skilled candidates.

Do I need to know coding to become a data analyst?

Not initially — SQL is query writing, not traditional programming, and Power BI requires no coding at all. Excel is entirely GUI-based. For entry-level roles, these three tools are sufficient. Python (which is coding) becomes important for mid-level roles — but by the time you need it, you will have months of analytics experience that makes learning Python much easier.

What is the difference between a data analyst and a business analyst in India?

A data analyst is more technical — focused on querying data, building dashboards, and producing analytical reports. A business analyst is more process and strategy-oriented — focused on requirements gathering, process improvement, and translating business needs into solutions. In practice, the roles overlap significantly in Indian companies, especially at mid-size firms where one person does both.

Continue Learning

What is Data Analytics? Complete Guide →SQL + Python + Power BI Career Stack →Data Analyst Portfolio Projects →SQL 30-Day Interview Series →Excel 30-Day Interview Series →Data Analytics Course in Noida →

EVIKA ACADEMY · NOIDA SECTOR 51

Ready to start your data analyst journey?

Join our structured data analytics programme at Noida Sector 51. Live classes, real projects, interview prep, and placement support. Free demo — no commitment.

Book Free Demo Class →Free Student Kit 🎓