**🎓 College Analytics Dashboard — Power BI Project **🔍 Project Overview
This Power BI project delivers a comprehensive analytical view of higher-education institutions using the College dataset. The report is designed to help stakeholders understand institutional performance, student demand, selectivity, spending patterns, and key factors influencing college applications.
The objective of this dashboard is to transform raw academic and financial data into clear, decision-ready insights using structured analysis and visual storytelling.
This project is ideal for:
Data analytics & BI portfolios
Education domain analysis
Demonstrating Power BI modeling and insight generation
Decision-support dashboards
🧩 Dataset Description
The College dataset contains institutional-level information, including:
Applications, admissions, and enrollments
Faculty metrics
Student demographics
Tuition and institutional spending
Selectivity indicators
Rankings and outcome variables
The dataset enables both descriptive analysis and AI-driven insight discovery.
📄 Report Pages 1️⃣ Executive Summary
Provides a high-level overview of the entire dataset:
Total colleges analyzed
Key performance indicators
Top-level trends and comparisons
Snapshot of admissions, costs, and rankings
👉 Designed for quick decision-making and executive consumption.
2️⃣ Admissions
Focuses on student demand and intake metrics:
Applications vs admissions
Enrollment trends
Acceptance rates
Demand comparison across institutions
👉 Helps assess institutional popularity and intake efficiency.
3️⃣ Leaderboard
Ranks colleges based on key metrics such as:
Applications
Enrollment
Spending
Selectivity indicators
👉 Enables quick identification of top-performing and standout institutions.
4️⃣ Selectivity & Faculty
Analyzes academic competitiveness and teaching strength:
Admission selectivity metrics
Student-faculty ratios
Faculty composition and quality indicators
👉 Highlights the relationship between selectivity and academic resources.
5️⃣ Costs & Spending
Explores financial aspects of institutions:
Tuition and fees
Instructional and student spending
Cost comparisons across colleges
👉 Helps evaluate affordability and investment in education quality.
6️⃣ Student Body
Examines student population characteristics:
Enrollment size
Demographic composition
Distribution patterns across institutions
👉 Provides insights into diversity and scale of student communities.
7️⃣ Ranking
Analyzes institutional ranking patterns:
Ranking distribution
Comparison of top vs lower-ranked colleges
Relationship between ranking and other metrics
👉 Supports benchmarking and performance evaluation.
8️⃣ Key Influencers for Applications (AI)
Uses Power BI’s AI Key Influencers visual to identify:
Factors that most strongly drive application numbers
Relative importance of costs, selectivity, faculty, and rankings
Data-driven explanations for application trends
👉 Delivers automated, explainable insights beyond manual analysis.
✨ Key Features
✅ Executive-friendly dashboard design ✅ Interactive filters and slicers ✅ Clear ranking and comparison views ✅ AI-powered influencer analysis ✅ End-to-end analytical storytelling
🛠 Tools & Technologies
Power BI Desktop
Data modeling & DAX measures
AI visuals (Key Influencers)
Data cleaning & transformation
🎯 Learning Outcomes
Through this project, I:
Applied EDA concepts in Power BI
Designed multi-page BI dashboards
Used AI visuals for insight discovery
Strengthened data modeling and visualization skills
Practiced education-domain analytics
📌 How to Use the Report
Open the .pbix file in Power BI Desktop
Navigate through report pages
Use slicers and filters for deeper analysis
Interact with visuals for comparisons and insights
👤 Author
Shorya Bisht Data Science | Analytics | AI Enthusiast
Building data-driven projects that turn complex datasets into clear insights. https://www.linkedin.com/in/shorya-bisht-a20144349/