A SQL + Power BI project to compare top Data Science programs offered by India's most prestigious institutes — IITs, NITs, IIITs, and more — based on: 📊 Fees • 💼 Placement Rates • 🏫 Institute Type • 🎓 Eligibility • 🧠 Popularity • ⏳ Duration • 💻 Mode
India's Data Science education space is booming — with every IIT, NIT, and IIIT launching online and hybrid programs. But which one offers the best ROI?
👉 This project answers that question by visualizing, analyzing, and comparing the programs across multiple dimensions — to help learners make smarter choices.
| Tool | Usage |
|---|---|
| MySQL | Data modeling, insertion, SQL analysis queries |
| Power BI | Visual dashboard design |
| Power Query | Data transformation (cleaning fees, placement, eligibility) |
| DAX | Aggregates and calculated columns |
| GitHub | Project versioning & hosting |
| File | Description |
|---|---|
DS_comparison.sql |
SQL schema, inserts & 20+ analytical queries |
SQL_DS.csv |
Cleaned course dataset for Power BI |
Visualizing India's Data Science Pathways.pbit |
Power BI template (interactive dashboard) |
Visualizing India's Data Science Pathways.png |
Dashboard screenshot for preview |
🧠 Built in Power BI using real Indian education data.
✅ Compare 11+ real programs across:
- 🎓 Institute Type: IIT, NIT, IIIT, or Other
- 💵 Fees (in Lakh ₹) and placement %
- 🎓 Eligibility: JEE, working professionals, online qualifier
- 📍 Delivery Mode: Online, Hybrid, Campus
- 📈 Popularity: High / Moderate / Emerging
- 📊 Course Duration: Short (6–9 months) to long (UG/PG)
- ✅ KPI Cards (Avg Fees, Placement, Max Intake)
- ✅ Matrix Heatmap: Placement by Mode & Institute
- ✅ Donut Chart: Mode Distribution
- ✅ Histogram: Fees Distribution
- ✅ Boxplot: Placement Spread by Institute Type
- ✅ Word Cloud: Course Themes
- ✅ IIT Madras offers flexible entry (No JEE!) with 65%+ placement
- ✅ NITs are emerging with strong hybrid options
- ✅ High-placement courses are not always the most expensive
- ✅ Word “Analytics” & “AI” dominate in course names
- Clone or download the repo
- Import DS_comparison.sql into MySQL Workbench
- Load SQL_DS.csv into Power BI
- Or directly open the .pbit Power BI dashboard file
- 🔄 Add more private universities (e.g., ISB, Amity, UpGrad)
- 🤖 Use web scraping to automate data collection
- 🌐 Deploy to Power BI Web (Public)
Banani Mallick
Connect on LinkedIn
✨ Built as part of my portfolio to showcase real-world education analytics using SQL + BI