what is the office of central reporting? one central office, responsible to produce data reports and...
TRANSCRIPT
What is the Office of Central Reporting?• One central office, responsible to produce data reports
and analytics for the entire organization
Why?• Keeps data consistent for all users viewing the data• Common definitions are used across the institution• Eliminates confusion about who to request data from• Eliminates redundancy in reports
Who?• Cheryl Seiffert• Nate Thompson
Banner(input)
Oracle(transactional Banner
database)
Argos(output)
ODS(operational data
store – nightly copy of Banner
database used for reporting)
What does this mean for you?
• Argos is the tool you’ll use to view the data you want to see• Any requests for reports/data will come to the Office of Central Reporting• Most data needs will be provided using a self-service approach, however,
we will work with you to provide the best solution to provide what you need
(self-service means you can use Argos to view the information whenever you need it)
• We provide training• We work closely with users to ensure accuracy in reporting and accuracy
in the database• Commonly used reports will have links on theRock
Terms
• Parameters – choices on the Argos screen that help you filter what data you will see, allowing for multiple options and flexibility
• Quickview – a columnar view of the output of data you want to view, available on the Argos screen. This can be filtered, sorted on the screen or exported to Excel
• OLAP (online analytical processing) – a data cube, multi-dimensional format with columns and rows that can be moved around, similar to a pivot table, to produce various analytical views of data
• Dashboard – an tool used to provide related data elements, all in one place
• ODS (operational data store) – a database used for reporting that is refreshed with Banner data nightly
(some reports may be produced directly from Banner for real-time data needs)
Example of Parameters
Example of Quickview and Dashboard
Example of OLAP Shows how many students/credits are registered in a specific course, by instructor, by class
Same OLAP now showing each student, the courses they are registered for and how many credits
Our goal is to provide –
• Timely and accurate data• Access to data• Ease of use• Training• Customer service
