This project analyzes a dataset of 1,000 students to explore how demographic, socioeconomic, and academic factors influence overall performance.
Using Microsoft Excel, the project includes PivotTables, PivotCharts, calculated fields, slicers, and a fully interactive dashboard.
- Analyze factors influencing student academic performance
- Compare Math, Reading, and Writing score patterns
- Evaluate the impact of parental education & test preparation
- Build an interactive Excel dashboard for dynamic insights
The dataset includes:
- Gender
- Race/Ethnicity
- Parental Level of Education
- Lunch Type
- Test Preparation Course
- Math, Reading, and Writing Scores
Additional calculated fields were created to categorize student performance levels.
- Cleaned and organized the dataset
- Added calculated columns
- Built PivotTables for analysis
- Created bar, column, and pie PivotCharts
- Designed a unified dashboard with slicers
- Ensured consistent formatting for a professional layout
Students who completed the test preparation course scored significantly higher.
Higher parental education correlates with higher average student scores.
- Females scored higher in Reading & Writing
- Males scored slightly higher in Math
Group E showed the highest overall performance.
Reading scores were highest on average, followed by Writing, then Math.
Challenge 1: Categorizing performance groups
✔ Solution: Created calculated fields using thresholds
Challenge 2: Linking slicers to all charts
✔ Solution: Used Report Connections to synchronize all PivotTables
| File | Description |
|---|---|
| Project Report (PDF) | Full project documentation |
| StudentsPerformance.xlsx | Dataset, PivotTables, charts, and dashboard |
| Dashboard Screenshot (PNG) | Final dashboard image |
Praveen Ilango
Aspiring Data Analyst
Tools Used: Excel, PivotTables, PivotCharts, Slicers
[view Full Project on Notion] (https://www.notion.so/Student-Performance-Analytics-Dashboard-2c64b61bbb658017bc3bf28764379875)