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. #1Eligibility and baselineFirst 30 days

   Verify subject, marks, age and route. Take a diagnostic for: Statistics; Excel; SQL; Python/pandas; data cleaning; visualisation; dashboards; business metrics

   Output: Eligibility checklist, baseline score and weekly calendar.

   Exam action: Use current official route: CUET/university admission; employer aptitude, SQL, case and portfolio tests.

   Move on when: One valid primary route, one backup and no unresolved eligibility issue.

   If it stalls: If current stream is blocked, confirm an accepted alternative before starting exam coaching.

   Resource: Khan Academy · Open learning platform · Free

2. #2Foundation and syllabus startMonths 2–3

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

   Output: Complete foundation modules, concise notes and weekly tests.

   Exam action: Download official syllabus/sample/PYQs and create a topic matrix.

   Move on when: At least 70% competency in foundation tests or a clear remediation plan.

   If it stalls: If workload harms boards, reduce optional resources and keep one primary exam.

   Resource: Kaggle Learn · Kaggle · Free

3. #3Core preparation and first evidenceMonths 4–6

   Learn Python/pandas, dashboarding, data cleaning, business metrics and analytical writing.

   Output: Complete first major project/practice set: School survey dashboard; public-data analysis; college business case and interactive dashboard

   Exam action: Begin timed sectionals/PYQs: Timed SQL, chart interpretation and business-case presentation.

   Move on when: Project is reviewed and sectional scores show improvement.

   If it stalls: If progress is passive or copied, rebuild a smaller original output.

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

4. #4Advanced preparationMonths 7–9

   Add experimentation, data modelling, portfolio case studies and stakeholder presentation.

   Output: Complete second evidence item, portfolio refinement or full mock cycle.

   Exam action: Practise official mock/sample papers and application-stage tasks.

   Move on when: Candidate can explain work, complete timed tasks and identify weak areas.

   If it stalls: If target is highly uncertain, apply to compatible backup programmes too.

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

5. #5Boards, revision and documentsMonths 10–12

   Prioritise board syllabus, high-yield revision, spaced recall and application accuracy.

   Output: Final revision notebook, documents, category certificates where applicable and application calendar.

   Exam action: Submit applications through official portals; verify photograph/signature/category/subject details.

   Move on when: Board and entrance readiness is stable; no missing document or deadline.

   If it stalls: If competitive score is unlikely, use realistic public/private/degree alternatives rather than a fraudulent route.

   Resource: CUET UG 2026 · NTA · Application fee varies

6. #6Counselling, admission or skill entryPost-board admission phase

   Compare institutions, recognition, curriculum, cost, scholarships and outcomes for: BSc/BCom/BBA/Economics/BCA/BTech or related degree plus Excel, SQL and dashboard portfolio.

   Output: Institution comparison with total cost, refund rules, accreditation and backup seat.

   Exam action: Participate in counselling/seat allocation or recognised apprenticeship/skill admission.

   Move on when: Admission is recognised, affordable and aligned with the target and backup.

   If it stalls: Reject unrecognised programmes and guaranteed-placement/admission claims.

   Resource: Kaggle Learn · Kaggle · Free

7. #7Employability and professional entryDegree / professional qualification years

   Follow year-wise depth: foundations → projects → internships → advanced portfolio → selection. College analytics internship; NGO/school data project; campus club reporting

   Output: Portfolio and experience requirement: Three case studies showing question, data cleaning, analysis, visualisation and recommendation

   Exam action: Prepare application/interview: BSc Statistics/Math/CS, BCA, BTech, Economics or related degree; portfolio-led internships and hiring. SQL, spreadsheets, statistics, dashboard case and communication.

   Move on when: Ready for: Data Analyst, BI Analyst, Business Analyst Trainee, Reporting Analyst. with required qualification and evidence.

   If it stalls: Use backup: Operations Analyst, Market Research Analyst, Finance Analyst. or alternative: Any degree + strong Excel/SQL; vocational software/data route. if the primary route changes.

   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