Mainje-Oscar/Kenya-s-Education-Sector-PowerBI-Project

A Power BI project on Kenya's education system. # Kenya's Education Sector PowerBI project ## Overview Educational institutions manage large ecosystems that comprise students, teachers, academic testing and grading methods, and financial cash flow systems. Relying on flat-table data structures often causes operational difficulties, including large file sizes, data duplication, reporting inaccuracies, and slow systems. The objective of this project was to ingest a dirty, flat dataset, carry out relevant data cleaning and transformations, and develop a fairly optimized database model. By normalizing the flat table into a Snowflake schema, academic assessment entries were isolated from financial management entries. This approach helped in building an interactive Power BI ecosystem that provides relevant stakeholders with a fairly clear picture on regional school enrollment, teacher and student distribution across the counties, financial standing of the education sector, and teacher-student success rates. ## Features - Education sector executive summary - School's financial operations analysis - Academic perfomance analysis - Location based analysis - Summarised explanation of data cleaning process - Brief Model Explanation - DAX measures used in the model ## Tools Used - Power BI - Power Query