Skip to main content

Data Analyst Roadmap 2026

A data analyst turns raw data into decisions. This roadmap covers Excel, SQL, Python, statistics, visualisation with Power BI or Tableau, and storytelling.

4 stages · 10 topics · Beginner · about 260 hours · Last reviewed 19 November 2026

What is a data analyst?

A data analyst turns raw data into answers a business can act on. The work covers pulling data with SQL, cleaning and exploring it in Excel or Python, checking it with statistics, building dashboards in Power BI or Tableau, and presenting a clear recommendation. This roadmap follows that workflow from spreadsheets to storytelling.

Data Analyst fresher salary in India

Typical fresher offers for this role are about 3 to 7 LPA per year. This is an indicative range, not a guarantee. Pay depends on city, company type and how strong your projects and interview performance are.

Step-by-step data analyst roadmap

  1. 1

    Spreadsheets and SQL

    The tools every analyst uses daily.

    • Excel

      Excel is the most common tool for quick analysis, using formulas, pivot tables and charts.

    • SQL for analysis

      SQL retrieves and summarises data from databases and is the most tested skill in analyst interviews.

  2. 2

    Python for data

    Clean and explore data at scale.

    • Python basics

      Python is the most popular language for data work thanks to simple syntax and a large library ecosystem.

    • Pandas

      Pandas is a Python library for loading, cleaning, filtering and aggregating tabular data.

    • NumPy

      NumPy provides fast arrays and numerical operations that Pandas and many other libraries are built on.

  3. 3

    Statistics

    Reason about data correctly.

  4. 4

    Visualisation and storytelling

    Make results easy to act on.

    • Power BI

      Power BI builds interactive dashboards from multiple data sources using DAX measures.

    • Tableau

      Tableau creates interactive visualisations and dashboards through drag and drop.

    • Data storytelling

      Data storytelling means presenting findings as a clear narrative with a recommendation, not just charts.

Projects to build

  • Sales dashboard in Excel (Beginner)

    Pivot tables, charts and slicers on a sales dataset.

  • SQL analysis of an e-commerce database (Beginner)

    Revenue, retention and top products with joins and window functions.

  • Customer churn analysis in Python (Intermediate)

    Clean data with Pandas and find churn drivers.

  • Power BI executive dashboard (Intermediate)

    Multi-page report with DAX KPIs.

  • A/B test case study (Advanced)

    Design and analyse an experiment with significance testing.

Frequently asked questions

Ready to practise for interviews?

Practise data analyst questions with an AI mock interviewer and get feedback on your answers.

More roadmaps