How to Become a Data Analyst in India: Step-by-Step

Short answer

To become a data analyst in India, learn in this order: (1) Excel, (2) SQL, (3) one BI tool (Power BI or Tableau), (4) basic statistics, (5) Python for data (pandas), then build 3–4 portfolio projects on real-looking data and apply for analyst, MIS, reporting and business analyst roles. A specific degree helps but is not the only route; employers mainly test whether you can clean data, answer business questions and explain results clearly.

This is the same order we follow in YUNOVA's Data Analysis skill. It's not the only route, but it's one that keeps every step useful even if you stop halfway.

What does a data analyst actually do?

• Collects data from sheets, databases or tools
• Cleans it (duplicates, blanks, wrong formats)
• Analyses it to answer questions: "Which region's sales fell? Why?"
• Builds reports and dashboards
• Explains findings to non-technical people

Job titles vary: Data Analyst, MIS Analyst, Reporting Analyst, Business Analyst, Operations Analyst. Read job posts in your city to see which tools they list.

The roadmap

Stage 1: Excel (foundation)

• Formulas: IF, SUMIFS, COUNTIFS, XLOOKUP, TEXT, date functions
• Pivot tables, charts, conditional formatting
• Data cleaning: TRIM, Text to Columns, Remove Duplicates
• Start here: Excel formulas in Hindi

Milestone: a one-page sales dashboard in Excel.

Stage 2: SQL

• SELECT, WHERE, ORDER BY
• GROUP BY with SUM/COUNT/AVG
• JOINs (INNER, LEFT)
• Subqueries, CASE WHEN, window functions (later)
• Beginner guide: SQL for beginners in Hindi

Milestone: answer 20 business questions from a sample sales database.

Stage 3: Power BI or Tableau

• Import and transform data (Power Query in Power BI)
• Data model and relationships
• Measures (DAX basics in Power BI)
• Interactive dashboard with filters
• Which first? Power BI vs Excel

Milestone: a published dashboard with 3–4 pages.

Stage 4: Statistics basics

• Mean, median, mode, standard deviation
• Percentiles, distributions
• Correlation vs causation
• A/B test idea, sampling

You don't need advanced maths to start, but you must know when an average misleads.

Stage 5: Python for data

• Python basics: Python roadmap in Hindi
• pandas: read CSV, clean, group, merge
• matplotlib/seaborn for charts
• Jupyter notebooks

Milestone: one end-to-end analysis notebook.

Skills table

Skill	Why it matters	Priority
Excel	Used in almost every office	Must
SQL	Most company data sits in databases	Must
Power BI / Tableau	Dashboards for managers	Must (one of them)
Statistics	Correct conclusions	Must (basics)
Python	Bigger data, automation	Strongly useful
Communication	Explaining results	Must
Domain knowledge	Sales, finance, HR, e-commerce context	Grows with time

Portfolio: what to build

Pick public datasets (government open data portals, Kaggle) or create realistic fake data.

1. Sales analysis: Excel/Power BI dashboard, region and product trends.
2. SQL case study: 15–20 questions with queries and answers in a README.
3. Python notebook: cleaning a messy dataset and 5 insights with charts.
4. Business story: a 1-page PDF with recommendation, for a non-technical reader.

Host on GitHub or Google Drive, link from your resume and LinkedIn.

How to apply

• Target entry roles: MIS executive, junior data analyst, reporting analyst, analyst intern.
• Tailor the resume to each job post: resume format for freshers.
• Expect a test: Excel tasks, SQL queries or a take-home dataset.
• Prepare to walk through one project in 3 minutes: question → data → method → insight → recommendation.

Common mistakes

1. Watching courses without building anything.
2. Learning five tools half-way instead of three tools properly.
3. Copying portfolio projects line by line from tutorials.
4. Ignoring Excel because it seems "basic". Most interviews test it.
5. Fancy dashboards with no clear question.

FAQ

Can a non-IT or commerce graduate become a data analyst?

Yes. Many analysts come from commerce, economics, science or arts backgrounds. Your projects and tests matter.

Is coding necessary?

SQL is essential. Python is strongly useful and increasingly asked, but many entry roles start with Excel, SQL and Power BI.

Which comes first, Power BI or Python?

For most entry roles, Power BI (or Tableau) first, then Python.

How long does it take?

It depends on your daily time and background. Following the stages above with regular practice, many learners are job-test ready in a few months.

Learn it free on YUNOVA

YUNOVA की Data Analysis skill में Excel से SQL, Power BI और Python तक का path है, Hindi और English lessons, quizzes और final test के साथ।

Start the free Data Analysis skill on YUNOVA