.png){kind=link}
This project focuses on analyzing student performance data using Power BI. The dashboard provides actionable insights into students’ academic performance across subjects, and highlights the impact of factors such as gender, ethnicity, parental education, and test preparation.
By visualizing key performance indicators (KPIs), this project helps educators and decision-makers identify trends, gaps, and opportunities for improvement in student learning outcomes.
-
To evaluate student performance across Math, Reading, and Writing.
-
To analyze the influence of demographics (gender, ethnicity) on academic results.
-
To assess the effect of parental education levels and test preparation courses.
-
To provide data-driven insights for improving teaching strategies and student success.
PowerBi
- Name: Students Performance Dataset
- Source: (e.g., Kaggle: Students Performance in Exams dataset, or your own)
- Rows: 100 students
- Columns/Features: -Gender (Male/Female) -Ethnicity (Group A, B, C, D, E) -Parental level of education (High school, Associate’s, Bachelor’s, Master’s, etc.) -Test preparation course (Completed/None) -Math score -Reading score -Writing score
Total number of students
Average Math score
Average Reading score
Average Writing score
Sum of score percentages
Bar Chart – Average Score by Ethnicity
Pie Chart – Average Score by Gender
Bar Chart – Average Score by Parental Education
Donut Chart – Average Score by Test Preparation
Line Chart – Score by Ethnicity & Parental Education
Bar Chart – Average Scores by Student ID
- Students who completed test preparation scored higher than those who didn’t.
- Parental education level positively influences student performance.
- Gender differences in scores are minimal.
- Ethnic group variations exist but are less significant compared to preparation and education level.
Shrawani M. Amrutkar