EdTech Platform Analytics Dashboard

Overview

End-to-end data analysis project for an EdTech platform covering 40,000 students, 600 courses, and $9M+ revenue using Excel and Power BI.

Details

Analyzed a comprehensive EdTech platform dataset containing 6 interconnected tables with 620,000+ rows. Built a complete data pipeline from raw data cleaning in Power Query to an interactive 5-page Power BI dashboard.

Challenge

Raw data had country/city mismatches, inconsistent category naming across tables, and no direct link between payments and courses requiring creative data modeling solutions.

Solution

Performed data cleaning in Power Query, built a star schema data model with 6 tables, created 15+ DAX measures, and designed 5 interactive dashboard pages covering Overview, Students, Courses, Revenue, and Instructors analysis.

Results

Delivered 28 business insights across 4 levels. Identified 9.9% refund rate ($1M loss), 20% dropout rate, and flat growth trend — enabling data-driven decisions for the platform.