12 weeks · Beginner Friendly
Data Analytics
Turn raw datasets into executive dashboards, business KPIs, and strategic decisions.
Course Overview
A 12-week intensive track designed for students and working professionals aiming for high-impact analyst roles. Master SQL queries, advanced Excel, PowerBI, Tableau, and exploratory Python data analysis while solving real business case studies.
ModeBangalore Lab & Live Online
BatchesWeekend & Evening
CertificateVerified on Capstone
Curriculum & Modules
4 Detailed Modules1Advanced SQL & Database Analytics
- Complex joins, subqueries & CTEs
- Window functions & partitioning
- Database aggregation & data modeling
- Query performance tuning
2Advanced Excel & Data Wrangling
- VLOOKUP/XLOOKUP, INDEX/MATCH
- Pivot tables & dynamic arrays
- Power Query ETL workflows
- Financial & sales modeling
3Business Intelligence in PowerBI & Tableau
- DAX calculations & calculated columns
- Interactive executive dashboards
- Drill-through reports & KPI scorecards
- Publishing to cloud services
4Python for EDA & Analytics Capstone
- Pandas & NumPy data manipulation
- Data visualization with Seaborn & Plotly
- A/B testing & cohort retention
- End-to-End Business Analytics Capstone
Portfolio Projects You Will Build
Project 1
E-Commerce Customer Retention & Churn Analysis
GitHub Repository & Live Deployment Ready
Project 2
Executive Sales & Operations KPI Dashboard
GitHub Repository & Live Deployment Ready
Project 3
Financial Risk & Loan Default Assessment
GitHub Repository & Live Deployment Ready
Project 4
End-to-End Business Intelligence Capstone
GitHub Repository & Live Deployment Ready
Tools & Tech Stack
SQLPostgreSQLPowerBITableauExcel (Advanced)PythonPandasPlotlyJupyter
Target Job Roles
- Data Analyst
- Business Intelligence (BI) Analyst
- Operations & Growth Analyst
- Product Analyst
Free Batch Demo
Have questions on this course?
Connect with our academic team in Bangalore to review the curriculum and reserve your seat.
Book Free Counselling