Conference PaperPDF Available

Management Information Dashboard – Visualizing Data through PowerBI

Authors:

Abstract

This session is facilitated by Dr Ishan Abeywardena, Associate Director – Systems, Jason Greatrex, Support Team Manager and Kanchan Dhiman, Information Systems Analyst at the Centre for Extended Learning, University of Waterloo, from Canada. Participants can expect to hear about: - How 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, how 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 institutional data lake, periodically and in real-time to generate tailored visualizations using the Microsoft PowerBI platform. - The five main dashboards of the CEL-MID which are available to Senior Management, Management, Staff, Professional Development and Public with access control managed through Groper. - Live demo of dashboards consisting of multiple tabs hosting various tailored reports such as student enrolment, student demographics, courses and programs on offer, project progress (systems, course development and externally funded) among others. - You should participate in this session if you are looking at better visualizing campus data to generate management information leading to improved budgeting, accurate forecasting, better market analysis and measuring student satisfaction.
Please ensure your camera and microphones are switched off.
Have fun, be respectful and where possible, connect with others!
Lean in Higher Education (Lean HE) is a
community of practice who:
Are committed to the continuous
improvement of higher education, its
people and those we serve;
Network, connect and share best practice
with our local and global community;
Are led by voluntary committees who make
the most of the skills of our peers and
available technology to operate without a
budget of our own.
We're always interested in broadening our
community, hearing new voices and
sharing our learning with other universities
and colleges.
CENTRE FOR EXTENDED
LEARNING
Supporting the design, development, and delivery
of fully-online credit and non-credit courses.
Professional development (non-credit)
opportunities
Advocacy for adult and distant learners
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI 4
© CEL http://cel.uwaterloo.ca/honeycomb
We create interactions that are
useful, desirable, accessible, credible, and intuitive.
The CEL Systems team
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 5
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
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 6
Continuous Improvement
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 7
Continuous Improvement
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 8
Whats MS Power BI?
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 9
Business analytics solution used to
visualizedata
Interactive reports and visualizations
Consolidate multiple data sources
Tailored dashboard visualizations
Secure report publishing
CEL-MID Demo
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 10
CEL-Management Information Dashboard
Student Enrollments
By Learner
Exam location
Campus Departmental Collaboration
Non-STEM – Resource Management
Our Processes
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 11
LHE 2020: Management Information Dashboard -Visualizing Data through PowerBI PAGE 12
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.
Ishan: ishan.abeywardena@uwaterloo.ca
Jason: jgreatrex@uwaterloo.ca
Kanchan: k2dhiman@uwaterloo.ca
ResearchGate has not been able to resolve any citations for this publication.
ResearchGate has not been able to resolve any references for this publication.