kaif2011/Egypt-Dashboard

Power BI dashboard analyzing student academic performance across education systems & demographics. # Egypt-Student-Dashboard An interactive Power BI dashboard analyzing student academic performance across education systems, subjects, and family education background in Egypt. ## 📌 Project Overview This project was developed to analyze student academic performance across different education types, subjects, age groups, and family backgrounds. The primary objective was to move beyond simple pass/fail tracking and understand how factors like parental education level, student age, and academic year relate to overall performance. Using a dataset of 476K students, I built this dashboard to evaluate a 99.02% pass rate across the student body and identify subject-wise and demographic-wise performance patterns. The project highlights key metrics like Average Marks (74.58) and Fail Count (5K) to help educational stakeholders make data-backed decisions on curriculum support and student intervention. ## 📂 Data Source This project utilizes a student performance dataset featuring 476K student records, including education type, subject-wise marks, student age, student year, and both father's and mother's education degree. The data enables deep-dive analysis into academic performance trends across demographic and family-background dimensions. ## 🛠 Tech Stack The dashboard was built using the following tools and technologies: - 📊 Power BI Desktop – Used for building the interactive academic performance dashboard. - 🔄 Power Query (ETL) – Performed data cleaning and transformation, including subject-wise and demographic data formatting. - 🧠 DAX (Data Analysis Expressions) – Developed custom measures for Average Marks, Pass Percentage, Pass Count, and Fail Count. - 🔗 Data Modeling – Established relationships between Students, Subjects, and Demographics tables for efficient filtering and analysis. - 📁 File Format – .pbix (project development) and .png (dashboard preview). ## 🚀 Features - Business Problem - Goal of the Dashboard - Walkthrough of Key Visuals - Business Impact …