SQL, Excel and dashboards that answer business questions
Turns raw numbers into clear answers — which products sell, where costs rise, what customers want.
Data analysts collect and clean data, query it with SQL (a language for databases), analyse it in Excel or Python, and present what they find in reports and dashboards so managers can make decisions. A typical question might be 'Why did sales drop in this city last month?' Unlike data scientists, who build machine-learning models, analysts focus on describing and explaining what is happening in the business. Banks, e-commerce, consulting and IT firms, hospitals and FMCG companies all hire them. Graduates from statistics, maths, economics, commerce, engineering and computer science all get in; practical skills and a few project case studies matter more than the exact degree. It is also a common first step towards data science or business analysis.
Every stage from school to your first day on the job.
Class 11–12
Any stream, with Maths if possible
PCM, Commerce with Maths, or Humanities with Maths / Economics. Get comfortable with spreadsheets.
2 years
Degree
B.Sc Statistics, BA Economics, B.Com, BCA or B.Tech
Through CUET-UG, JEE or university admission.
3–4 years
Skills
Excel, SQL and a dashboard tool
Add basic statistics and Python; a short data analytics course can help.
Alongside degree
Projects
Case studies on real data
Analyse public datasets and present your findings clearly; do an internship if you can.
Alongside degree
First job
Junior / associate data analyst
Hiring usually includes an Excel or SQL test and a case discussion.
Ongoing
Class 11–12
Any stream, with Maths if possible
PCM, Commerce with Maths, or Humanities with Maths / Economics. Get comfortable with spreadsheets.
2 years
Degree
B.Sc Statistics, BA Economics, B.Com, BCA or B.Tech
Through CUET-UG, JEE or university admission.
3–4 years
Skills
Excel, SQL and a dashboard tool
Add basic statistics and Python; a short data analytics course can help.
Alongside degree
Projects
Case studies on real data
Analyse public datasets and present your findings clearly; do an internship if you can.
Alongside degree
First job
Junior / associate data analyst
Hiring usually includes an Excel or SQL test and a case discussion.
Ongoing
What you need before you can start.
Minimum qualification
Bachelor's degree (statistics, maths, economics, commerce, engineering or computer science common), plus SQL and Excel skills
Class 11–12 stream
The exams that open the door to this career.
There is no single entrance exam — entry is through your degree, skills and the employer's own hiring process.
A typical promotion ladder, from your first role to the top.
Indicative pay at each stage of the career.
Private-sector pay varies a lot by city, employer, skills and the institute you studied at.
Figures are indicative and change with pay commissions, employer, city and experience.
Degrees and programmes that lead here.
Data Analytics
Certificate in Data Analytics
Skill · 3 – 9 months
B.Sc Statistics
Bachelor of Science (Honours) in Statistics
Undergraduate · 3 years (4 years with honours / research under NEP)
B.Sc / BS Data Science
B.Sc / BS in Data Science (incl. the IIT Madras online BS in Data Science & Applications)
Undergraduate · 3 years for a B.Sc; 4 years for a BS (IIT Madras allows exits with a certificate, diploma or degree)
BA Economics
Bachelor of Arts (Honours) in Economics
Undergraduate · 3 years (4 years with honours / research under NEP)
B.Com
Bachelor of Commerce
Undergraduate · 3 years (4 years with honours under NEP)
MBA Business Analytics
Master of Business Administration / PGDM in Business Analytics
Postgraduate · 2 years (incl. an internship)
More in Information Technology and Private.
Weighing up your options?
Put Data Analyst side by side with other careers, or browse every roadmap.
Always confirm dates, eligibility and fees on the official websites before applying.