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:
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.
Subscribe to the listservs you are interested in by emailing LISTSERV@LISTS.UFL.EDU like so:
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:
Rise to Five Dashboards [October 2018]
COMPASS Data & Reporting Options [August 2018 - PPT]
UF Reporting Services launched two new Enterprise Analytics training courses in November 2017:
Enterprise Analytics Getting Started User Guide - a comprehensive instruction guide covering:
Cognos Analytics beta environment now live [February 2017]
Sneak Peek: Enterprise Reporting, Cognos Analytics [December 2016]
Fran Fiorello - IT Manager
James Martinez - Database Administrator