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.
Business Analyst - One U - Tamara Thomas Johnson |
|
|
|
Data Management & Analytics (formerly Business Intelligence) in UIT’s University Support Services is pleased to announce that Tamara Thomas Johnson has been hired as a Business Data Analyst - OneU. Johnson reports to Director Brian Harris. Johnson previously served as a Business Analyst for Pharmatech Labs. In that role she coordinated project management for continuous improvement IT projects, created reports to analyze the company's performance and opportunities for improvement, and established and maintained data integrity procedures, processes and policies to enhance data integrity. Prior to Johnson’s position at Pharmatech Labs, she worked as a Business Analyst at Intermountain Healthcare and at Aetna Behavioral Health. In her new role, Johnson will work with cross-functional teams, service partners and other IT professionals to evaluate business processes, anticipate needs of stakeholders, uncover areas for improvement, and develop and implement solutions. In furtherance of these tasks, Johnson will create gap analysis documentation; elicit, develop, and maintain requirements documentation; and provide insight to business customers. She will author deliverables that include business requirements, processes and workflow documentation, use cases and training. Following issue resolution, Johnson will work with the departments to maintain output delivered to stakeholders to ensure data quality and integrity. Johnson holds a Bachelor’s of Science in Community Health Education from Brigham Young University. |
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.
