The Integrated Data & Reporting Project ("IDR Project") is intended to integrate the University's information resources, establish more comprehensive databases and substantially improve its efficiency in analysis and reporting.
Click the following topics for more information.
Project Objectives
- Gathering information on all departmental systems, existing databases and identify gaps of data and reports that do not exist.
- Implement a comprehensive data warehouse and make distributed and central data more accessible.
- Implement a new sustainable analysis and reporting tool that can combine the university's multiple data sources.
- Develop standard reports for the university community.
Project Benefits
- Increased Accessibility of Data - Centrally located data once stored on a workstation, on compact disks or other servers would become accessible to your department and others (if appropriate).
- Increased Performance - Data stored on the university's high performance hardware can be retrieved and compiled with optimal speed. It would also be running on platforms equipped with the latest operating systems, databases and updated web servers.
- Unified Security - Centrally stored data will instantly inherit established protection within the university infrastructure and could gain additional user or group level security.
- Disaster Recovery - Centrally stored data can be backed up as part of standard IT processes. Having the ability to restore data protects the university from losing informational assets while minimizing down-time, cost and interuptions of operations.
- Increased Reliability - Centrally stored data will inherit the established capability to continue functioning when equipment failures occur. The risk of relying on a single workstation or server is eliminated.
- University-wide Cost Savings - Departments who locate their data centrally can eliminate computing resources they maintain at their own expense and begin benefiting from all of the above.
- Establish new governance structures supporting the definition of data standards, policies and business processes
Project Activity
- May 1, 2012 - Data Ownership Subcommittee meeting
- April 25, 2012 - Data Definitions Subcommittee meeting
- April 24, 2012 - Data Policy Subcommittee meeting
- April 17, 2012 - Data Policy Subcommittee meeting
- April 11, 2012 - Data Ownership Subcommittee meeting
- April 9, 2012 - Steering Committee meeting
- April 5, 2012 - Phase 1 Test Group & Data Ownership Subcommittee meeting
- April 3, 2012 - Phase 1 Test Group meeting
- March 29, 2012 - Steering Committee meeting
- March 27, 2012 - Data Policy Subcommittee meeting
- March 22, 2012 - Steering Committee meeting
- March 13, 2012 - Data Policy Subcommittee meeting
- March 12, 2012 - Data Ownership Subcommittee meeting
- March 6, 2012 - Data Policy Subcommittee meeting
- February 28, 2012 - Data Policy Subcommittee & Steering Committee meeting
- February 27, 2012 - Data Ownership Subcommittee meeting
- February 14, 2012 - Data Policy Subcommittee meeting
- February 7, 2012 - Data Policy Subcommittee meeting
- January 31, 2012 - Data Policy Subcommittee meeting
- January 26, 2012 - Data Definitions Subcommittee 1st meeting
- January 25, 2012 - Steering Committee meeting
- January 18, 2012 - Data Policy Subcommittee 1st meeting
- January 9, 2012 - Security Assessment begins
- January 2, 2012 - IS loads Banner Operating Ledger & Transaction History sub-marts in Test ODS
- December 19, 2011 - Steering Committee meeting
- IDR Strategic Roadmap delivered
- December 15, 2011 - Provost appoints Data Stewardship Subcommittee Members
- December 12, 2011 - Met with UO Foundation to bring Fund/Account balances into new Data Warehouse
- December 2, 2011 - Steering Committee meeting
- November 17, 2011 - Steering Committee meeting
- Advisory Committee meeting
- November 2, 2011 - Steering Committee meeting
- October 31, 2011 - Information Collection Process ends - Integration analysis begins
- October 24, 2011 - Official Project Kick-Off Event
- October 17, 2011 - Steering Committee meeting
- October 11, 2011 - Technical Roadmap presented
- October 6, 2011 - Advisory Committee meeting
- September 28, 2011 - Information Collection Forms Online - web submissions begin;
- Steering Committee meeting
- September 22, 2011 - Steering Committee meeting
- September 12, 2011 - Advisory Committee 1st follow-up meeting
- August 22, 2011 - First Advisory Committee meeting - University-wide assessment begins
- August 19, 2011 - IDR Project Website established
August 8, 2011 - Technical Requirements Assessment begins
- August 18, 2011 - Steering Committee meeting
- August 2, 2011 - Steering Committee meeting
- August 1, 2011 - Infolink Consultants arrive at Eugene campus and Assessment phase begins
- July 10, 2011 - UO delivers approved contract to Infolink Consulting
- December 1, 2010 - Steering Committee formed - Project Management Firm Search begins
News, Upcoming Events & Milestones
May 2012
- New Data Warehouse and Reporting Tool Setup
The University IS department continues working on the Phase 1 Data Movement from the Banner Finance system that includes the Finance Operating Ledger and Transaction History sub-marts into the new Data Warehouse TEST environment. They concurrently are receiving Cognos training and working on deployment of Cognos in the TEST environment.
- First Reporting Project
The Project team continues to work on the development of a Functional Spec that defines the content and functionality of UO's first reporting project. The goal is to produce content that demonstrates how Cognos can present commonly needed data in new and useful ways. The Phase 1 Test Group met the week of April 1st to review Cognos capabilities and the Functional Spec to provide their feedback on this first project. The Steering Committee is now reviewing the Spec to make the final decisions needed.
- TEST Data/Report Development Environment Available Soon
UO IS projects the new Data Warehouse and Cognos Reporting Tool TEST environments will become available around April 15th. Setting up Cognos Security, revising the access forms and exercising the security authorization process will be valuable.
June 2012
- IBM demos Cognos BI at UO
We have invited IBM to come to Eugene and show what your new Cognos BI Suite of software can do. It will be exciting! The exact date, times & locations are still being determined.
- Phase 1 Reporting Project Development begins
Upon completion of their Cognos training, UOIS will begin development of the first reporting project according to the Functional Spec. It is expected to include a dashboard with helpful graphs, a static report with multiple progressions (Org/Fund, etc.) and drill downs to detail, and an example of high performance analytics.
News, Events & Milestones Archive
|
Project Timeline & Progress:
Assessment Phase (August 1, 2011 - April 1, 2012): During this phase, committees will be formed to identify and collect information about existing systems, data and reports as well as data or reports that do not exist. Analysis of this information will enable us to formulate a plan to integrate data with the new warehouse and establish a timeline for the rest of the project. At the same time, the Communications plan will be executed to raise awareness of the project throughout the University, the technical requirements of the project and the data / reporting policy needs will be determined. The hardware required to accomodate the new ODS/EDW and Cognos Test environments will also be setup.
