This data analyst roadmap for 2026 is a week-by-week plan for freshers, career switchers and testers in India. It assumes 1–2 hours a day. Each stage ends with something you can show a recruiter, because a portfolio matters more than a list of certificates.
Tip: save this roadmap as a PDF from your browser (Ctrl+P → Save as PDF) and tick off each week.
Who This Roadmap Is For
- Freshers after BCom, BBA, BSc, BCA, BTech or MBA.
- Software and ETL testers who already validate data.
- Working professionals in finance, sales, HR or operations who live in Excel.
The 16-Week Data Analyst Roadmap
| Weeks | Learn | Output to show |
|---|---|---|
| 1–2 | Excel: formulas, XLOOKUP, PivotTables, charts | One cleaned sales sheet with a pivot summary |
| 3–4 | Power Query: combine files, clean, reshape | A refreshable report from 12 monthly files |
| 5–6 | SQL: SELECT, GROUP BY, joins, window functions | 20 solved queries (see SQL for testers) |
| 7–8 | Python with pandas: load, clean, merge, group | pandas notebook on a real dataset |
| 9–10 | EDA and AI tools: Claude, ChatGPT prompts | Titanic EDA + prompt library |
| 11–12 | Power BI or Tableau dashboards | One dashboard with 4 defined KPIs |
| 13 | Statistics basics: averages, spread, correlation | Short write-up of findings with caveats |
| 14 | Data modelling: facts, dimensions, star schema | A simple star schema diagram |
| 15 | Portfolio: GitHub, LinkedIn, resume | 2–3 projects with clear READMEs |
| 16 | Interview prep | 30 fresher questions answered aloud |
Where AI Fits in the Roadmap
Use AI from week 1 as a tutor (“explain this formula”), and from week 9 as a work tool: profiling data, writing pandas or SQL, and drafting insights. Always check the result yourself. Employers increasingly ask “how do you use AI in analysis?”, and a good answer shows both speed and verification. Copy-ready prompts are in Claude prompts for data analysis.
Projects to Build
- Sales analysis: monthly revenue, top products, region growth (Excel + Power Query).
- EDA project: Titanic or an Indian public dataset (data.gov.in) in pandas.
- Dashboard: a KPI dashboard in Power BI with written KPI definitions.
- Data quality project (great for testers): compare a source and target file and report differences, as in data reconciliation.
How to Become a Data Analyst After BCom, BCA or 12th
Any degree can work; recruiters check skills and projects. After 12th, a graduate degree in any stream plus this roadmap is a common route. After BCom, your finance knowledge is an advantage for finance and MIS analyst roles. After BCA or BSc, SQL and Python will feel easier. For testers, see ETL tester vs data analyst.
Mistakes to Avoid
- Collecting certificates without building projects.
- Skipping SQL because Python feels more exciting.
- Trusting AI outputs without checking totals.
- Paying a large fee for a “guaranteed placement” without a written refund policy.
Why Students Enrol in Claude AI for Data Analysis & BI
- Short and practical: about 5 hours, so working students can finish it in a week of evenings.
- AI-first: 10 core Claude AI prompts for data analysis and BI, plus a hands-on ChatGPT section.
- Real skills behind the AI: pandas for cleaning and merging, EDA on the Titanic dataset, charts, Excel and Power Query.
- Job focus: a final assignment and a practice interview questions section for data analysis and BI.
- Low risk: rated 4.9 by 20 students, lifetime access, and Udemy’s refund policy applies.
| Section in the course | Lectures | What you practise |
|---|---|---|
| Introduction | 10 (46 min) | Setting up and the analysis workflow |
| Claude AI 10 Prompts for Data Analysis & BI | 4 (21 min) | Prompts that turn a raw file into answers |
| Data Manipulation with Pandas | 14 (36 min) | Transform, clean and merge data in Python |
| Exploratory Data Analysis on the Titanic dataset | 5 (18 min) | A full EDA on a real dataset |
| Data Visualization with Pandas | 9 (26 min) | Charts straight from a DataFrame |
| Feature Engineering in Excel using Claude AI | 5 (23 min) | New columns and features in Excel with AI help |
| EDA with AIPRM ChatGPT | 2 (28 min) | Hands-on EDA tasks with ChatGPT prompts |
| Data Analysis with Power Query | 2 (1 hr) | Clean and shape data in Excel / Power BI |
| Final assignment, practice interview questions, tips & tricks | — | Apply it and get interview-ready |
The course has 12 sections, 58 lectures and about 5 hours of video, in English, rated 4.9 by 20 students (107 students as of October 2026). It is a focused skill course, not a full degree: it does not teach SQL in depth, statistics, Tableau or Power BI DAX. List price is $27.99; the price you see in India may be lower during Udemy sales.
Data analysis with AI: Claude AI for data analysis · Claude prompts for data analysis · pandas for data analysis · EDA on the Titanic dataset · data analyst interview questions · AI data analyst course in India · business intelligence course · ETL testing vs data analyst · data analytics for working professionals · AI tools for data analysis
Frequently Asked Questions
What is the roadmap to become a data analyst in 2026?
Excel and Power Query, then SQL, Python with pandas, EDA and AI tools, a BI tool such as Power BI, basic statistics, 2–3 projects and interview practice. The plan above takes about 16 weeks at 1–2 hours a day.
How can I become a data analyst as a fresher in India?
Follow a structured roadmap, build 2–3 projects on real data, publish them on GitHub or LinkedIn, and practise common interview questions.
Can I become a data analyst after BCom?
Yes. BCom graduates often start in finance, MIS or business analyst roles. Strong Excel, SQL and one BI tool are the key skills.
Is there a data analyst roadmap PDF?
Use your browser’s print option (Ctrl+P, then Save as PDF) to save this roadmap.
How long does it take to become a data analyst?
Many learners become job-ready in 4–6 months of consistent study with projects. It depends on your starting point and time.
Asim Noaman Lodhi
Certified Google Partner · QA Consultant · 12+ Years IT
QA consultant specializing in ETL testing and data quality. Trained 913+ students to transition into data testing roles through hands-on, real-world instruction.