BTech / BCA Track14 Weeks CohortTopic-Linked Attendance Enabled
Data Analytics Combo (Python + SQL + Excel + Power BI)
The flagship, comprehensive all-in-one data career program. Master Python data science, advanced SQL querying, Excel financial modeling, Power BI business intelligence, and foundational predictive machine learning.
Key Skills You Will Master:
Python Data ScienceAdvanced SQLPower BI DashboardsExcel ModelingMachine Learning BasicsETL
Lead Instructor
Vikramaditya Iyer
Ex-Tech Lead & STEM Mentor (IIT Madras Alum)
Total Program Fee (Full Cohort + Materials)
₹6,999₹9,999Save 30%
Choose Your CohortLive Interactive
Next cohort starting next weekend • 5:00 PM IST
14 Live Hybrid Interactive Sessions
14 Granular Tracked Topics
Downloadable datasets, cheatsheets & Jupyter notebooks
Verifiable Certificate upon 85%+ topic completion
Syllabus Breakdown
Course Structure & Tracked Topics
Click on any module to view live sessions and the exact list of topics tested & tracked for attendance.
Session 1
Session 1: Analytics Thinking & Setup
90 mins
Attendance-Tracked Topics (1):
1Data Analytics Lifecycle & Environment Setup
Session 2
Session 2: Excel for Fast Exploratory Analysis
90 mins
Attendance-Tracked Topics (1):
1XLOOKUP, SUMIFS, Pivot Tables & Slicers
Session 3
Session 3: Python & NumPy Refresher
90 mins
Attendance-Tracked Topics (1):
1Python Syntax & NumPy Vectorized Computations
Session 4
Session 4: Pandas DataFrames & Data Cleaning
90 mins
Attendance-Tracked Topics (1):
1Loading CSV/Excel, Filtering & Missing Data Handling
Session 5
Session 5: EDA & Matplotlib / Seaborn
90 mins
Attendance-Tracked Topics (1):
1Groupby, Histograms, Scatter Plots & Heatmaps
Beginner Milestone: Multi-Source Customer Spending Audit
Consolidate raw Excel/CSV data using Pandas, clean anomalies, and present a visual EDA report.
Deliverable: Jupyter Notebook with EDA and visualizations.
Session 6
Session 6: SQL Querying for Analysts
90 mins
Attendance-Tracked Topics (1):
1SELECT, WHERE, GROUP BY, Aggregates
Session 7
Session 7: Multi-Table Joins & Schema Traversal
90 mins
Attendance-Tracked Topics (1):
1INNER/LEFT Joins across Transactions & Catalogs
Session 8
Session 8: SQL Window Functions (RANK / LAG)
90 mins
Attendance-Tracked Topics (1):
1ROW_NUMBER, DENSE_RANK, LAG, Moving Averages
Session 9
Session 9: Power BI ETL & Data Modeling
90 mins
Attendance-Tracked Topics (1):
1Power Query Transformations & Star Schema Links
Session 10
Session 10: DAX Measures & Time Intelligence
90 mins
Attendance-Tracked Topics (1):
1CALCULATE, YoY Growth, Slicers & Interactive UX
Intermediate Milestone: Full-Stack Retail Sales & BI Dashboard
Extract metrics from SQL into Power BI, design custom DAX KPI cards, and produce a 3-page dashboard.
Deliverable: Power BI Dashboard + SQL Extraction Script.
Session 11
Session 11: Machine Learning Overview for Analysts
90 mins
Attendance-Tracked Topics (1):
1Supervised vs Unsupervised ML & Scikit-Learn Basics
Session 12
Session 12: Predictive Regression Modeling
90 mins
Attendance-Tracked Topics (1):
1Linear Regression & Revenue Forecasting in Python
Session 13
Session 13: Customer Churn Classification & K-Means
90 mins
Attendance-Tracked Topics (1):
1Decision Trees, Logistic Regression & K-Means Clustering
Session 14
Session 14: End-to-End Capstone Defense
90 mins
Attendance-Tracked Topics (1):
1Portfolio Presentation & Stakeholder Recommendations
Graduation Capstone
End-to-End Enterprise Analytics & Churn Prediction Solution
Ingest 100,000+ customer records from SQL into Python, conduct EDA, train a Scikit-Learn churn prediction model, and build a live executive Power BI dashboard.
Deliverable:
Python Notebook + SQL Pipeline + Power BI Live Dashboard
What You Will Be Able To Do
Master the complete end-to-end modern data stack (Python, SQL, Excel, Power BI)
Automate extraction from SQL databases into clean Pandas DataFrames
Create executive BI dashboards with advanced DAX and time intelligence
Train Scikit-Learn machine learning models to forecast churn and revenue trends
Prerequisites
No prior coding experience required. Fast-paced comprehensive track.
Unsure if this fits your current grade?
Schedule a 10-minute discovery call with our academic advisor.