Career in Data Analytics in India: Skills, Tools, Roles, Salary Range and a 6-Month Plan
How to start a data analytics career in India: the skills and tools to learn, typical roles and salary ranges, portfolio projects, interview preparation and a six-month study plan.
Data analysts turn raw numbers into answers that businesses can act on: which product sells where, why customers leave, which campaign worked. Demand exists across banking, e-commerce, healthcare, telecom, logistics and consulting, and the entry barrier is lower than for data science because you do not need advanced machine learning to get started. This guide lays out what you need to learn and how to show it.
What a data analyst does
- Collects and cleans data from databases, spreadsheets and tools.
- Analyses it to find patterns, trends and causes.
- Builds dashboards and reports for managers.
- Explains findings clearly and recommends actions.
The skill that separates good analysts is not a tool but the ability to ask the right question and explain the result to someone who is not technical.
The skill stack, in learning order
| Skill | What to learn |
|---|---|
| 1. Excel and Google Sheets | Formulas, lookups, pivot tables, charts and data cleaning. Many jobs start here. |
| 2. SQL | Querying databases: SELECT, joins, grouping, window functions. The most requested analyst skill. |
| 3. Statistics basics | Mean, median, spread, distributions, sampling, correlation, hypothesis tests and A/B testing. |
| 4. A BI tool | Power BI or Tableau for dashboards. Pick one and go deep. |
| 5. Python or R | Pandas for cleaning and analysis, plus plotting libraries. Valuable but second to SQL. |
| 6. Business understanding | Metrics for your target industry: retention, conversion, margin, churn. |
| 7. Communication | Writing a clear summary, structuring a presentation, telling a story with data. |
You can practise statistics with our statistics calculator and check queries with the SQL formatter. Convert quick data formats with CSV to JSON when you practise.
Roles and typical pay
Titles vary a lot, and pay depends on city, company type and skill. The ranges below are rough guides for fully employed analysts in India, not offers: check current listings on job portals before you negotiate.
| Role | Indicative annual pay |
|---|---|
| Data analyst (fresher) | Often about ₹3 lakh to ₹8 lakh a year |
| Data analyst (2 to 5 years) | Often about ₹6 lakh to ₹15 lakh |
| Senior analyst or analytics manager | Often ₹15 lakh and above |
| Business analyst | Similar range, with more stakeholder work |
| BI developer | Similar to analyst, with stronger dashboard and data modelling skills |
Analyst, scientist or engineer?
A data analyst answers business questions with existing data. A data scientist builds predictive models and experiments, which demands stronger mathematics and programming. A data engineer builds the pipelines and warehouses that deliver clean data. Many people start as analysts and move toward either side.
Build a portfolio that gets interviews
Employers want proof, not certificates. Three solid projects beat ten tutorials:
- A business-style analysis. Take a public sales or customer dataset, state a question, clean the data, analyse and present three recommendations.
- A dashboard in Power BI or Tableau with filters, published online with screenshots.
- A SQL project with a schema, messy tables and a set of interesting queries.
Put the code and a short write-up on GitHub, and describe the impact in plain language: "Found that 18% of customers account for 60% of revenue; suggested a loyalty tier".
A six-month plan
| Time | Focus |
|---|---|
| Month 1 | Excel in depth plus basic statistics |
| Month 2 | SQL fundamentals and joins, 30 practice queries |
| Month 3 | BI tool and your first dashboard |
| Month 4 | Python with Pandas, plus a cleaning project |
| Month 5 | A full end-to-end portfolio project and a case study write-up |
| Month 6 | Resume, LinkedIn, mock interviews and applications |
Interview preparation
- SQL tests: joins, aggregation, ranking, handling duplicates and NULLs.
- Case questions: "Sales fell 10% last month. How would you investigate?" Structure by segment, time, channel and product.
- Metrics: define conversion rate, retention and customer lifetime value.
- Behavioural: a time you found a surprising result and how you explained it.
Check your resume for clarity with our guide on writing a resume in India.
Where to look for jobs
Search for the titles "data analyst", "business analyst", "MIS executive", "reporting analyst" and "BI analyst", since the same work goes by many names. Apply on company career pages and professional networks, ask alumni for referrals, and look at smaller companies and startups where an analyst gets broad exposure early. Internships and short freelance projects count as experience, so put them on your resume.
Mistakes to avoid
- Collecting certificates without projects.
- Learning ten tools shallowly instead of SQL and one BI tool well.
- Showing charts with no conclusion.
- Ignoring domain knowledge. Pick an industry and learn its numbers.
Courses, tools and pay change quickly, so verify against current job descriptions. Salary figures are indicative.
Frequently asked questions
Do I need a degree in statistics to become a data analyst?
No. Many analysts come from commerce, engineering and other fields. Skills and projects matter most.
Which skill should I learn first?
Excel, then SQL. They appear in most analyst job descriptions.
Is Python necessary for a data analyst?
It is helpful and increasingly expected, but SQL and a BI tool matter more at entry level.
How long does it take to become job-ready?
About six months of focused study can get you to entry level if you build real projects.
What is the difference between a data analyst and a data scientist?
Analysts answer business questions from existing data. Scientists build predictive models.
Are fresher salaries high?
They vary widely by city and company. Treat ranges as indicative and check current listings.
Last reviewed 8 November 2026. Rates, limits and rules change, so confirm figures with the official source before you act.
Free tools related to this article
Keep reading
Information on AMTools is for general guidance and is not professional financial, tax, legal or medical advice. Rules, rates and limits change, so check the latest official source before acting.