What a Data Analyst Actually Does
A data analyst collects, cleans, and studies data to help a business make decisions. You will pull numbers from databases or spreadsheets, spot patterns, build dashboards, and explain what the data means to people who are not data experts.
In India, this role exists across industries: e-commerce, banking, fintech, healthcare, logistics, and SaaS companies all hire data analysts. The job title can vary — business analyst, reporting analyst, insights analyst — but the core work of turning raw data into a clear answer stays the same.
- Pulling and cleaning data from SQL databases, Excel sheets, or company tools
- Building reports and dashboards in Excel, Power BI, or Tableau
- Running basic statistical analysis to find trends or problems
- Presenting findings to managers or teams in plain language
- Working with product, marketing, or finance teams depending on the company
Skills You Need to Learn
You do not need a data science degree to start. Most data analyst roles are filled by people from commerce, engineering, economics, or even arts backgrounds who picked up the right tools. Focus on a small set of skills and go deep rather than trying to learn everything at once.
Start with Excel since almost every company uses it somewhere. Then move to SQL, which is non-negotiable for this role — nearly every data analyst job posting asks for it. After that, pick one visualization tool and one basic statistics/Python track.
- Excel: pivot tables, VLOOKUP/XLOOKUP, charts, basic formulas
- SQL: SELECT, JOINs, GROUP BY, subqueries, window functions
- Visualization: Power BI or Tableau — pick one and build 3-4 real dashboards
- Basic Python or R: pandas for data cleaning, simple plotting with matplotlib
- Statistics basics: mean, median, standard deviation, correlation, A/B testing concepts
- Communication: writing a one-page summary of findings, presenting to non-technical people
How to Build Proof of Skills Without Work Experience
Freshers struggle most with the 'show me you can do this' part. You don't need a job to build proof — you need projects you can talk about in an interview and show on a resume or portfolio link.
Pick public datasets (government open data, Kaggle, or your own college/club data) and build 2-3 small projects. Each project should have a clear question, the steps you took, and a dashboard or short report as the output. Put these on a simple Google Sites page, GitHub, or a PDF you can share.
- Project idea: analyze Indian e-commerce or retail sales data and find which products/regions perform best
- Project idea: clean a messy survey dataset and present key insights with charts
- Project idea: build a sales or HR attrition dashboard in Power BI/Tableau
- Document your process: what question you asked, what data you used, what you found
- Practice explaining each project in under 2 minutes — this is what interviewers ask for
Where to Learn: Realistic Paths
You have three realistic routes: self-study with free resources, a paid short-term course, or a college degree if you're still studying. For most working professionals switching careers, self-study plus one paid certification is the fastest and cheapest path.
Avoid spending months on a single course before applying. Learn the basics in 6-8 weeks, start building projects in parallel, and start applying once you can write a SQL query and explain a dashboard — you will keep learning on the job.
- Free: YouTube SQL/Excel tutorials, Kaggle's free micro-courses, Google's free Data Analytics certificate materials
- Paid (optional): a single focused course on SQL + Power BI/Tableau, usually 2-3 months
- College students: take any data, statistics, or database elective available; join analytics clubs
- Don't chase multiple certificates — one solid portfolio beats five certificates with no projects
Salary Expectations in India
Data analyst pay varies a lot by city, company size, and your SQL/visualization skill level, so treat any number you see online as a rough range, not a guarantee. We don't have enough live postings specifically tagged as 'data analyst' with stated pay to give you a reliable median right now.
For context on adjacent roles from our job data: senior program/project manager and senior strategy & operations roles show a median of ₹5 LPA each, but these are based on only 2 postings each, so treat them as a very rough signal, not a benchmark. Data analyst pay for freshers in most Indian cities typically sits below senior-level roles like these — focus your salary research on specific job postings and company reviews rather than averages, since the range between a startup and a large MNC can be wide.
- Compare pay by city — Bengaluru, Hyderabad, and Pune often pay more than smaller cities
- Check if the role is analyst vs senior analyst vs lead — titles affect pay a lot
- Negotiate based on your SQL + tool skills, not just your degree
- Use posted salary ranges on job listings when available instead of guessing
How to Land Your First Data Analyst Job
Your resume should lead with skills and projects, not just education, especially if you're a fresher. Use a simple one-page format: top section for skills (SQL, Excel, Power BI/Tableau, Python basics), then 2-3 projects with one line each on the result, then education and any internships.
Apply broadly but track your applications. Many companies list analyst openings under different titles like 'reporting analyst', 'business analyst', or 'insights analyst' — search using multiple keywords. jobinaweek.com currently lists 4,508 open jobs from 232 companies in the last 30 days, so check listings regularly since fresh roles get added often and older ones can close fast.
- Search multiple job titles: data analyst, business analyst, reporting analyst, MIS analyst
- Set up daily or weekly checks on job boards instead of applying once and waiting
- Prepare for SQL + Excel tests — many companies give a short practical test before the interview
- Practice explaining one project end-to-end out loud before interviews
- Follow up politely if you don't hear back in 1-2 weeks
Questions
Do I need to know coding to become a data analyst in India?
Not heavy coding, but you do need SQL, which is considered a core skill for almost every data analyst job. Basic Python (using pandas for cleaning data) is a plus but not always required for entry-level roles.
Can I become a data analyst without a technical degree?
Yes. Many data analysts come from commerce, economics, or arts backgrounds. What matters more to employers is your ability to use SQL, Excel, and a visualization tool, plus projects that show you can find insights in data.
How long does it take to become job-ready as a data analyst?
With focused effort, most people can learn Excel and SQL basics in 6-8 weeks, then spend another 4-6 weeks building 2-3 portfolio projects and a basic Power BI or Tableau dashboard before starting to apply.
What is the difference between a data analyst and a data scientist?
A data analyst mainly reports on what has happened using SQL, Excel, and dashboards. A data scientist builds predictive models and usually needs deeper statistics, machine learning, and programming skills. Most people start as analysts before moving into data science if they want to.
What salary can a fresher data analyst expect in India?
We don't have enough live data analyst-specific postings with stated pay to give a reliable fresher number right now. Check individual job postings for stated salary ranges, and compare across cities, since Bengaluru, Hyderabad, and Pune often differ from smaller cities.
Which tool should I learn first, Power BI or Tableau?
Either is fine for starting out — pick one based on the job postings common in your target city or industry. Power BI is widely used in companies already on Microsoft tools, while Tableau is common in larger enterprises and MNCs. Learning one well matters more than learning both halfway.