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
Analytics Foundations
Beginner · about 4 hours
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.
- Role and Process
- 2
SQL
Beginner · about 8 hours
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.
- Querying
- 3
Python or R for Analysis
Beginner · about 5 hours
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.
- Python
- 4
Statistics for Analysts
Beginner · about 4 hours
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.
- Inference
- 5
Visualisation and BI
Beginner · about 5 hours
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.
- Principles
- 6
AI-Assisted Analysis
Intermediate
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.
- Working with AI
- 7
Capstone and Career
Intermediate · about 7 hours
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.
- Projects
Frequently asked questions
Ready to practise for interviews?
Practise data analytics questions with an AI mock interviewer and get feedback on your answers.