Home/Career Paths/Data Analyst

Data Analyst career pathRoadmap, skills, salary and how to become a Data Analyst in 2026

A data analyst turns data into decisions: cleaning and analysing data in Excel, SQL and Python, and presenting the results in Power BI or Tableau dashboards.

4stages
8steps
68hours of skills
0%your progress

Data Analyst roadmap

Open any step to see its lessons, tools and lab, and mark it as learning or done. Your progress is saved in this browser only.

1

Foundations

3 steps · 26 hours
Excel for analysis8h

Analyse data quickly in Excel

What you learn

  • Formulas and functions
  • Lookups (XLOOKUP)
  • Pivot tables
  • Charts
  • Power Query

Tools

Excel

Hands-on lab

Monthly sales report built from raw data

Learn it at SOTT

Data Analytics with AI · Power BI & Tableau · Data Analytics

SQL essentials10h

Query and analyse data confidently with SQL

What you learn

  • SELECT, filtering and sorting
  • Joins across tables
  • Aggregations and GROUP BY
  • Subqueries and CTEs
  • Window functions

Tools

PostgreSQLMySQL

Hands-on lab

Answer 20 business questions from a sales database

Learn it at SOTT

Data Analytics with AI · Data Analytics · Forward Deployed Engineer Program

Statistics for data8h

Draw sound conclusions from data

What you learn

  • Descriptive statistics
  • Probability and distributions
  • Sampling
  • Hypothesis testing
  • A/B testing

Tools

ExcelPython

Hands-on lab

Analyse an A/B test and make a recommendation

Learn it at SOTT

Data Analytics with AI · Data Analytics · Data Science Fundamentals

2

Core skills

3 steps · 30 hours
Python for data analysis10h

Clean, analyse and visualise data with Python

What you learn

  • NumPy
  • pandas
  • Data cleaning
  • Visualisation with matplotlib and seaborn
  • Jupyter notebooks

Tools

PythonpandasJupyter

Hands-on lab

Exploratory analysis on a real dataset

Learn it at SOTT

Data Analytics with AI · Data Analytics · Data Science Fundamentals

Power BI & Microsoft Fabric12h

Build interactive dashboards decision-makers use

What you learn

  • Power Query
  • Data modelling
  • DAX measures
  • Visual storytelling
  • Fabric lakehouse basics
  • Publishing and sharing

Tools

Power BIMicrosoft Fabric

Hands-on lab

Executive dashboard for a retail business

Learn it at SOTT

Data Analytics with AI · Power BI & Tableau · Data Analytics

Tableau8h

Visualise data clearly in Tableau

What you learn

  • Connecting to data
  • Calculated fields
  • Dashboards
  • Data storytelling

Tools

Tableau

Hands-on lab

Interactive dashboard published to Tableau Public

Learn it at SOTT

Power BI & Tableau

3

Advanced

1 steps · 6 hours
AI for data analysis6h

Use AI assistants to analyse data faster, safely

What you learn

  • ChatGPT, Claude and Copilot for analysis
  • Asking data questions in plain English
  • Automating reports with AI
  • Checking AI output for accuracy

Tools

ChatGPTClaudeCopilot

Hands-on lab

AI-assisted insight report, fact-checked

Learn it at SOTT

Data Analytics with AI · Power BI & Tableau · Data Analytics

4

Job-ready

1 steps · 6 hours
Career launch6h

Present your skills confidently to employers

What you learn

  • Resume and LinkedIn that get shortlisted
  • Building your project portfolio
  • Interview preparation and mock rounds
  • Job search strategy

Tools

LinkedIn

Hands-on lab

Mock technical + HR interview with feedback

Learn it at SOTT

Data Analytics with AI · Data Analytics · Generative AI & RAG Engineering

How to become a Data Analyst

A practical, step-by-step plan. Skip any step you already know.

  1. 1
    Start with the foundations: Excel for analysis, SQL essentials and Statistics for data

    3 steps · about 26 hours

  2. 2
    Build the core skills: Python for data analysis, Power BI & Microsoft Fabric and Tableau

    3 steps · about 30 hours

  3. 3
    Go deeper: AI for data analysis

    1 steps · about 6 hours

  4. 4
    Get job-ready: Career launch

    1 steps · about 6 hours

  5. 5
    Build two or three portfolio projects

    Use the hands-on labs in each step, publish your work on GitHub and write a short README for each project. Projects are what interviewers ask about first.

  6. 6
    Prepare for interviews

    Practise the questions asked for this role, do mock interviews and polish your resume and LinkedIn profile. Practise Data Analyst interview questions →

  7. 7
    Apply for Data Analyst roles

    Start with roles that match your current level, keep learning on the job, and grow towards the senior skills in this path.

Data Analyst salary in India (2026)

Indicative yearly pay, in lakh rupees (LPA). Pay varies with city, company, skills and certifications, so use these as a guide, not a promise.

Entry level0–2 years
₹3–6 LPA
Mid level3–5 years
₹6–12 LPA
Senior / lead6+ years
₹12–18 LPA

Rounded ranges from public salary surveys (AmbitionBox, Glassdoor and PayScale India), checked November 2026. Bangalore, Hyderabad and Pune often pay above these ranges, and product companies and global capability centres pay more than service companies.

Courses that take you there

How it compares

Data analyst vs data scientist

Data analysts explain what happened and why, mostly with SQL and dashboards. Data scientists build predictive models with statistics and machine learning.

Data Analyst career path FAQ

How long does it take to become a Data Analyst?+
This path covers about 68 hours of hands-on learning across 8 modules. How quickly you finish depends on your starting point and weekly time; our advisors can plan a timeline that fits you.
How do I become a Data Analyst?+
Follow the stages in order: foundations, core skills, advanced and job-ready, then build two or three portfolio projects, prepare for interviews and apply. If you already know a topic, mark it done and skip ahead.
What is the Data Analyst salary in India?+
As an indicative guide from public salary surveys, about ₹3–6 lakh a year at entry level, ₹6–12 lakh with 3–5 years and ₹12–18 lakh for senior roles. Pay varies a lot with city, company, skills and certifications.
Where should I start?+
With the Foundations stage: Excel for analysis, SQL essentials and Statistics for data. If you already know a topic, mark it as done and move to the next one.
What is the difference: Data analyst vs data scientist?+
Data analysts explain what happened and why, mostly with SQL and dashboards. Data scientists build predictive models with statistics and machine learning.
Which SOTT courses cover this path?+
Data Analytics with AI, Power BI & Tableau and Data Analytics. Each one is taught live, in our Chennai classroom or online, with hands-on labs and placement assistance.
I have another question. Who can I ask?+
Our advisors are happy to help. Call or WhatsApp us, or send a message from the Contact page, and we will get back to you within one working day.

More role paths

Learn it with a mentor

Want to follow a path with live classes, labs and placement assistance?

Our advisors will match the path to the right SOTT course for your background.