Skip to main content

Data Analytics Roadmap 2026

Excel, SQL, Python, statistics, visualisation and storytelling, with AI-assisted analysis built in.

7 stages · 13 units · Beginner · about 36 hours · Last reviewed 19 November 2026

What is a data analytics?

Data analytics is the practice of collecting, cleaning and examining data to answer business questions and support decisions. Analysts work with spreadsheets, SQL, Python, statistics and dashboards, then explain findings in plain language. It is used in marketing, sales, operations, finance and product teams to find patterns, measure performance and test ideas.

Data Analytics fresher salary in India

Typical fresher offers for this role are about 4 to 7.5 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 analytics roadmap

  1. 1

    Analytics Foundations

    Think in data.

    • Role and Process

      Role and process describes what a data analyst actually does, along with the data types and basic statistics needed to do it: framing a question, getting data, cleaning, analysing and communicating. It is the orientation step of the Data Analytics path and sets out the vocabulary of rows, columns, categories, mean, median and spread.

    • Spreadsheets

      Spreadsheets here means working fluently in Excel and Google Sheets to clean, calculate and summarise small to medium datasets. Lookups, conditional logic, pivot tables and charts let an analyst answer questions quickly before moving to SQL or Python. It is the first hands-on tool on the Data Analytics path.

  2. 2

    SQL

    The analyst's main tool.

    • Querying

      Querying is writing SQL SELECT statements to retrieve and shape data from relational tables. It covers choosing columns, filtering and sorting rows, combining tables with joins and set operations, and summarising with aggregates and GROUP BY. It is the analyst's main tool on the Data Analytics path, since most business data sits in databases.

    • Advanced SQL

      Advanced SQL covers the constructs used for multi-step analysis: common table expressions, subqueries and window functions, plus the basics of making queries run fast. Window functions such as ROW_NUMBER and LAG let an analyst rank and compare rows without collapsing them. It follows querying on the Data Analytics path.

    • Databases

      Databases, for an analyst, means understanding how data is organised so that queries return trustworthy answers. It covers tables, keys, relationships, normalisation and star schemas with fact and dimension tables. Knowing the model tells you the grain of a table, why joins can multiply rows, and where to find the right column, which supports the SQL stage of the Data Analytics path.

  3. 3

    Python or R for Analysis

    Scale beyond the sheet.

    • Python

      Python for analysis means using Python in Jupyter notebooks with pandas and NumPy to load, clean, transform and plot data that has outgrown a spreadsheet. It adds repeatable scripts, larger datasets and richer visualisation through libraries such as Matplotlib. It is the stage of the Data Analytics path that scales work beyond sheets.

    • Data Acquisition

      Data acquisition is getting data into an analysis from outside sources: calling REST APIs, reading CSV, Excel and JSON files, and scraping web pages where permitted. It involves authentication, pagination, rate limits and checking the result for completeness. It follows Python on the Data Analytics path because real projects rarely start with neatly handed-over data.

  4. 4

    Statistics for Analysts

    Avoid wrong conclusions.

    • Inference

      Inference is the statistics that lets an analyst draw conclusions about a population from a sample. It covers sampling, confidence intervals, hypothesis tests with p-values and the basics of linear regression. It guards the Data Analytics path against reporting differences that are only noise.

  5. 5

    Visualisation and BI

    Make insight obvious.

    • Principles

      Visualisation principles are the rules for choosing and designing charts so the message is clear: match the chart type to the question, reduce clutter, use colour deliberately and label directly. Storytelling with data adds a narrative of context, insight and recommended action. It opens the Visualisation and BI stage of the Data Analytics path.

    • Tools

      BI tools are applications such as Power BI, Tableau, Looker Studio and Metabase that connect to data, model it and publish interactive dashboards. They add filters, refresh schedules and sharing on top of charts. This unit follows visualisation principles on the Data Analytics path and compares how the main tools differ in cost and depth.

  6. 6

    AI-Assisted Analysis

    The AI-assisted workflow.

    • Working with AI

      Working with AI means using AI assistants to speed up analysis without trusting them blindly: drafting SQL and pandas code, explaining unfamiliar errors, summarising results and automating recurring reports. The analyst stays responsible for checking logic and numbers. It is the intermediate stage of the Data Analytics path.

  7. 7

    Capstone and Career

    Show real analyses.

    • Projects

      Data Analytics projects are portfolio analyses that show the full workflow on realistic data: a sales performance study with SQL and Power BI, a customer segmentation in Python, and a marketing funnel dashboard with a short insights memo. Each shows a question, method, result and recommendation, which is what reviewers look for.

    • Career Readiness

      Career readiness for data analysts means preparing for interviews that test SQL, Excel or Python, statistics and business thinking, and presenting work through a resume and portfolio. It turns the projects from the Data Analytics path into evidence: clear case studies, links and measured results rather than a list of tools.

Frequently asked questions

Ready to practise for interviews?

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

More roadmaps