Campus Placement Intelligence & Performance Dashboard: An Interactive Power BI Analysis of 10,000 Students Across 100 Institutions
Campus Placement Intelligence & Performance Dashboard
1. Introduction
Campus placements play an important role in shaping students' career opportunities and evaluating institutional performance. Placement outcomes are influenced by several factors, including academic performance, cognitive abilities, communication skills, practical project experience, internship participation, and other employability-related attributes.
Understanding these factors through data analysis can help identify patterns in student placement outcomes and provide meaningful insights for educational institutions.
In this project, I developed a Campus Placement Intelligence & Performance Dashboard using Microsoft Power BI. The dashboard transforms student placement data into interactive visualizations, KPI indicators, comparative charts, and analytical reports.
The main objective is to explore placement trends across multiple institutions and understand how academic and employability-related attributes are associated with placement outcomes.
2. Project Objectives
The major objectives of this project are:
Analyze placement outcomes across multiple educational institutions.
Understand the relationship between CGPA and placement conversion.
Evaluate the influence of communication skills on placement outcomes.
Analyze the role of practical project experience.
Compare placement outcomes of students with and without internship experience.
Examine cognitive and academic performance indicators.
Compare institutional placement performance.
Provide an interactive dashboard for exploring student-level records.
3. Dataset Description
The project uses a student placement dataset containing 10,000 student records across 100 institutions.
The dataset contains the following attributes:
| Attribute | Description |
|---|---|
| College_ID | Institution identifier |
| IQ | Cognitive score |
| Prev_Sem_Result | Previous semester result |
| CGPA | Cumulative Grade Point Average |
| Academic_Performance | Academic performance score |
| Internship_Experience | Internship participation (Yes/No) |
| Extra_Curricular_Score | Extra-curricular activity score |
| Communication_Skills | Communication skill score |
| Projects_Completed | Number of completed projects |
| Placement | Placement outcome (Yes/No) |
These attributes provide different dimensions for exploring student performance and placement trends.
4. Tools and Technologies Used
Microsoft Power BI Desktop
Used to develop interactive dashboards, KPI cards, charts, tables, filters, and report navigation.
CSV Dataset
Used as the primary data source for student placement analysis.
Power Query
Used as the data preparation and transformation environment where required.
DAX (Data Analysis Expressions)
Used for creating analytical measures and calculated indicators in Power BI.
5. Dashboard Overview
The dashboard is divided into five major analytical pages. Each page focuses on a different aspect of student placement intelligence.
5.1 Executive Overview
The Executive Overview provides a consolidated summary of the entire student cohort.
It includes:
Total student population.
Number of placed students.
Overall placement rate.
Average cohort CGPA.
Placement readiness indicators.
At-risk student classification.
Placement rate by CGPA bracket.
Placement rate by communication skill tier.
Placement rate by practical project experience.
Institutional performance summary.
This page helps users understand the overall placement situation before exploring detailed analytical dimensions.
5.2 Academic Intelligence
The Academic Intelligence page focuses on academic and cognitive attributes.
The visualizations include:
Overall Average CGPA.
Average CGPA of placed students.
Average CGPA of unplaced students.
CGPA placement premium.
Average cohort IQ.
Honours cohort distribution.
Placement rate across cognitive IQ tiers.
Previous semester GPA consistency across CGPA brackets.
Academic performance rating versus placement rate.
Academic cohort performance summary.
The analysis shows a strong association between higher CGPA brackets and placement conversion in this dataset.
Students in the CGPA brackets of 8.0–8.99 and 9.0+ demonstrate substantially higher placement rates than students in the lower CGPA brackets.
5.3 Skills & Employability
This page explores the relationship between employability-related skills and placement outcomes.
The dashboard includes:
Average communication score.
Proficient communicator count.
Average projects completed.
Experienced project builders.
Internship participants.
Internship placement comparison.
Communication score versus placement conversion.
Placed student volume by practical project experience.
Extra-curricular engagement score versus placement rate.
An important observation is that students with communication scores of 8–10 have a considerably higher placement rate than students in the lower communication tiers.
The project experience analysis also highlights higher placement rates among students who have completed two or more projects.
The internship comparison, however, shows relatively similar placement rates for students with and without internship experience.
5.4 Institutional Benchmarks
The Institutional Benchmarks page compares placement performance across the 100 institutions.
It contains:
Total institutions.
Institutions meeting the placement target.
Percentage of colleges meeting the 20% target.
Highest institutional placement rate.
Lowest institutional placement rate.
Institutional placement rate comparison.
Institutional academic benchmark performance.
Master College Placement Intelligence & Quality Audit Table.
This page provides a comparative view of institutional performance using placement rate, student population, average CGPA, IQ, communication scores, and completed projects.
5.5 Candidate Explorer
The Candidate Explorer provides a detailed view of student-level records.
It includes interactive filters for:
College ID.
Placement readiness segment.
CGPA bracket.
Communication skill tier.
Projects completed.
Placement status.
The page also provides a comprehensive student cohort table containing academic, cognitive, skill-related, internship, and placement attributes.
This enables users to filter specific student groups and explore their characteristics.
6. Key Performance Indicators
The dashboard provides important performance indicators for understanding the overall student cohort.
| KPI | Value |
|---|---|
| Total Students | 10,000 |
| Placed Students | 1,659 |
| Unplaced Students | 8,341 |
| Overall Placement Rate | 16.6% |
| Average CGPA | 7.53 |
| Average IQ | 99.5 |
| Average Communication Score | 5.56 |
| Average Projects Completed | 2.51 |
| Internship Participants | 3,964 |
| Total Institutions | 100 |
The overall placement rate is approximately 16.6%, compared with the 20% target displayed in the dashboard.
7. Important Analytical Findings
The analysis of the dataset provides several interesting observations.
Academic Performance: Students with CGPA of 8.0 and above demonstrate considerably higher placement conversion than students in the lower CGPA brackets.
Communication Skills: Students in the proficient communication tier show a placement rate of approximately 39.3%.
Project Experience: Students completing two or more practical projects demonstrate substantially higher placement rates than students with zero or one project.
Internship Experience: Students with internship experience have a placement rate of approximately 16.3%, compared with 16.8% for students without internship experience.
Institutional Performance: Out of 100 institutions, 18 meet or exceed the 20% placement target.
These findings represent associations observed in the dataset and do not establish that any individual factor directly causes placement success.
8. Interactive Dashboard Features
The dashboard provides multiple interactive features to improve data exploration.
Institution-based filtering.
CGPA bracket selection.
Internship experience filtering.
Communication skill filtering.
Project experience filtering.
Placement status selection.
Student-level record exploration.
Multiple report pages for different analytical perspectives.
These features allow users to explore different subsets of the dataset without manually modifying the original records.
9. Conclusion
The Campus Placement Intelligence & Performance Dashboard demonstrates how data visualization can transform student placement records into meaningful analytical insights.
By combining academic performance, cognitive indicators, communication skills, project experience, internship participation, and institutional benchmarks, the dashboard provides a consolidated perspective on placement trends.
Developing this project helped me understand the importance of data preparation, analytical measures, interactive visualizations, dashboard design, and data storytelling using Microsoft Power BI.
It also provided practical experience in converting a large dataset into an organized and interactive analytical solution.
10. Project Links
Blog Documentation: This article presents the project overview and dashboard analysis.
Dashboard Tool: Microsoft Power BI
Dataset: Student Placement Dataset (CSV)
This project was developed as part of my Data Visualization – Assignment 2.
Comments
Post a Comment