Primary speaker:
Jason Lee, Manager, Systems & Data Analytics, Office of the Registrar, UTSC
Secondary speakers:
Wyman Ma, Data Analyst, Business Intelligence, Office of the Registrar, UTSC
Yang Meng, Data Analyst, Business Intelligence, Office of the Registrar, UTSC
Vandana Muralidharan, Data Analyst, Business Intelligence, Office of the Registrar, UTSC
Description:
At the UTSC Office of the Registrar, the Business Intelligence (BI) team plays a critical role by ensuring that reliable, well-governed and up-to-date data is available to inform decisions across the campus. This presentation will highlight three pillars of our BI practices: data integrity & governance, process improvement & automation, and visualization, and how they collectively support trusted, efficient and data-driven decision making.
By using real project samples, we will demonstrate how we build a data engineering framework with reliable data sources and modern ETL pipelines that helps us maintain data accuracy, integrity and consistency. We promote transparency and self-serve analytics through strong data governance and stewardship practices, including the use of Row-Level-Security to support secured access control. Through Tableau and Power BI, we create visualizations with accessible dashboards that standardize definitions, improve understanding on meaning of data and trends, and deliver values with two major streams of usage: operational use to enhance day to day efficiency, and analytical insights for university stakeholders to take action confidently and securely. We will also demonstrate how Power Automate enables us to streamline our complex workflows, minimize errors from manual work and improves overall efficiency and accuracy.
Together, these integrated BI practices reinforce digital trust by improving data integrity, enhancing transparency and efficiency and reducing potential operational risk. Attendees will gain an understanding of our approach to managing data, with practical demonstrations to gain insight into how we improve processes and use trusted data for better decisions across the university.
The presentation will be delivered as a lecture with interactive elements, including a live poll during demonstrations, followed by a Q&A session.
