Power BI
Student insights dashboard for NOVO Education
A multi-page Power BI report built from Google Sheets covering enrolments, attendance, behaviour, retention, learning progress and child-safety incidents across two campuses.
- Client
- NOVO Education
- Industry
- Education, Australia
- Status
- Delivered
The problem
Student data lived in separate Google Sheets with no consolidated view for leadership.
What we built
- Power Query cleaning of Google Sheets sources
- Star-style model around a shared school table
- Nine linked report pages with campus slicers and refresh timestamp
Challenges we solved
- Different sheet layouts
- Week/term time alignment
- Metric definitions
Results
- Leaders see trends by campus, school, week and term in one report
Technology stack
- Power BI
- Power Query
- DAX
- Google Sheets
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Power BI