In short
- A data analyst answers "what happened, and why?" The daily work is SQL queries, checking numbers and explaining them in charts and short notes.
- The analyst toolkit sits almost entirely in year 1: SQL, two statistics modules, Pandas, visualisation, business analytics and dashboards.
- Accuracy and clear writing count as much as coding. One wrong join can mislead a team, and a plain summary is what managers act on.
A data analyst turns a company's records into answers people can act on. They write SQL to pull data, check it with statistics, build dashboards and charts, and explain in plain words what changed and why. It is often the first job in the data field.
What does a data analyst do day to day?
A data analyst spends most days pulling data with SQL, checking it for errors, working out what changed and why, and explaining the answer through charts, dashboards and short written summaries.
Work usually starts with a question from sales, marketing, finance or operations, such as "why did orders drop last week?" The analyst writes SQL to pull the right rows, cleans gaps and duplicates, and compares periods and groups. Then they check whether a change is real or just noise. The answer goes out as a chart, a dashboard update or a short note that also states its limits.
The main tools in this roadmap are SQL, Python with Pandas and NumPy, and Jupyter notebooks, with Git and GitHub to keep work saved and shareable. Many offices also use spreadsheets and business intelligence tools. The program does not list Excel, Power BI or Tableau, so practise a spreadsheet on your own.
How it differs from a data scientist. An analyst explains the past and present: what happened, where and why. A data scientist also builds machine learning models that predict what comes next, which needs more maths and coding. In this program, the analyst toolkit is year 1, and machine learning starts in year 2. The data scientist page covers that longer path.
Can you start on the path to a data analyst right after Class 10?
Yes. You can start after Class 10, because analyst work rests on SQL and school-level statistics, both taught from zero in year 1, and these are enough to answer real questions about real tables.
Data analysts come from more streams than most tech roles. Here is how each choice for Class 11 and 12 plays out.
| Path after 10th | What it keeps open | Watch out for |
|---|---|---|
| Commerce with Mathematics | B.Com, BBA, economics and business analytics degrees. A natural fit for sales, finance and marketing data. | B.Tech through JEE Main needs Physics and Mathematics, so that route closes. |
| Science with Maths (PCM) | B.Tech, BCA and B.Sc in statistics or computer science. Opens analyst and later data science roles. | A heavier study load. Analysis practice has to fit around entrance preparation. |
| Humanities with Mathematics or Economics | Economics, psychology and social science degrees, which feed policy and research analysis. | Without any maths in Class 11 and 12, statistics feels harder. Keep Mathematics or Economics if you can. |
For the NITs and other institutes that fill B.E. and B.Tech seats through JEE Main, the 2026 rules ask for Physics, Mathematics, a language, one of Chemistry, Biotechnology, Biology or a technical vocational subject, and one more subject in Class 12. State colleges can set their own rules.
The stream matters less for analysts than for engineers. Employers mostly want proof that you can query data, check it and explain it. A small set of finished analysis projects shows that better than marks alone.
What is the year-by-year roadmap to become a data analyst?
For a data analyst, year 1 does most of the work: Python, SQL, two statistics modules, visualisation, business analytics and dashboards, while years 2 and 3 add forecasting, data pipelines and experimentation for stronger analyst roles.
Each year is 208 hours, split into 12 monthly modules. Every month follows the same five steps, so a student always knows what comes next.
- Step 1Theory
- Step 2Demonstration
- Step 3Hands-on lab
- Step 4A project
- Step 5A 1-hour exam
Year 1208 hours · 12 modules
Year 1: the core analyst toolkit, from SQL and statistics to dashboards
- Computer, Data & Python Foundations
- Python Programming for Data
- SQL Fundamentals
- Statistics I
- Statistics II
- NumPy & Pandas
- Data Visualization
- Exploratory Data Analysis
- Business Analytics
- Dashboarding
- Google Data Analytics Preparation
- Year-1 Capstone & DP-900
You build: SQL Analytics Repository, Exploratory Statistics Report, Data Cleaning Notebook Portfolio, Data Storytelling Report, Business Analytics Case Study, Analytics Dashboard and Google-Style Analytics Capstone.
Year 2208 hours · 12 modules
Year 2: forecasting, segmentation and the data pipelines analysts depend on
- Machine Learning Foundations
- Feature Engineering & Evaluation
- Classification & Ensembles
- Unsupervised Learning
- Time Series
- Data Engineering Foundations
- Python Data Engineering
- Azure ML & AI-300 Preparation
- ML Deployment & MLOps
- IBM Data Science Integration
- IBM Data Engineering Integration
- Year-2 Integrated Capstone
You build: Regression & Classification Project, Model Evaluation Portfolio and Classification System.
Year 3208 hours · 12 modules
Year 3: experimentation, advanced analytics and a portfolio that tells stories
- Advanced Machine Learning
- Deep Learning
- NLP
- Computer Vision
- Generative AI & RAG
- Data Engineering at Scale
- Advanced Analytics & Experimentation
- Responsible AI
- MLOps
- Real-World Data Project
- GitHub, Portfolio & Interviews
- Final Data Science & AI Capstone
You build: Product Experimentation Case.
If you want to follow this roadmap with a mentor and a project every month, the 3-year Data Science & AI program covers these three years: 624 hours, online, 4 hours a week, with a 1-hour exam after each of the 36 monthly modules. It is open to anyone from Class 11 onwards (absolute beginners welcome). Students receive a Neuronetworks AI Ed certificate on completion.
What this program does not cover: This program serves both analysts and data scientists. Years 2 and 3 cover machine learning and AI that a pure analyst may not use daily. Its listed tools are Python, SQL, Git, GitHub, Linux, NumPy, Pandas, Jupyter and Azure. It does not list Excel, Power BI or Tableau, so practise a spreadsheet tool on your own as well.
Which skills does a data analyst need?
A data analyst needs SQL, statistics, data cleaning, Python with Pandas, charts and dashboards, business sense, simple forecasting and, above all, the ability to tell a clear story from the numbers.
Nasscom's Strategic Review 2026 puts employment in India's tech industry near 6 million. Analysts who can explain data clearly are useful across that whole industry, not only in tech teams.
| Skill | Why it matters | When you learn it |
|---|---|---|
| SQL | The daily tool for pulling and joining company data. | Year 1, its own module |
| Statistics I and II | Averages, spread, sampling and tests: how you know a change is real. | Year 1 |
| Data cleaning with Pandas | Real data has gaps and errors. Cleaning comes before any answer. | Year 1 |
| Data visualisation | Picking the chart that makes the point obvious. | Year 1 |
| Dashboarding | Gives managers a live view instead of a one-time report. | Year 1 |
| Business analytics | Links numbers to sales, costs and customers. | Year 1 |
| Data storytelling | Turns findings into a short, clear message people act on. | Year 1, used every year after |
| Time series and forecasting | Answers "what will next month look like?" | Year 2 |
| Experimentation | Tests whether a change, like a new button or offer, really worked. | Year 3 |
What will you build on the way?
You build one project every month, and the first twelve already form an analyst portfolio: SQL work, statistics reports, cleaned datasets, a business case, a dashboard and a capstone.
These are real projects from the Data Science & AI roadmap, in the order a student meets them:
- SQL Analytics Repository. A public set of queries that proves you can work with real tables.
- Exploratory Statistics Report. Your first written report that explains data with numbers.
- Data Cleaning Notebook Portfolio. Shows the unglamorous skill every analyst job needs.
- Data Storytelling Report. Practice turning a chart into a decision someone can make.
- Business Analytics Case Study. A business question answered from start to finish.
- Analytics Dashboard. A dashboard a manager could open each morning.
- Google-Style Analytics Capstone. A complete case in the style of the Google Data Analytics certificate.
- Product Experimentation Case. A test of whether a product change worked, a common analyst task.
A parent can open the GitHub page at any time and see the work. That is often more convincing than a marksheet.
What is a realistic first project for a future data analyst?
A realistic first project is a two-to-three-week study of data you collect yourself, such as your daily screen time or sleep, ending in two clear charts and a one-page summary that answers one question.
Pick one question you care about, such as "on which days do I use my phone most?" Then:
- Week 1 and 2: record the data every day in one simple table, or use a small public dataset instead.
- Week 2: clean it. Fix missing days, wrong entries and mixed units, and write down every fix.
- Week 3: work out averages and totals by day of the week, and find the highest and lowest days.
- Week 3: make two charts, one showing change over time and one comparing groups.
- Finish with a one-page summary: the answer, the evidence, and what the data cannot tell you.
A spreadsheet is enough to start. If you have begun learning SQL or Python, redo the totals in code. This is a small version of the program's Exploratory Statistics Report and Data Storytelling Report, both in year 1.
Which certificates help a future data analyst?
For analysts, the Google Data Analytics certificate and Microsoft DP-900 are the most relevant in this roadmap, but each is awarded by its own body, and employers will still ask to see your analysis work.
The Data Science & AI program prepares students for these 6. Each is awarded by its own certifying body after its own exam, and passing is not guaranteed.
- Microsoft Certified: Azure Data Fundamentals (DP-900). A beginner exam on core data concepts, relational and non-relational data, and analytics workloads on Azure. Microsoft aims it at people starting with data in the cloud.
- HackerRank Python & SQL Certificates.
- Google Data Analytics Professional Certificate. A 9-course series on Coursera covering data cleaning, analysis and visualisation with spreadsheets, SQL and other tools. Google says no degree or prior experience is needed.
- IBM Data Science Professional Certificate.
- Microsoft AI-300 (Machine Learning Operations Engineer Associate).
- IBM Data Engineering Professional Certificate.
Both the Google certificate and DP-900 are prepared for in year 1, which is why an analyst can build a credible profile early.
What laptop do you need to become a data analyst?
You need a laptop or desktop with internet, because a phone alone is not enough for the labs. This is the setup recommended for the Data Science & AI program.
- CPU: Intel Core i7 / Ryzen 7 or equivalent
- RAM: 32 GB
- Storage: 1 TB NVMe SSD
- GPU: NVIDIA RTX 4060/5060, 8 GB VRAM+
- Display: 14–16" Full HD/2K IPS
- OS: Windows 11 + WSL2 / Linux
These are recommendations, not entry requirements. Ask us if your current computer is enough to start.
Who should not choose this path?
This path is not for you if you dislike checking details, want to avoid writing and presenting, or expect analysis to be all coding, because much of the job is careful checking and clear explaining.
- Small mistakes in numbers do not bother you. Analysts are trusted for accuracy. One wrong join can mislead a whole team.
- You hate explaining your work. Reports, charts and short talks are a big part of the role.
- You want to build apps, not study data. The Software Development program fits that better.
- You expect a guaranteed job. No honest course can promise a job, salary or exam pass, and this one does not.
- You can only study now and then. Plan for 4 hours of classes a week for three years, plus practice.
Other paths to compare: AI Foundation, AI/ML Engineering, Software Development, Product and UX/UI Design, Cybersecurity.
What should parents ask before choosing a course?
Parents should ask five things of any course: can I see the full curriculum, what will my child build, how is learning checked, who answers questions, and what exactly is promised.
- Can I see the whole curriculum, month by month? A good course shows every module and its hours before you pay.
- What will my child build, and where will I see it? Ask for project names and whether work goes on GitHub.
- How is learning checked, and how often? Regular exams and practicals show progress early, not only at the end.
- Who answers questions, and how quickly? Ask how doubts are handled between classes.
- What is promised, and what is not? Get the certificate, timings and fees in writing. Be careful of anyone who guarantees a job or salary.
What can a data analyst earn in India?
Indicative ranges for data roles in India, including analysts, are about ₹4 to 8 lakh a year for freshers, ₹10 to 22 lakh at 3 to 5 years, and ₹25 to 50 lakh or more at senior level.
| Experience | Indicative range (per year) |
|---|---|
| Fresher | ₹4–8 LPA |
| 3–5 years | ₹10–22 LPA |
| Senior | ₹25–50+ LPA |
Indicative market ranges, not a promise. Pay depends on employer, city, role and skills, and for some employers, a degree. Neuronetworks AI Ed does not guarantee a job, internship or salary.
Frequently asked questions
How many years does it take to become a data analyst after 10th?
The core analyst skills come in year 1 of the 3-year, 624-hour Data Science & AI program, and the next two years build depth. Many employers also expect a degree, so most people reach an analyst job after Class 12 and a degree, with skills built alongside.
Can I become a data analyst without maths?
Yes, more easily than in most data roles, because analysts mainly use school-level statistics, which the program teaches in two modules. Keeping Mathematics or Economics in Class 11 and 12 still makes statistics much easier and keeps more degrees open.
Is a data analyst the same as a data scientist?
No. A data analyst explains what happened and why, using SQL, statistics and dashboards. A data scientist also builds machine learning models to predict what comes next. Many people start as analysts and move into data science later.
Do I need coding to become a data analyst?
Some, yes. SQL is essential, and Python with Pandas helps with larger or messier data. Both are taught from the beginning in year 1, so no prior coding is expected.
Can a commerce student become a data analyst?
Yes. Commerce with Mathematics is a strong base for business and finance analysis. What matters most is proof that you can query, clean and explain data.
Sources
Checked on 18 October 2026.
- Google Data Analytics Professional Certificate, Coursera, checked 18 October 2026
- Microsoft Certified: Azure Data Fundamentals (DP-900), Microsoft Learn, page updated 21 July 2026
- JEE (Main) 2026 Information Bulletin, National Testing Agency, November 2025. Class 12 subjects for B.E. and B.Tech admission through JEE Main (section 5.8.1).
- Technology Sector in India: Strategic Review 2026, Nasscom, February 2026. Industry revenue, employment and technology trends.
- Data Science & AI program roadmap, Neuronetworks AI Ed. Modules, projects, hours, certifications and laptop recommendations.
