Business Intelligence · 2025
Online Courses Analysis Dashboard
Star-schema modelling, DAX KPIs and three interactive pages of data storytelling.
3
Report pages
Star schema
Model
DAX KPIs
Measures
Pricing & growth
Focus
The problem
Education platforms need to know which subjects sell, how pricing changes behaviour, and where growth is coming from — raw course exports answer none of that.
The solution
An end-to-end BI solution: data cleaned in Power Query, modelled as a star schema, measured with DAX, and presented as a decision-support dashboard for stakeholders.
Overview page
- Total courses, lectures, subscribers and reviews as KPI cards
- Subscriber distribution by subject
- Yearly course growth trend and top courses by subscribers
Price analysis page
- Average price by subject and price-category distribution
- Price versus content duration analysis
- Free versus paid comparison with engagement and review quality
Details page
- Course-level performance metrics with drill-down
- Subject and level filtering with dynamic slicing
- Comparative analysis for identifying improvement opportunities
Results & impact
- ✓Web Development dominates subscriber count — the strongest, most consistent demand
- ✓Free courses attract volume, paid courses drive engagement and better reviews
- ✓Pricing clearly shapes perceived value and subscriber behaviour
More projects
Machine Learning · Big Data
Healthcare Fraud Detection System
End-to-end AI platform that flags fraudulent insurance claims in real time.
Computer Vision · Edge AI
DriveGuard AI — Driver Monitoring System
Offline edge-AI that detects drowsiness, distraction and phone use in real time.
Data Mining · NLP
Food Delivery Pattern Analysis
Data mining on ordering behaviour plus a BERT-based recommendation engine.