Hide Notes 

Slide 1: Intro to Cognos Beta Environment July 22-24, 2003
Slide 2: Agenda      Background: Why are we here? Describe Data in Beta Environment Navigational Tutorial for Three Tools Guided Practice Questions and Answers 2
Slide 3: Why are we here?     Enterprise Reporting tools will be the tools supported by the University and accessible to all faculty and staff. Early practice so you are ready for July 1, 2004 launch Are the data and data definitions right? Sharing—your work will be useful to a larger community (Beta Testing Share) 3
Slide 5: Benefits of Enterprise Reporting        Deliver information faster and with lower costs Reduce hard copy reports (no need to print) Eliminate need for shadow databases (no need to download) Eliminate reliance on tools du jour Eliminate reliance on IT staff to run reports Share report definitions with others electronically Broader access to university data 5
Slide 6: Data in Beta Environment   UF Directory  Active Directory—real-time Updated biweekly, each payday Current and Prior Fiscal Year Updated biweekly Snapshot of Current 6 Payroll Cost Distribution    Personnel  
Slide 7: Data in Beta Environment  Student Information   Updated Daily Snapshot of Recent Students Updated Daily and Monthly Current plus two prior years 7  FLAIR Financial Transactions  
Slide 8: Data on “Go Live” (August 4)  “Enterprise Reporting” will appear as myUFL menu item for all UF Faculty and Staff  Available data and queries depend on role PDF form on myUFL menu under “Enterprise Reporting”  Security Forms  8
Slide 9: Data on July 1, 2004  PeopleSoft data and systems replace current UF systems for: ► General Ledger ► Sponsored Research ► Billing ► Expenses ► Payables ► Purchasing ► Asset Management ► Human Resources ► Benefits ► Time and Labor ► Payroll ► Inventory ► Receivables ► Projects 9
Slide 10: Data Marts   A set of warehouse data optimized for reporting needs – speed and usability Based on subject matter    Directory Data Mart Financials Data Mart Personnel Data Mart  May have access to all or some of the newsboxes (folders) within a Data Mart 10
Slide 11: University of Florida Information Value Chain Operational Management Executive Web based Reports PeopleSoft (Student, HR, FIN, Payroll) Enterprise Reporting (Optimized for best response) Information ETL OLAP cubes Information delivered to end user Web based Internal Analysis    Reports & Spreadsheets Via email Direct Delivery Predictive Modeling Data Mining UF Legacy Data Enterprise Data Warehouses (Optimized easy ad hoc access) Data Mining Individually generated data stores, reports and spreadsheets Self-service data access for consumer Data Mart reporting Enterprise Data Marts and Cubes Detailed Summarized Analyzed Data Acquisition Data collected in Transactional Systems Data extricated, transformed and loaded Data Transformation Data prepared & presented to various audiences Data Dissemination Data to Information
Slide 12: PowerPlay    Draws information from relational databases to build OLAP “cubes”— large datasets developed by project or central offices Users analyze data using Web, Windows or Excel environment Create and share reports with others 12
Slide 13: Cognos Query    Similar to Viador but simpler wizard paradigm with Point and Click capability Direct access to near real-time data via the Web Run existing queries, design new ones, publish queries 13
Slide 14: Web Impromptu    Managed, print-ready reports Created by central offices and limited number of developers Users can subscribe to reports and customize them to meet their specific needs 14
Slide 15: Sharing    Send comments, suggestions, ideas, corrections to beta-reporting@ufl.edu Save your useful reports to BETA TESTING SHARE newsbox. Name and describe well… In Future – Create College/Dept/Unit folders for sharing 15