Data Analyst Roadmap 2026-27: Month-by-Month Plan

01

The plan

Data analyst roadmap at a glance

This is a month-by-month plan for a part-time learner starting from zero. It covers about 6 months at 10–12 hours a week. Every stage gives you something you can show — an Excel model, a SQL query, a Python notebook or a dashboard.

Month-by-month plan — part-time estimate (10–12 hours a week)
Month	Learn	Practise / Build	Milestone you can show
Month 1	Excel for analysis — lookups, pivots, cleaning, charts	Build pivot tables, lookups and a small dashboard in Excel	Excel workbook with a working analysis
Month 1–2	SQL — querying, joins, aggregation, window functions	Query a sample database to answer five business questions	SQL queries with a short findings note
Month 2	Statistics & business maths basics	Interpret descriptive stats, run a simple hypothesis test	One-page stats summary on a real dataset
Month 3	Python for analysis — pandas, NumPy, Matplotlib	Load, clean and analyse a CSV with pandas	Python notebook with charts and findings
Month 3–4	Data cleaning & exploratory data analysis	Clean a messy dataset, document decisions, build an EDA report	EDA notebook with insights and charts
Month 4–5	Power BI (and Tableau basics) — modelling, DAX, dashboards	Build a dashboard on a public dataset and write a stakeholder summary	Published dashboard with a one-page explanation
Month 5–6	AI & Gen AI tools for analysts — using LLMs for SQL/Excel help, summarising, with checks	Use AI to draft SQL queries and summarise findings, then verify everything	Notes on what AI helped with and what it got wrong
Month 6	Portfolio, resume, LinkedIn and interview prep	Polish 3–4 projects, write READMEs, prepare interview answers	Portfolio with dashboards and a one-page resume

Time estimate note: 6 months part-time is an estimate for someone studying 10–12 hours a week. A fast-track learner at 20+ hours a week can finish in about 3–4 months. Estimates are not guarantees — your pace depends on prior experience with Excel and data.

Visual roadmap: A designer-built SVG timeline of all eight stages, with a downloadable one-page PDF summary, is planned for this page. The text version above and the stage sections below cover the same content in accessible HTML.

02

Stage 1

Excel for analysis (lookups, pivots, cleaning, charts)

Excel is still the daily tool for most analysts. This stage takes you from basic formulas to pivot tables, lookups and charts — the operations you will use to analyse business data.

Topics checklist
Topic	What to cover
Formulas	SUM, AVERAGE, IF, COUNTIF, SUMIF, nested IF, text functions
Lookups	VLOOKUP, INDEX-MATCH, XLOOKUP (if available), when each one works
Pivot tables	Grouping, filtering, calculated fields, pivot charts
Data cleaning	Removing duplicates, text-to-columns, handling blanks, basic validation
Charts	Bar, line, combo charts, choosing the right chart for the message

Free official resources: Microsoft Excel help and training, Excel Jet (formula basics), Microsoft Learn (Excel for analysts).

Mini project: Take a public sales or survey dataset and build an Excel workbook with three pivot tables and a one-page summary of the findings.

You are ready for the next stage when: you can build a pivot table and a lookup formula without help, and explain what the numbers mean to a non-technical reader.

03

Stage 2

SQL — querying, joins, aggregation, window functions

Most business data lives in a database. This stage teaches you enough SQL to answer business questions yourself instead of waiting for a data team.

Topics checklist
Topic	What to cover
Basic queries	SELECT, WHERE, ORDER BY, LIMIT, DISTINCT
Joins	INNER JOIN, LEFT JOIN, joining three tables
Aggregations	GROUP BY, HAVING, COUNT, SUM, AVG, MIN, MAX
Subqueries and CTEs	Writing a subquery, when a CTE makes a query easier to read
Window functions	ROW_NUMBER, RANK, running totals, partitioning — when they beat a simple GROUP BY
Business framing	Turning a business question into a query and a short answer

Free official resources: MySQL documentation, PostgreSQL documentation, SQLBolt, Mode SQL tutorial.

Mini project: Load a sample database and answer five business questions with SQL — for example top customers, monthly revenue, repeat orders.

You are ready for the next stage when: you can join two tables, write a window function and explain your result to someone who does not know SQL.

04

Stage 3

Statistics & business maths basics

Statistics is how you know whether a difference is real or random noise. This stage gives you enough to read numbers critically and explain them to stakeholders.

Topics checklist
Topic	What to cover
Descriptive statistics	Mean, median, mode, standard deviation, percentiles, outlier detection
Probability basics	Basic probability, conditional probability, independence
Distributions	Normal, binomial, Poisson — when each one applies
Hypothesis testing	Null and alternative hypotheses, p-values, t-tests, chi-square — what they do and do not tell you
Business maths	Percentages, growth rates, CAGR, ratios, index numbers
Correlation vs causation	Why a strong correlation is not proof of cause

Free official resources: Khan Academy (statistics and probability), StatQuest (YouTube), Microsoft Learn (business statistics basics).

Mini project: Take a dataset and compute descriptive statistics for three business metrics. Write a one-page summary explaining what the numbers mean and what you would investigate next.

You are ready for the next stage when: you can explain what a p-value does and does not mean, and you can spot an outlier in a distribution.

05

Stage 4

Python for analysis — pandas, NumPy, Matplotlib

Python lets you handle datasets too large for Excel. This stage teaches you the pandas and NumPy basics you need for analysis, and how to make charts with Matplotlib.

Topics checklist
Topic	What to cover
Python basics	Variables, data types, loops, conditionals, functions, error handling
pandas	DataFrames, indexing, filtering, groupby, merge, handling missing values
NumPy	Arrays, broadcasting, vectorised operations, basic statistics
Matplotlib	Line, bar, scatter, histogram, subplots, styling
Jupyter notebooks	Cells, markdown, running code, exporting notebooks

Free official resources: Python documentation (docs.python.org), pandas documentation, NumPy documentation, Matplotlib documentation.

Mini project: Load a public CSV into pandas, clean two columns, compute three summary metrics and plot two charts.

You are ready for the next stage when: you can load a CSV, filter it, group it and plot the result — without copying from a tutorial.

06

Stage 5

Data cleaning & exploratory data analysis

Most of an analyst's time goes into cleaning data and understanding it. This stage teaches a repeatable process for cleaning a messy dataset and producing an EDA report.

Topics checklist
Topic	What to cover
Data profiling	Column types, missing values, unique values, ranges, duplicates
Cleaning steps	Fixing types, handling missing values, dealing with outliers, standardising text
Documentation	Recording every cleaning decision so it can be repeated or challenged
EDA	Univariate and bivariate analysis, correlation checks, segment comparisons
Insight writing	Turning charts into 3–5 clear findings with a recommendation

Free official resources: pandas documentation (missing data, groupby), Kaggle Learn (Data Cleaning, EDA), Microsoft Learn (data preparation basics).

Mini project: Take a messy public dataset, clean it step by step, document the decisions, and write a short EDA report with 5 findings.

You are ready for the next stage when: your EDA report explains what the data does and does not show, and the cleaning steps could be repeated by someone else.

07

Stage 6

Power BI (and Tableau basics) — modelling, DAX, dashboards

A dashboard is how you show data to stakeholders. This stage teaches you to build a data model, write basic DAX and design a one-page dashboard that answers a business question.

Topics checklist
Topic	What to cover
Connecting data	Connecting to Excel or a database, basic data model, relationships
DAX basics	Measures, CALCULATE, simple time intelligence
Visuals	Bar, line, card, table, slicer — choosing the right visual for the question
Tableau basics	Dimensions vs measures, basic charts, filters, dashboards
Storytelling	One dashboard, one message, a short written summary for stakeholders

Free official resources: Microsoft Learn (Power BI), Tableau learning resources, SQLBI (DAX basics).

Mini project: Build a one-page dashboard on a public dataset and write a one-page stakeholder summary — what the numbers say and what you would recommend.

You are ready for the next stage when: a stakeholder can read your dashboard and your one-page summary without you explaining it.

08

Stage 7

AI & Gen AI tools for analysts — using LLMs for SQL/Excel help, summarising, with checks

AI can speed up SQL writing and summarising, but it can also produce confident wrong answers. This stage teaches you how to use it without lowering quality.

Topics checklist
Topic	What to cover
Where AI helps	Drafting SQL queries, explaining formulas, summarising a dataset, rewriting a report section
Where AI fails	Wrong joins, invented column names, missing business context, unsafe query suggestions
Review discipline	Running every query, checking counts, comparing with a manual result before sharing
Privacy	Not pasting confidential business data into public AI tools
Tools	ChatGPT, Microsoft Copilot — with a documented review process

Free official resources: Vendor documentation for ChatGPT and Microsoft Copilot, OWASP guidance on AI risks.

Mini project: Use an AI tool to draft five SQL queries and summarise a dataset, then review and correct them. Write a short note on what needed changing.

You are ready for the next stage when: you can explain when to trust an AI-generated query or summary and when to rewrite it from scratch.

09

Stage 8

Portfolio, resume, LinkedIn and interview prep

The final stage turns learning into a portfolio. Three to four projects with dashboards and clear write-ups are worth more than a list of certificates.

What to build and prepare
Item	What it involves
3–4 portfolio projects	One Excel analysis, one SQL project, one Python EDA and one Power BI dashboard
Portfolio document	One document with screenshots, problem statement, approach and findings for each project
Resume	One-page resume that leads with projects and tools used
LinkedIn	Headline, about section, project posts, skills aligned to job descriptions
Interview prep	SQL questions, Excel logic, dashboard walkthroughs, explaining your cleaning decisions

Interview prep: Be ready to walk through your projects from problem to finding. Expect SQL questions, basic statistics questions and a dashboard walkthrough. Practise explaining why you cleaned a column a particular way.

You are ready to apply when: you have a portfolio with 3–4 projects, a resume and a LinkedIn profile that lists the same tools you can actually use.

10

Portfolio

Projects to build along the way

Each stage produces one artefact. By the end, these projects are your portfolio — they prove you can clean data, query it, analyse it and present it, not just talk about it.

Stage → project → what it proves
Stage	Project	Tools	What it proves
Stage 1	Excel analysis workbook	Excel	You can analyse business data and summarise findings
Stage 2	SQL business questions	MySQL, PostgreSQL	You can answer business questions from data yourself
Stage 3	Statistics summary	Excel or Python	You can interpret and explain descriptive statistics
Stage 4	Python analysis notebook	pandas, NumPy, Matplotlib	You can load, clean and analyse data in Python
Stage 5	EDA report	pandas, Matplotlib or Seaborn	You can clean a messy dataset and write findings
Stage 6	Power BI dashboard	Power BI, Tableau	You can present data to stakeholders clearly
Stage 7	AI-assisted SQL notes	ChatGPT, Copilot	You can use AI tools responsibly with review
Stage 8	3–4 portfolio projects	All of the above	You can run an end-to-end analyst workflow

11

Pace

Fast-track vs part-time plan

The roadmap is the same either way — only the pace changes. Choose the plan that fits your available hours, not the one that looks impressive.

Time estimates — starting from zero
Plan	Weekly effort	Estimated months	Best for
Fast-track	20+ hours a week	3–4 months	Full-time learners, career switchers with free time
Part-time	10–12 hours a week	5–6 months	Working professionals, students with college

Estimate note: These are estimates, not guarantees. Your pace depends on how comfortable you already are with Excel and data, and how much time you can protect each week.

12

Starting points

Data Analyst roadmap for different backgrounds

01

Fresher (any degree)

Start with Stage 1 and follow the roadmap in order. Your portfolio matters more than your degree — build the Excel workbook and the Power BI dashboard first.

02

Non-IT / commerce background

You already understand business context, which helps. Spend extra time on SQL and Power BI. A strong dashboard and a clear written summary can open doors without a CS degree.

03

Working professional

Go part-time (10–12 hours a week). Compress Stage 1 if you already use Excel heavily. Focus on Stages 2–8 and ship three strong projects rather than five unfinished ones.

04

Career-gap returner

Treat the portfolio as your re-entry proof. Include the Excel workbook, SQL queries, Python EDA and Power BI dashboard in one document. Add a short write-up of what you learned at each stage.

13

Sequence

Which order should you learn Excel, SQL, Python and Power BI?

The order matters less than finishing a stage before moving on, but some sequences work better for beginners. This table shows the recommended order and why.

Recommended learning order for beginners
Order	What to learn	Why this order
1	Excel	Fastest way to handle data without code and to build confidence early
2	SQL	Most job interviews test SQL, and it is the main way to pull business data
3	Statistics	Makes the analysis meaningful and prepares you for Python-based work
4	Python	Needed for larger datasets, automation and reproducible analysis
5	Power BI (and Tableau)	Turns your analysis into a shareable dashboard for stakeholders
6	AI tools	More useful once you can tell a good query or summary from a bad one

Practical note: If you already know Excel well, start with SQL. If your target job is heavily dashboard-focused, you can bring Power BI earlier — but do not skip SQL, because most interviews test it.

14

Avoid these

Common mistakes on this roadmap

Skipping Excel — it is still the fastest tool for most analyst tasks.
Learning SQL without practising on a real database — syntax alone does not stick.
Jumping to Power BI before you can clean data — a dashboard built on bad data misleads people.
Ignoring statistics — without it, you cannot tell a real pattern from noise.
Trusting AI output without checking — every generated query needs to be run and verified.
Collecting certificates instead of shipping 3–4 portfolio projects.

15

After the roadmap

Jobs you can apply for at the end

At the end of this roadmap you can apply for Data Analyst, MIS Analyst, BI Analyst, Business Analyst and Operations Analyst roles. Uncodemy's Data Analytics page reports the following Noida ranges (sources: AmbitionBox, Glassdoor, Indeed and Uncodemy records; reviewed Sept 2026).

Data Analyst salary in Noida — Uncodemy page, reviewed Sept 2026
Role / level	Salary range	Source
Entry Data Analyst	₹3–6 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
Mid Data Analyst	₹6–10 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
Senior Data Analyst	₹10–15 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
BI Analyst	₹7–12 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026

Note: Salaries vary by city, company, skills and experience. Uncodemy does not guarantee any specific salary or employment outcome.

16

Guided learning

Follow this roadmap with a trainer

Uncodemy's Data Analytics with Gen AI program follows this exact order — Excel, SQL, Python, statistics, cleaning and EDA, Power BI, Tableau, AI tools and a capstone. Fee and duration are verified on the course page.

Uncodemy Data Analytics program
Program	Details
Data Analytics with Gen AI	Data Analytics with Gen AI — ₹17,500 + GST, 6–7 months. 120+ hours, 75+ live sessions, 9 modules, 5 guided projects + 1 capstone. No coding needed. Eligibility: any graduate, any discipline.

Ready to explore? Book a free counselling session, try a 2-class trial or use the AI-powered career guidance tool.

17

FAQs

Data Analyst roadmap FAQs

Q1 How long does it take to become a data analyst? +

For a learner studying 10–12 hours a week, about 5–6 months. The roadmap covers Excel, SQL, statistics, Python, data cleaning and EDA, Power BI and Tableau, AI tools and portfolio prep. A fast-track learner at 20+ hours a week can finish in 3–4 months.

Q2 Can I become a data analyst without coding? +

Yes, for many entry-level roles. Excel, SQL and Power BI do not require programming, and Uncodemy's Data Analytics program is explicitly no-coding. Learning basic Python helps for larger datasets and is worth adding once you are comfortable with SQL.

Q3 Should I learn Python or Power BI first? +

Learn Power BI first if your goal is dashboards and reporting roles. Learn Python earlier if your target roles involve larger datasets or automation. Most beginners are better served by Excel, SQL, then Power BI before adding Python.

Q4 Is SQL enough for a data analyst job? +

No. SQL is essential, but most roles also expect a BI tool like Power BI or Tableau and strong Excel skills. A portfolio with a SQL project and a dashboard is far stronger than SQL alone, and it is what most interviews test.

Q5 Can a B.Com student follow this data analyst roadmap? +

Yes. Uncodemy's Data Analytics program eligibility is any graduate, any discipline. B.Com students usually bring strong business and Excel context. The main work is SQL, statistics and Power BI, not advanced programming.

Q6 What projects should a data analyst build? +

Three to four projects work best: an Excel analysis workbook, a SQL project with business questions, a Python EDA notebook and a Power BI dashboard. Each should have a clear problem statement, a short write-up of findings and a screenshot or live link.