Saturday, 21 November 2026

How to Become a Data Analyst in India – Courses & Salary

How to Become a Data Analyst in India – Courses & Salary

If you are a student, fresher or working professional wondering how to become a data analyst in India, this guide is for you. It covers the skills you need, the courses worth considering, how to build a portfolio, how to get your first job and what salaries look like.

Quick answer: To become a data analyst in India, learn Excel, SQL, one BI tool (Power BI or Tableau) and basic Python or R, along with statistics. Complete a recognised course or certificate, build 3–5 real portfolio projects, and apply for analyst or internship roles. Many people get job-ready in about 6–12 months of steady practice.

What Does a Data Analyst Actually Do?

A data analyst collects data, cleans it, studies it and explains what it means so that a business can make better decisions. For example, an e-commerce company may ask, “Why did sales drop in Pune last month?” The analyst pulls the numbers, finds the reason and presents it in a simple dashboard or report.

Typical daily tasks include:

  • Writing SQL queries to pull data from databases
  • Cleaning messy data in Excel or Python
  • Building dashboards in Power BI, Tableau or Looker Studio
  • Spotting trends, comparing periods and running simple statistical checks
  • Explaining findings to managers who are not technical

Data analysts work in almost every industry: IT services, banks, fintech, e-commerce, healthcare, telecom, consulting and even government projects.

Who Can Become a Data Analyst?

You do not need an engineering degree. Graduates in BCom, BSc, BBA, BA Economics, BCA and BTech all enter this field. What matters more is your comfort with numbers, logical thinking and willingness to practise tools.

  • After 12th: Choose a degree with maths or statistics, such as BSc Statistics, BCA or BSc Data Science. Our list of career options after 12th explains more paths.
  • Graduates: Add skills through a certificate course and projects; a degree in any field is generally accepted.
  • Working professionals: People from sales, finance, operations or HR often switch by using data in their current role first.

How to Become a Data Analyst: Step-by-Step Roadmap

Step 1: Get Strong in Excel

Excel is still the most widely used analysis tool in Indian offices. Learn formulas like VLOOKUP/XLOOKUP, IF, SUMIFS and COUNTIFS, pivot tables, charts, conditional formatting and basic data cleaning. Plan around 3–4 weeks.

Step 2: Learn SQL

SQL is the language used to talk to databases, and almost every analyst interview tests it. Cover SELECT, WHERE, GROUP BY, HAVING, JOINs, subqueries and window functions. Practise on free platforms with real-style questions. Give this 4–6 weeks.

Step 3: Understand Basic Statistics

You need mean, median, standard deviation, percentiles, correlation, probability basics, sampling and hypothesis testing. You do not need advanced maths, but you must know which method answers which business question.

Step 4: Pick One BI Tool

Power BI is very popular in Indian companies, especially those using Microsoft products. Tableau is common in MNCs and consulting firms. Learn one well: connecting data, building relationships, creating measures and designing clean dashboards.

Step 5: Learn Python (or R) for Analysis

Python with the pandas, NumPy and Matplotlib/Seaborn libraries helps you handle large data, automate tasks and do deeper analysis. Many job listings now mention Python as a must-have or good-to-have. R is used more in research and some analytics teams.

Step 6: Build a Portfolio of Real Projects

Recruiters want to see what you can do, not only certificates. Build 3–5 projects using public datasets, for example from data.gov.in or Kaggle. Good project ideas include:

  • Sales dashboard for a retail store with monthly and city-wise trends
  • Analysis of Indian state-wise data, such as rainfall, crops or literacy
  • Customer churn analysis for a telecom or subscription business
  • IPL or cricket player performance analysis

Upload your work to GitHub, publish dashboards online and write a short summary of the business problem, your approach and your findings for each project.

Step 7: Apply Smartly for Jobs and Internships

Make a one-page resume that lists tools, projects with results, and any certificates. Keep your LinkedIn profile updated and apply on job portals, company career pages and through campus placements. Entry-level titles to search include Junior Data Analyst, MIS Executive, Business Analyst Trainee, Reporting Analyst and Data Analyst Intern.

MIS and reporting roles are a common first step, and many people move into full analyst roles within a year or two. Some analyst roles are also offered remotely; see our guide on work from home jobs for beginners.

Skills Every Data Analyst Needs

SkillWhy it mattersPriority
ExcelDaily reports, quick analysis, used everywhereMust have
SQLPulling data from databases; tested in most interviewsMust have
Power BI / TableauDashboards and visual reports for managersMust have (any one)
StatisticsChoosing the right method and avoiding wrong conclusionsMust have
Python / RLarge data, automation, deeper analysisHighly preferred
CommunicationExplaining insights in simple languageMust have
Domain knowledgeUnderstanding finance, retail, healthcare etc.Grows with experience

AI tools are now part of the job too. Analysts use chat assistants to draft SQL, explain errors and summarise data, but you still need to check the output. Our list of best AI tools for students includes several that help with learning and practice.

Best Data Analyst Courses and Certificates in India

There is no single compulsory course. Choose based on budget, time and how you learn best. Here are well-known, credible options:

Google Data Analytics Professional Certificate

Offered by Google on Coursera, this beginner course covers spreadsheets, SQL, Tableau and R. It is self-paced and Google says many learners finish in three to six months. It works on a monthly subscription, and Coursera offers financial aid. Details are on Google’s official certificate page.

Microsoft Power BI Data Analyst Associate (PL-300)

This is Microsoft’s official certification for Power BI. Free learning paths are available on Microsoft Learn, and you pay only if you take the certification exam. It is well recognised by employers that use Power BI.

IBM Data Analyst Professional Certificate

Also on Coursera, IBM’s programme focuses on Excel, SQL, Python and dashboards. It suits learners who want Python from the start instead of R.

NPTEL and SWAYAM Courses

Government-backed NPTEL offers free courses from IIT and IISc faculty on Python for data science, statistics and data analytics. Learning is free, and there is a fee only if you want to sit for the proctored certificate exam.

Degree Options

For a longer route, consider BSc Statistics, BSc Data Science, BCA, or online programmes such as the IIT Madras BS in Data Science and Applications. An MBA in Business Analytics or MSc Statistics helps if you want senior or specialised roles later.

OptionBest forCost typeTypical duration
Google Data Analytics (Coursera)Complete beginnersMonthly subscription; aid available3–6 months (self-paced)
Microsoft PL-300Power BI-focused rolesFree learning; paid exam1–3 months
IBM Data Analyst (Coursera)Python-first learnersMonthly subscription; aid availableFew months (self-paced)
NPTEL / SWAYAMBudget learners, studentsFree; paid certificate exam8–12 weeks per course
Degree (BSc/BCA/online BS)12th pass studentsCollege fees3–4 years

Be careful with expensive bootcamps that promise “guaranteed placement”. Read the fine print, check real alumni reviews and confirm what the guarantee actually covers before paying.

Data Analyst Salary in India

Salary depends on city, company type, skills and experience. Based on self-reported data on Glassdoor India (2026), the average base pay for data analysts is around ₹6.5–7.5 lakh per year, with the middle half of salaries falling roughly between ₹4.7 lakh and ₹10.5 lakh.

LevelApprox. yearly base pay
Data Analyst₹4–10 lakh
Senior Data Analyst₹5–13 lakh
Data Analytics Manager₹11–25 lakh

Source: Glassdoor India career trajectory data, 2026. Figures are approximate, self-reported and change over time.

Freshers usually start at the lower end of the range, while analysts in Bengaluru, Gurugram, Hyderabad, Mumbai and Pune, or at product companies and MNCs, tend to earn more. Strong SQL and Python skills, plus domain knowledge in finance or e-commerce, can push pay up faster.

Career Growth After Data Analyst

Data analysis is a strong base for several higher roles. Common next steps include:

  • Senior Data Analyst / Analytics Lead: Owning bigger projects and guiding juniors
  • Business Analyst / Product Analyst: Working closely with product and strategy teams
  • Data Scientist: Adding machine learning and advanced statistics
  • Data Engineer: Building data pipelines and warehouses
  • Analytics Manager: Leading teams and analytics strategy

How to Prepare for Data Analyst Interviews

Most analyst hiring in India follows a similar pattern: an online test or take-home task, one or two technical rounds and an HR round. Prepare for each stage separately.

  • SQL round: Expect questions on JOINs, GROUP BY, finding the second-highest value, running totals and window functions like RANK.
  • Excel round: You may be asked to build a pivot table, use XLOOKUP or clean a messy sheet live.
  • Case questions: For example, “Orders fell 10% last week. How will you find out why?” Explain your steps clearly: check data quality, split by city, product and channel, then compare with past trends.
  • Project discussion: Be ready to explain every project on your resume, including what you would do differently.
  • Statistics basics: Know the difference between mean and median, what correlation means, and why correlation does not prove cause.

Practise speaking your answers aloud. Clear explanation is often what separates selected candidates from equally skilled ones.

Laptop and Setup for Learning

You do not need a costly machine to start. A laptop with at least 8 GB RAM (16 GB is better), an SSD and a recent processor handles Excel, SQL, Power BI and Python comfortably. Note that Power BI Desktop runs on Windows. For model suggestions, read our guide to the best laptop brands in India.

Frequently Asked Questions

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

Yes. Many analysts come from commerce, economics, science or management backgrounds. Employers mostly look at your skills in Excel, SQL, BI tools and your project portfolio, along with a graduation degree in any field.

How long does it take to become a data analyst?

With 2–3 hours of daily practice, most beginners become job-ready in about 6–12 months. The time depends on your starting level and how many real projects you build.

Is coding required for a data analyst job?

SQL is required in almost all analyst roles. Python or R is increasingly expected, but the level needed is much lighter than for a software developer. Some entry-level MIS roles focus mainly on Excel.

Which is better to learn first, Power BI or Tableau?

Both are good. Power BI is very common in Indian companies and has free learning material on Microsoft Learn, so it is a practical first choice. Check job listings in your target city to see which tool appears more often.

What is the salary of a data analyst fresher in India?

Freshers generally start at the lower end of the data analyst pay range on salary platforms. Pay varies a lot by city, company and skills, so compare current listings on job portals for your location before negotiating.

Will AI replace data analysts?

AI is automating routine tasks like writing basic queries and making simple charts. However, companies still need people who understand the business, ask the right questions and check whether results make sense. Analysts who learn to use AI tools well are likely to stay in demand.

Final Thoughts

Becoming a data analyst in India is very achievable without an expensive degree. Master Excel and SQL, learn one BI tool and basic Python, understand statistics, and prove your skills with real projects. Start small, practise daily, and treat your first MIS or junior analyst job as the launch pad for a long, well-paid data career.

About the author

SKSethi Team

Get Some Interesting Information and Facts

More about us