Data Analyst Roadmap India: A Step-by-Step Plan for 2026

Last updated: 21 September 2026 · By the Asuraa Team

What is a data analyst roadmap?

A data analyst roadmap is an ordered plan for learning the skills, building the proof and making the applications that lead to a first data analyst role. This one is written for freshers in India and follows six steps.

If you are new to the role, read what a data analyst is first, then come back here to plan your months.

What are the steps to become a data analyst?

Naukri Campus's guide to becoming a data analyst, dated 1 June 2026, gives six steps. Understand the role, secure an educational background, learn the required skills, gain internship experience, build a portfolio and prepare for interviews.

We have arranged them into this working order.

1. Understand the role. Read job descriptions for analyst, MIS and business analyst roles and note the tools they repeat.
2. Learn Excel and SQL. These are the base for almost every other step.
3. Add a visualisation tool. Pick Power BI or Tableau and build dashboards you can explain.
4. Learn statistics and Python. Add basic statistics, data cleaning and a language for larger or repeated work.
5. Build two or three projects. Use real datasets and write up the question, method and result.
6. Apply and prepare. Tailor your resume, apply in batches and practise interview questions.

How long does the data analyst roadmap take?

Estimates run from about five months to a year, depending on hours per week and starting point. Naukri Campus says you can acquire the necessary skills in six to twelve months through courses and projects. Masai School's 2026 roadmap for India, published 19 August 2026, plans five to six months full-time or eight to ten months part-time.

Masai is a training provider, so read its plan as one example and not a promise. The table shows its phases.

Notice that both sources put tools first and projects before applications. The exact months matter less than that order.

Which skills should you learn first?

Learn Excel and SQL first, then a BI tool, then statistics and Python. Masai's plan follows this order, and Naukri's job description guide names advanced Excel, Tableau and Power BI dashboards, data cleaning and Pandas as valuable skills.

Our post on data analyst skills explains each one and how to practise it. Use real postings as your syllabus, because tools vary by employer and city.

What could a realistic weekly plan look like? (an illustration)

This example is invented and is not a guarantee. Imagine a final-year student with about ten hours a week for six months.

In the first two months, they spend five hours on Excel and five on SQL, finishing with a small sales analysis in each. In months three and four, they learn Power BI and statistics basics, ending with one dashboard project. In months five and six, they learn Python for cleaning, finish a second project, write the resume and begin applying.

That plan is slower than a full-time schedule, which is fine. The point is to finish something every month.

Do you need a degree or a certification?

Not always. Naukri Campus says a degree in computer science, statistics, mathematics or engineering is often preferred but not mandatory, and that online certifications and boot camps can give a foundation.

If you want a certification, Microsoft's Power BI Data Analyst Associate page, last updated 20 April 2026, lists exam PL-300. It says candidates should be proficient with Power Query and DAX, and the exam covers preparing, modelling, visualising and analysing data, and managing Power BI. Price depends on the country where you sit the exam.

Treat any certificate as a supplement. A certificate shows you finished a course, while a project shows you can do the work.

How do you know a step is finished?

A step is finished when you can show its output, not when you have watched the lessons. The checkpoints below are our own suggestions, so adjust them to your target postings.

Use the checkpoints to decide whether to move on, and keep the older skills warm by reusing them in later projects.

When should you start applying?

Start once you have two finished projects and a resume that shows them. This is our editorial rule of thumb and not a sourced figure.

Waiting until you feel fully ready usually delays the search. Apply in batches, learn from the questions you fail, and keep building. Our guide to data analyst jobs for freshers in India covers role titles and where to look, and the Career Path Planner on asuraa.in can help you map skills to a target role.

What do most guides on the data analyst roadmap get wrong?

Most roadmaps are tidy timelines with a course advert at the end. These are the gaps.

• They present one timeline as fact. Sources range from about five months to a year, so plan around your hours.
• They put certificates before projects. Employers can only judge what they can see, and a project is visible.
• They skip the applying step. Learning without applying leaves you without feedback.
• They lead with pay. Salary depends on city, employer and skills, so we do not quote figures here.

FAQ

How do I become a data analyst step by step?

Understand the role, learn Excel and SQL, add a BI tool such as Power BI or Tableau, learn statistics and Python, build two or three projects, then apply and prepare for interviews. Naukri Campus lists a similar six-step route through skills, internships, portfolio and interviews.

How long does it take to become a data analyst?

Naukri Campus says you can acquire the necessary skills in six to twelve months through courses and projects. Masai School plans five to six months full-time or eight to ten months part-time. Your pace depends on your background, weekly hours and how much you practise.

What should I learn first to become a data analyst?

Start with Excel and SQL, because most analyst work touches spreadsheets and databases. Then add a visualisation tool such as Power BI or Tableau, followed by statistics and Python. Check the tools named in postings for your target role and city, and adjust the order.

Can a fresher become a data analyst without a degree in computer science?

Yes, in many cases. Naukri Campus says a degree in fields such as computer science, statistics, mathematics or engineering is often preferred but not mandatory. Employers set their own rules, so check each posting and back your application with projects.

Is a certification necessary to become a data analyst?

No, but it can help structure your learning. Naukri Campus lists Google, IBM and Microsoft certificates as options, and Microsoft's PL-300 covers Power BI, Power Query and DAX. A certificate supplements finished projects you can explain and does not replace them.

When should I start applying for data analyst jobs?

Start when you have two finished projects and a resume that shows them, rather than waiting to feel fully ready. This is our editorial advice. Apply in batches, review the questions you struggled with, and keep improving your projects while you search.

Final thoughts

A good roadmap is short: learn the tools in order, prove them with projects, and start applying before you feel finished. Adjust the timeline to your hours and your background.

To see how your resume reads against a real analyst posting, try the AI resume reviewer on asuraa.in. You can also work on your data analyst portfolio projects while you learn.