Reporting and Analytics

University of Florida has a long-term commitment to develop a comprehensive, centralized enterprise reporting solution that enhances UF’s data vending and data analytics capabilities. As part of COMPASS, UF has developed a strategy for reporting and analytics that includes a number of concepts, approaches and tools that subsequently can be deployed to address the university’s financial and HR reporting needs as well.

The primary goals of the COMPASS reporting strategy are as follows:

  • Secure institutional data – improve the security of sensitive data by moving data to a centralized system and implementing security protocols that are designed specifically for data vending
  • “Free the data” – increase the availability and usability of enterprise data by merging data from multiple data sources to create a 360-degree, holistic view of student data and making it available in a format that is easy to query
  • Empower business users – provide increased self-capabilities to enable business users to directly query and analyze institutional data
  • Improve institutional analytics and trend capabilities – implement new reporting and data analysis tools, including dash-boarding and metrics generation capabilities, to enable the university to perform enhanced, enterprise level analytics
  • Improve the quality of reports – implement data quality tools and policies to improve data quality and provision standardized data models for improved reporting consistency
  • Increase system performance – improve system performance by moving reporting activities to a dedicated reporting solution. With this change, the transaction systems can be tuned to optimize performance for transaction processing and the reporting solution can be tuned for maximum performance.

For COMPASS, we are implementing a reporting solution based on the Warehouse reporting model where data are regularly extracted (near real time, or as close to real time as practical) from source systems and copied into a dedicated and centralized reporting environment. The copied data are then validated, reformatted, summarized, restructured, and enriched with data from other sources. The resulting Data Warehouse is the source of data or information for most report generation, analysis and presentation through reports, interactive dashboards, ad hoc reporting queries, visualizations and other presentation methods. Reporting from the transaction systems will be limited to operational reporting using delivered reports and regulatory reports that are built using delivered technology.

We will build the new reporting solution using IBM’s reporting and data management product suite. The back-end components of this technology will allow the university to move data securely between the source systems and the Data Warehouse in near real time. IBM’s updated reporting interface, Enterprise Analytics, will provide the university with superior report authoring, interactive (drag and drop) dash-boarding capabilities, including graphing and other visualization methods, data modeling capabilities, as well as the ability to collaborate and share datasets between users and across departments. These enhanced self-service capabilities provide the user community with the ability to address many of their own reporting needs without intervention by Information Technology staff.

Learn more about Reporting and Analytics:

Training Course: ERA 100 - Enterprise Reporting: Dashboards [November 2017]

Cognos Analytics beta environment now live [February 2017]

Enterprise Reporting’s Cognos Analytics brings interactivity, ease of use to data [December 2016]

Sneak Peek: Enterprise Reporting, Cognos Analytics [December 2016]