Student Performance Analysis with Power BI

Educational Analytics & Performance Insights

The Student Performance Analysis project analyzes academic data to derive actionable insights aimed at improving educational outcomes. The dataset includes gender, race/ethnicity, parental education, lunch type, test preparation course completion, and scores in math, reading, and writing.

Using Power BI and DAX measures, the project provides detailed visualizations and insights into overall performance, performance gaps, test preparation impact, gender disparities, and parental education influence.

Student Performance Dashboard

Key Insights & DAX Measures

  • Overall Performance

    DAX Measure: Overall Performance = AVERAGE('Case Study Table'[math_score] + 'Case Study Table'[reading_score] + 'Case Study Table'[writing_score])
    Description: Assesses students’ overall academic performance across all subjects.
    Visualization: Horizontal bar chart or bullet chart.

  • Performance Gap

    DAX Measure: Performance Gap = ABS(AVERAGE('Case Study Table'[math_score]) - AVERAGE('Case Study Table'[reading_score]))
    Description: Identifies the gap between different subject performances.
    Visualization: Stacked bar chart or waterfall chart.

  • Test Preparation Impact

    DAX Measure: IF(ISBLANK(AVERAGE('Case Study Table'[test_preparation_course])), "No Course", "Course Completed")
    Description: Measures the effect of completing a test preparation course.
    Visualization: Pie chart or stacked column chart.

  • Gender Performance Disparity

    DAX Measure: ABS(AVERAGE('Case Study Table'[math_score]) - AVERAGE('Case Study Table'[reading_score]))
    Description: Evaluates differences in performance between genders.
    Visualization: Grouped bar chart or box plot.

  • Parental Education Influence

    DAX Measure: IF(AVERAGE('Case Study Table'[parental_level_of_education]) = "Bachelor's Degree", "Bachelor's Degree", IF(AVERAGE('Case Study Table'[parental_level_of_education]) = "Master's Degree", "Master's Degree", "Other"))
    Description: Determines correlation between parental education and student performance.
    Visualization: Clustered column chart or stacked bar chart.

About the Project

Dashboard Overview

Project Overview

This Power BI dashboard uses DAX measures to analyze student performance data, uncover gaps, and highlight the impact of test preparation and parental education. Stakeholders can interactively explore visualizations to understand trends, disparities, and opportunities for academic improvement.

Usage & Application

  • Import the student performance dataset into Power BI.
  • Create DAX measures to compute insights like overall performance, gaps, and test preparation impact.
  • Use suggested visualizations to effectively communicate findings.
  • Support data-driven decision-making to improve educational outcomes.
Visualizations & Analysis

When:
2025

Mode:
Power BI Analysis

Dataset:
Student Performance

Focus:
Educational Analytics & Insights

Project Snapshots

Business Impact

📊 Provides insights into student performance trends and subject-specific gaps.

💡 Highlights impact of test preparation and parental education on outcomes.

⚡ Supports educators in data-driven decision-making to improve academic performance.

Challenges & Learnings

⚡ Creating accurate DAX measures for complex performance metrics.

📊 Designing visualizations that clearly communicate insights and performance gaps.

🚀 Gained experience in educational analytics, DAX modeling, and interactive dashboard design.

← Back to Projects 🔗 View on GitHub