24-SESSION DATA ANALYTICS BOOTCAMP - COMPREHENSIVE

CURRICULUM

🎯 Program Overview

Duration: 24 Live Sessions × 3 Hours = 72 Hours
Structure: 2 Sessions/Week × 12 Weeks
Format: Live Cohort (25-30 people)
Investment: ₹55,000
Expected Outcome: Job-ready Analytics Engineer + Production Portfolio
Salary Range: ₹8-15 LPA

📚 PART 1: ANALYTICS FOUNDATION (Sessions 1-6 | 18 Hours | Weeks 1-3)

What You'll Build:

10 optimized SQL queries with EXPLAIN analysis
5 complex multi-table JOINs
Window function library
Complete e-commerce data model with ERDs
Python ETL scripts
Executive Power BI dashboard

PART 2: BIG DATA ARCHITECTURE (Sessions 7-12 | 18 Hours | Weeks 4-6)

What You'll Build:

Distributed architecture designs
Hadoop infrastructure (500GB daily ingestion)
1M-row Spark analytics
Complex PySpark transformations
10x performance optimization case study
Production Databricks notebooks with Delta operations

🏗️ PART 3: DATA PIPELINES & ENGINEERING (Sessions 13-18 | 18 Hours | Weeks 7-9)

What You'll Build:

Complete medallion architecture
ETL/ELT pipeline design
8-task automated Databricks Workflow with error handling
Data quality framework (20+ checks)
Real-time Kafka → Spark streaming system
Automated alert system

🤖 PART 4: AI AUTOMATION & CAREER (Sessions 19-24 | 18 Hours | Weeks 10-12)

What You'll Build:

50+ SQL queries using ChatGPT
Automated end-to-end analytics report system
Portfolio Project 1: E-commerce analytics platform
Portfolio Project 2: Real-time streaming analytics system
Portfolio Project 3: Enterprise data architecture
Complete job-ready package (resume, portfolio, mock interviews)

📊 Skills Breakdown by Domain

Analytics Foundation

✓ Complex SQL (JOINs, window functions, subqueries)
✓ Python (Pandas, data cleaning, ETL)
✓ Power BI dashboarding & DAX
✓ Data modeling (star schemas, dimensional modeling)

Big Data Architecture

✓ Distributed computing fundamentals
✓ Hadoop ecosystem (HDFS, YARN, MapReduce)
✓ Apache Spark architecture & optimization
✓ PySpark production code
✓ Databricks platform expertise
✓ Delta Lake (ACID, time travel, optimization)

Data Engineering

✓ Medallion architecture (Bronze-Silver-Gold)
✓ ETL/ELT pipeline design
✓ Data orchestration (Databricks Workflows)
✓ Data quality frameworks
✓ Real-time streaming (Kafka, Spark Streaming)
✓ Pipeline reliability & monitoring

AI & Automation

✓ Prompt engineering for code generation
✓ ChatGPT/AI for analytics automation
✓ End-to-end workflow automation
✓ Anomaly detection & alerting

Career & Portfolio

✓ 3 production-ready projects on GitHub
✓ Professional resume & LinkedIn profile
✓ Interview preparation (system design, SQL, architecture)
✓ Job search strategy
✓ Salary negotiation

📈 Program Investment & ROI

ComponentValue

72 hours live instruction

₹30,000+

3 production projects

₹9,000

1-to-1 mentorship

₹6,000

Mock interviews

₹4,000

Career guidance

₹3,000

Alumni network

₹3,000

Total Value

₹55,000+

Expected ROI

Salary increase: ₹3-6 LPA
Payback period: 2-4 months
Job placement: 85% within 6 months
Career trajectory: Analytics Engineer (₹8-15 LPA)

🎓 Learning Structure (Every Session)

Each 3-hour session follows this proven pattern:

Hour 1: Concept (50 min)

Theory and visualization
Real-world examples
Big Data connections
Why this matters

Hour 2: Hands-On Lab (50 min)

Live coding
Guided exercises
Experimentation
Questions & clarifications

Hour 3: Projects + Mentorship (50 min)

Live project work
1-to-1 code review
Performance optimization
GitHub deliverable

🎯 Expected Outcomes by End

Technical Skills:

Write production-grade SQL queries with optimization
Build distributed analytics with PySpark
Design scalable data architectures
Implement reliable data pipelines
Automate complex workflows with AI

Portfolio Assets:

Project 1: E-commerce analytics platform (SQL+Spark+Databricks+BI)
Project 2: Real-time streaming analytics (Kafka+Spark+Delta)
Project 3: Enterprise data system (Governance+Quality+Scale)

Career Ready:

Optimized resume for Analytics Engineer roles
GitHub portfolio with 5+ projects
LinkedIn profile transformed
Mock interviews & feedback
Job search strategy

Expected Salary: ₹8-15 LPA (from ₹5-8 LPA before)

📝 Instructor & Program Details

Instructor: Durgesh Yadav & Pragya Rathi

7-Eleven Data Engineer
Product Analyst @Target Data Specialist
GeeksforGeeks Data Analytics Instructor, Data Engineering Instructor at Bosscoder & DA Instructor @Newton School
10000 + students trained & Multiple Got Placed in Top Product Based Companies

🚀 Quick Facts

24 Sessions | 72 Hours | 12 Weeks
2 Sessions/Week | Live Cohort | 25-30 People
3 Capstone Projects | Job-Ready Portfolio | Career Support
₹45,000 Investment | ₹10-15 LPA Outcome | 85% Placement as we make you Job Ready ( But Its not a Placement Guarantee Program)

Transform from SQL+Excel analyst to Data Analytics Engineer in 12 weeks.

Note - Recordings Available for Each Session & You will get it Processed After Every Week Live Class

Program Created: December 2025

Curriculum Version: 1.0

All session details verified and production-ready