DM&A Current Events
Recent DM&A Projects
Degree Audit Reporting
Data Management & Analytics is working on accessing and storing data from the University’s Degree Audit system which tracks students’ completed courses and progress towards graduation. The data is being reviewed and validated by the Registrars Office before it is used to assess how students are completing their requirements.
TLO Data Integrations
Data Management & Analytics is working with the Technology Licensing Office (formerly PIVOT Center) on integrating Human Resources and Office of Sponsored Project data into their Salesforce instance. This will streamline TLO’s Invention Disclosure process and university federal reporting requirements.
Canvas 2 API
We are now into phase 2 of this project which will include web logs (formerly known as “requests data” in Canvas 1). The web logs provide insight to user activity in Canvas and can be joined up to the existing Canvas 2 tables to provide more context. This data set will be hosted on our cluster due to its size, with portions available in our Oracle database (BIPR).
Enhancing Reporting for Athletics Financial Data
Working with Athletics to provide financial data for their financial dashboards. Using Athletics schemas to bring in their revenue and transfer hierarchies.
Data Warehouse Architest - Kaidon Spencer |
|
|
|
Data Management & Analytics (formerly Business Intelligence) in UIT’s University Support Services is pleased to announce that Kaidon Spencer has been hired as a Business Warehouse Architect. Spencer reports to Director Brian Harris. Spencer previously served as a Business Administration Coordinator for Canon Medical Systems USA, Inc. In that role he performed extensive ad hoc reporting using SQL and Python and built dashboards in Salesforce, QlikView, and OBIEE to monitor KPIs for the service team. Prior to Spencer’s position at Canon Medical Systems, he worked as a Medical Data Analyst Intern at Blue Wind Medical Devices and as a Senior Analyst at Assure Services. In his new role, Spencer will support the data architecture, data modeling, planning, designing, and creation of ETL and maintenance needs within the University of Utah’s Data Management and Analytics Program in UIT on the main campus. He will also design and build relational databases for data storage or processing, and develop strategies for warehouse implementation, data acquisition, and archive recovery. Spencer holds a both Master's of Information Systems and Bachelor’s of Economics from the University of Utah. |
Data Governance
Mission Statement: Utilize data management standards, data models, collaboration, and transparency to help departments expand their data usage and analysis.
Definition: Data Governance is comprised of the policies and processes that determine how an institution organizes the architecture, accessibility, storage, and usability of its data, while ensuring that the data is trustworthy and secure.
Data Management: The University uses Collibra to perform many of its data mapping and accessibility functions. Collibra contains glossaries of business & technical terms, data catalogs, technical linage diagrams, and workflows to aid in the processing, approval, and storage of data.
Data Science
Mission Statement: Accelerate the speed, scale, quality, and impact of data science using well-managed, centralized, and governed data.
Definition:To achieve its goals, Data Science will implement enterprise best practices and enable continuous improvement through clarity, transparency, reproducibility, and collaboration.
Tools: The Data Science team primarily works with 'R' and Python programming languages. The team uses Posit Connect to support machine learning models in production, move advanced visualizations and functions into Tableau, and produce on-demand custom reporting.
Data Engineering
Mission Statement: Make data accessible and easy to understand through centralized storage and integrations.
Definition: The Data Engineering team works with areas across campus to move data to a central repository so that it can be accessed, combined with a variety of sources, and with a clarified business purpose and steward.
Engineering Projects: The engineers in DM&A maintain the data in the Student Data Warehouse (SDW), Financial Data Warehouse, and a multitude of Operational Data Stores (ODS) for areas across campus. They are the facilators of data movement across campus and can help individuals connect cross-departmental data.
Data Visualization Tools
Tableau: A data visualization software that connects to a wide variety of data sources and allows for rapid insight by transforming data into appealing, interactive visualizations called dashboards. Users create dashboards by using available BI data or their own existing data, and then share them by uploading to the Tableau Server. Tableau is best suited to visualize aggregated data through graphs & charts.
Web Intelligence (Webi): The part of the SAP BusinessObjects product suite that is used for analytical reporting to meet an organization's business requirements. Webi is a Business Intelligence reporting tool for business users to analyze data in a data warehouse, helping organizations with decision-making. Webi is best suited for reports containing tables and lists.
