Data Analyst / Business Analyst

How long it takes

Fast track

Class 12 → 3-year degree + portfolio: 3.5–4.5 years.

Realistic

3-year degree with projects and internship.

Part-time

5–7 years from Class 8–10.

Weekly commitment: 6–12 hours/week.

Month-by-month plan (7 milestones)

1. #1Career reality and aptitude auditFirst 30 days

   Study the daily work, route, subjects and constraints for Data Analyst / Business Analyst. Complete the current-level assessment.

   Output: One-page career comparison, baseline subject scores and parent/guardian discussion.

   Exam action: No exam coaching purchase; verify only official eligibility and recognised routes.

   Move on when: Proceed only if the student understands the work, time, cost and at least one backup.

   If it stalls: If interest is based only on salary/status, explore two alternative career families.

   Resource: Khan Academy · Open learning platform · Free

2. #2Foundation strengtheningMonths 2–3

   Strengthen the most transferable foundations: Statistics; Excel; SQL; Python/pandas; data cleaning; visualisation; dashboards; business metrics

   Output: Complete weekly problem sets and a mini output using: Excel/LibreOffice; SQL; Python; Power BI/Tableau; Git

   Exam action: Use NCERT/ePathshala/DIKSHA; no entrance over-specialisation.

   Move on when: School marks and diagnostic performance improve; study routine is sustainable.

   If it stalls: If foundations remain weak, reduce extracurricular load and remediate before advanced preparation.

   Resource: Kaggle Learn · Kaggle · Free

3. #3First practical evidenceMonths 4–6

   Develop mathematics, statistics, spreadsheets, SQL and data visualisation.

   Output: Complete an age-appropriate original project: School survey dashboard; public-data analysis; college business case and interactive dashboard

   Exam action: Explore relevant competitions: Data visualisation contests; economics/statistics projects; Kaggle beginner datasets

   Move on when: Project is original, documented and reviewed by a teacher/mentor.

   If it stalls: If the student only copies tutorials, repeat with a smaller original problem.

   Resource: SWAYAM · Government MOOC · Free learning; optional certificate fee

4. #4Stream and route explorationMonths 7–12

   Compare compatible streams, degrees, institutions, costs and backups. Direct subject rule: Mathematics or statistics is helpful; many degree routes are open to all streams.

   Output: Stream decision matrix with target, backup, marks trend and cost/scholarship plan.

   Exam action: Review admission routes: CUET/university admission; employer aptitude, SQL, case and portfolio tests.

   Move on when: A primary stream and backup stream are chosen from evidence, not peer pressure.

   If it stalls: If the chosen stream blocks the target, confirm a bridge or change the target before Class 11.

   Resource: SWAYAM · Government MOOC · Free learning; optional certificate fee

5. #5Final stream selectionClass 10 decision phase

   Select Class 11–12 subjects that preserve eligibility for Data Analyst / Business Analyst; protect board preparation.

   Output: Written subject/stream plan, school availability check and bridge-risk note.

   Exam action: Check official exam/institution subject requirements for the expected application year.

   Move on when: Selected stream is available, affordable and compatible with target and backup.

   If it stalls: If school does not offer required subjects, compare another school/open-board/alternative career route.

   Resource: CUET UG 2026 · NTA · Application fee varies

6. #6Board plus entrance/skill preparationClass 11–12

   Follow the beginner/intermediate plan: Develop mathematics, statistics, spreadsheets, SQL and data visualisation. Learn Python/pandas, dashboarding, data cleaning, business metrics and analytical writing.

   Output: Complete a stronger project/portfolio item and official PYQs or sample papers.

   Exam action: Primary route: CUET/university admission; employer aptitude, SQL, case and portfolio tests.. Do not prepare for incompatible exams simultaneously.

   Move on when: Boards remain strong, syllabus is covered and mock/project evidence meets the target threshold.

   If it stalls: If mock scores or interest remain poor after a full cycle, activate the documented backup course.

   Resource: Kaggle Learn · Kaggle · Free

7. #7Degree, diploma or professional routePost-Class 12 qualification and entry

   Complete: BSc/BCom/BBA/Economics/BCA/BTech or related degree plus Excel, SQL and dashboard portfolio. Add Add experimentation, data modelling, portfolio case studies and stakeholder presentation.

   Output: Use internships/experience: College analytics internship; NGO/school data project; campus club reporting Portfolio: Three case studies showing question, data cleaning, analysis, visualisation and recommendation

   Exam action: Complete selection/application route: BSc Statistics/Math/CS, BCA, BTech, Economics or related degree; portfolio-led internships and hiring.

   Move on when: Final readiness: Data Analyst, BI Analyst, Business Analyst Trainee, Reporting Analyst. with verified qualification and evidence.

   If it stalls: Use backup: Operations Analyst, Market Research Analyst, Finance Analyst. if eligibility, finance or selection does not work.

   Resource: SWAYAM · Government MOOC · Free learning; optional certificate fee

Resources listed for this route

• SWAYAM · Government MOOC · Free learning; optional certificate fee
• Khan Academy · Open learning platform · Free
• Kaggle Learn · Kaggle · Free
• CUET UG 2026 · NTA · Application fee varies
• National Career Service · Ministry of Labour and Employment · Free