Solutions · Automation · Learning Technology
Learning & Course Operations Dashboard
Combined learning analytics, course requests and course creation into a single Power BI dashboard for clearer operational reporting.
- Organisation
- University of Notre Dame Australia
- My role
- Data workflow architecture and automation
- Technology
- Blackboard · Excel · Office Scripts · Power Automate · SharePoint · Power BI
The challenge
Learning analytics, course requests and course creation data sat across separate processes, making it difficult to see training progress and course delivery activity together.
Existing environment
Blackboard grade exports, course request and creation records, spreadsheets, staff group mappings and Microsoft 365 reporting tools.
Requirements
- Bring learning and course operations into one reporting view
- Process source data consistently
- Track course requests and course creation
- Calculate FP1 and FP2 completion
- Create a governed source of truth
- Support completion and Working Towards reporting
Solution architecture
Design decisions
Office Scripts handled deterministic spreadsheet cleaning close to the source format.
Power Automate orchestrated the scheduled hand-offs rather than embedding all logic in one workbook.
SharePoint became the reporting source of truth so dashboards did not depend on transient files.
Completion rules were made explicit before dashboard design began.
Experience design
The dashboard gives stakeholders one place to understand learning completion, course demand and course creation progress instead of reconciling separate reports.
Implementation
Source records are cleaned and transformed with Office Scripts, orchestrated by Power Automate, written to SharePoint and brought together through Power BI measures and reporting views.
Outcome
A connected reporting experience replaced fragmented operational views and brought learning analytics, course requests and course creation into one dashboard.
What I learned
Reporting quality depends on making transformation rules visible and maintainable, not only on the final dashboard.