PresentationPDF Available

CEL Management Information Dashboard -Visualizing Data Through PowerBI

Authors:

Abstract

The lack of centralized, rich, accurate and real-time management information about the online learning and professional development businesses of the Centre for Extended Learning (CEL) has been a longstanding hurdle to the expansion of the unit. As a potential solution, the CEL Systems team initiated the Management Information Dashboard (CEL-MID) project in Spring 2019 to develop a centralized dashboard which feeds on multiple internal and external data sources, including the IST data lake, periodically and in real-time to generate tailored visualizations using the Microsoft PowerBI platform. The CEL-MID has five main dashboards which are Senior Management, Management, Staff, Professional Development and Public with access control managed through Grouper. Each dashboard consists of multiple tabs hosting various tailored reports such as: • Student Enrolment – overview, by career, by learner, WD/WF count • Student Demographics – citizenship status, exam location • Courses and Programs – course count, WatPD courses, X no. of courses (unique count) • Systems Projects – project progress, resource allocation • Course production projects – progress, resource allocation, time-on-task • Externally funded projects – progress • New reports added through fortnightly sprints based on the self-service intake form
CEL-Management Information Dashboard
Visualizing Data Through PowerBI
PRESENTATION TITLE PAGE 1
Led By:
Kanchan Dhiman
Jason Greatrex
Ishan Abeywardena
The CEL Systems team
PAGE 2
Mission
We provide technology focused tools,
support, and educational technology
expertise to and on behalf of CEL to
advance innovation and engineer
collaborative solutions so that
stakeholders have high quality
educational experiences in extended
learning.
The Services we provide:
developing and supporting software
tools;
learner and instructor support;
technical support for hardware and
software;
expert consultation on Educational
Technologies.
CEL - Our Technology Ecosystem
PAGE 3
CEL - Our Technology Ecosystem Zoomed
PAGE 4
Continuous Improvement
PAGE 5
Continuous Improvement
PAGE 6
What’s MS Power BI?
PAGE 7
Business analytics solution used to
visualizedata
Interactive reports and visualizations
Consolidate multiple data sources
Tailored dashboard visualizations
Secure report publishing
CEL-MID Demo
PAGE 8
CEL-Management Information Dashboard
Student Enrollments
By Learner
Exam Location
Campus Departmental Collaboration
Non-STEM – Resource Management
CEL Staff Taking Course - Demo
Our Processes
PAGE 9
PAGE 10
PAGE 11
We acknowledge and appreciate the support and
guidance provided by:
John Kemp and the IST Data, Integration and Analytics
team on the PowerBI licensing setup and integration
with the IST Data Lake;
IAP for supporting us with data requests;
Dave Bean and the RO team for helping with data
extraction from QUEST; and
Peter Wood and the Faculty of Math for working with
us on a collaborative report for external use.
ResearchGate has not been able to resolve any citations for this publication.
ResearchGate has not been able to resolve any references for this publication.