Vihara Tech
Back to course
Journey Map

Data Analysis with GenAI

The complete 180-day journey — every phase, every week, every exam, every placement drive. This is how you'll actually spend the next 6 months.

Total Duration
180 Days
6 months · 25 weeks
Total Phases
7
5 learning + 2 learning & internship
Learning Track
17 Weeks
Phases 1–5 · ~120 days
Learning & Internship
8 Weeks
Phases 6–7
Total Exams
25
Every Saturday
Interviews Per Month
8+
During the placement phase
Weekly Rhythm

Two phases. Two completely different weeks.

Your day-to-day changes after Week 17, when the paid internship begins alongside your remaining modules.

Learning Track

Phase 1 · Weeks 1 – 17

Learning & Foundation

Deep-dive into core concepts, coding, aptitude, and communication.

Monday – Friday
  • 1 hr 30 min live class
    Core subject deep-dive
  • Practice sessions
    Hands-on coding lab
  • Assignments
    Daily submissions
  • Communication training
    GD · JAM · presentations
  • Aptitude & reasoning
    Interview-grade problem solving
  • Daily activities
    LinkedIn · GitHub · workshops
Saturday
Weekly Exam
Sunday
Rest / Revision
Learning & Internship Track

Phase 2 · Weeks 18 – 25

Learning & Paid Internship

Keep learning the remaining modules while you complete a PAID internship — plus mocks and drives.

Monday – Friday
  • Placement classes
  • Remaining modules
    Continue learning alongside work
  • PAID internship — 6 hrs / day
    Stipend-based, real projects at The Skill Union
  • Interview preparation
    Technical + HR rounds
  • Mock interviews
    Weekly recorded reviews
  • Resume + portfolio building
    LinkedIn · GitHub polish
  • Company interview drives
    8+ opportunities / month
Saturday
Drive / Interview
Sunday
Rest / Revision
Master Timeline

7 phases. 2 tracks. 1 outcome.

1
Python for Data Analysis
Weeks 1 – 8
2
Power BI
Weeks 9 – 11
3
Excel for Business Analytics
Week 12
4
SQL & Databases
Weeks 13 – 15
5
Tableau
Weeks 16 – 17
6
Machine Learning
Weeks 18 – 22
7
Generative AI
Weeks 23 – 25
Learning Track (Phases 1–5) Learning & Internship Track (Phases 6–7)
Learning Track

Phases 1 – 5 · The Complete 17-Week Learning Track

17 weeks (~120 days) · Python → Power BI → Excel → SQL → Tableau

1
Phase 1 · Weeks 1 – 8

Python for Data Analysis

  • Python fundamentals & data structures
  • NumPy & Pandas for data wrangling
  • Data cleaning & transformation pipelines
  • Exploratory Data Analysis (EDA)
  • Matplotlib & Seaborn visualization
  • Statistics for analysts
  • Automating reports with Python
Hands-on Projects

Python Analytics Projects

  • 1Retail Sales Performance Analysis & Automated Reporting
  • 2Customer Segmentation from Transaction History
  • 3Web-Scraped Price Intelligence Dashboard Feed
  • 4Financial Expense Analyzer with Anomaly Flags
  • 5HR Attrition Exploratory Analysis & Insights Deck
2
Phase 2 · Weeks 9 – 11

Power BI

  • Power BI Desktop & data modeling
  • Power Query transformations
  • DAX measures & calculated columns
  • Interactive visuals, slicers & bookmarks
  • Row-level security & publishing
Hands-on Projects

Power BI Dashboard Projects

  • 1Executive Sales & Profitability Dashboard
  • 2Supply Chain Inventory Health Monitor
  • 3Marketing Campaign ROI Tracker
  • 4Banking Customer 360 Report
  • 5Operations KPI Command Centre
Industry Bridge · Starts after Phase 2

Enter The Skill Union — build like a real engineer.

Once you've cleared ML fundamentals, you're plugged into industry-grade projects at The Skill Union — Vihara Tech's in-house product studio. Real teams, real tickets, real GitHub commits.

Visit The Skill Union
Industry projects
Portfolio building
GitHub development
Team collaboration
Real workflows
Hands-on labs
3
Phase 3 · Week 12

Excel for Business Analytics

  • Advanced formulas, LOOKUP / INDEX-MATCH
  • PivotTables & PivotCharts
  • Conditional formatting & data validation
  • What-if analysis & Solver
  • Dashboarding in Excel
Hands-on Projects

Excel Business Projects

  • 1Automated Monthly MIS Reporting Workbook
  • 2Budget vs Actual Variance Dashboard
  • 3Sales Commission & Incentive Calculator
  • 4Inventory Reorder Planning Model
  • 5Interactive Excel KPI Dashboard
4
Phase 4 · Weeks 13 – 15

SQL & Databases

  • SELECT, filtering, sorting, aggregation
  • JOINs, GROUP BY / HAVING, subqueries
  • Window functions & CTEs
  • Views, indexes & query optimisation
  • Transactions, constraints & DML
Hands-on Projects

SQL Data Projects

  • 1E-Commerce Order Analytics Warehouse Queries
  • 2Cohort & Retention Analysis in Pure SQL
  • 3Funnel Analysis for a Subscription Product
  • 4Data Quality Audit Query Suite
  • 5Reporting Layer with Views & Window Functions
5
Phase 5 · Weeks 16 – 17

Tableau

  • Sheets, dashboards & stories
  • Calculated fields, parameters & sets
  • LOD expressions
  • Advanced chart types & maps
  • Publishing to Tableau Public / Server
Hands-on Projects

Tableau Storytelling Projects

  • 1Nationwide Sales Geo-Analytics Story
  • 2Healthcare Utilisation Dashboard
  • 3Airline On-Time Performance Explorer
  • 4Retail Basket & Category Insights Board
  • 5Executive Storyboard with LOD Metrics
Learning & Internship Track

Phases 6 – 7 · Remaining Modules + Paid Internship

8 weeks · Machine Learning (5 weeks) + Generative AI (3 weeks) — learned alongside your paid internship

6
Phase 6 · Weeks 18 – 22
Machine Learning — 5 Weeks
Predictive analytics while on a paid internship
  • Regression & classification
  • Clustering & feature engineering
  • Model evaluation & tuning
  • Ensemble models — Random Forest, XGBoost
  • Deploying models for business users
7
Phase 7 · Weeks 23 – 25
Generative AI — 3 Weeks
GenAI for analysts while on a paid internship
  • LLM fundamentals & prompt engineering
  • RAG with vector databases
  • AI copilots for reporting & insights
  • Automating analysis workflows with agents
PAID Internship · Stipend-Based · The Skill Union

Get paid to work on real client projects — before you're even placed.

For all 8 weeks of this track you're on a live team — 6 hours a day, PAID internship, shipping code that goes to production, while you finish your remaining modules. It's the difference between "0 years experience" and "already worked on a live product" on your resume.

Industry Internship
Live team, live product
Real Client Projects
Tickets, sprints, PRs
Team Collaboration
Daily standups & reviews
Daily Task Assignments
Tracked & measurable
Mentor Reviews
1:1 code feedback
Performance Evaluation
Formal appraisals
Portfolio Building
Shippable case studies
Interview Readiness
Story-driven answers
Placement Support
8+ interviews / month

Want to see the Placement Preparation?

View Placement Preparation
View Upcoming Batches

Ready to join the next cohort?

See all upcoming batches, schedules, and start dates — pick the one that fits you best.

View Upcoming Batches
Your Journey Starts Here

Ready to Start Your 180-Day Journey?

Join the next batch. Seats are limited so we can keep the placement drive ratios in your favor.

Enroll Now Go Back to Course