Reporting and Analytics

Data CommunicationsDocumentationFAQ | Contact

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.

Reporting and Analytic tools such as Cognos, Tableau and D3 convert raw and often-cumbersome data into consumable and interpretable information. This refined information is essential for federally mandated reporting, as well as other indispensable university reporting. Enterprise Analytics is the newest version of the Cognos reporting and data management product suite, providing UF with report authoring, interactive (drag and drop) dash-boarding capabilities and data modeling capabilities, as well as the ability to collaborate and share datasets between users and across departments. Users with the ER_USER role currently have access to the beta trial and can access the tool at: https://qat-reporting.it.ufl.edu. The system will eventually have access to a wide variety of information in UF’s “Data Lake,” where users can upload their own data for use while keeping it distinct and protected. Learn more

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.

Data Communications:

Subscribe to the listservs you are interested in by emailing LISTSERV@LISTS.UFL.EDU like so: 

To: LISTSERV@lists.ufl.edu

     From: <exchange_address>@ufl.edu

     Subject: <blank>

     Body: SUB UF-DATA-FEDERATION-L FirstName LastName

Upon sending a subscription request to the list, subscribers will receive a single confirmation e-mail.  There are FOUR different list serves you may want to subscribe, for each listserve please send a separate email with a single address in the body of the email:

Documentation and further information about Reporing & Analytics:

Rise to Five Dashboards [October 2018]

COMPASS Data & Reporting Options [August 2018 - PPT]

  • This presentation gives an overview of the upcoming COMPASS deployments, reviews data capabilities of past/future deployments and provides contingency plans for data access.

UF Reporting Services launched two new Enterprise Analytics training courses in November 2017:

Enterprise Analytics Getting Started User Guide - a comprehensive instruction guide covering:

  • Navigation
  • Running Reports in Enterprise Analytics, Reporting Prompts, Export Reports (Excel, PDF)
  • Interacting with HTML Interface, Saving as New Report
  • Customize existing reports (filtering, sorting, grouping, etc)
  • Schedule and Automate Report Delivery
  • Packages and Query Subjects in Today’s Workshop
  • Additional Resources

Cognos Analytics beta environment now live [February 2017]

Enterprise Reporting’s Cognos Analytics brings data interactivity to UF [December 2016]

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

FAQ:

Coming soon.

CONTACT:

Fran Fiorello - IT Manager

James Martinez - Database Administrator