The Ohio State University
www.osu.edu
  1. Help
  2. Campus map
  3. Find people
  4. Webmail

Ohio State University logo Office of the CIO CIO Annual Report
  1. Affiliations
  2. CIO Office
  3. CIO Stakeholders
  4. Governance
  5. IT Strategic Plan
  6. Initiatives
  7. OSU Academic Directory
  8. OSU Administration
  9. OSU IT Resources

  10. Additional Resources
  11. CIO Annual Report
  12. IT Facts at Ohio State
  13. Legislative Updates
  14. OSU IT Communications Plan


Office of Chief Information Officer
320 Baker Systems Engineering
1971 Neil Avenue
Columbus, OH 43210
Phone: (614) 292-6553
Fax: (614) 688-4226

Office of the CIO Annual Achievement Report

logo image Contents
- Message from the CIO
- Collaborations and More
- 2007 Achievements

- 2007 Annual Report (pdf)
- 2006 Annual Report (pdf)
- 2005 Annual Report (pdf)
 Supplemental Information
IT Strategic Plan 2008 (Refresh)
President Gee's Strategic Goals
Academic Plan
University System of Ohio
Who We Are (CIO Office)
OSU IT Poll Data
CIO CommunITy News
Faculty IT Resource Guide
Student IT Resource Guide

2007 Achievements

Data Warehouse Initiative
Develop an enterprise data warehouse to maximize the use of currently available central data for reporting and planning purposes.

Since 2004

Developed a strategic plan for the Enterprise Data Warehouse; hired a program manager and additional staff for Course Analytics and collaboratively launched the Course Analytics Data Mart; completed Phase 1 of Faculty Analytics and began Phase 2; released Student Analytics; and consolidated and standardized the Operational Data Store and Data Warehouse web sites into a single point of entry that handles user access requests.

Since 2007

  • Implemented the Financial Data Warehouse, which included a purge of the Financial System database; moved Financial reports to the data warehouse, and made some small enhancements.

  • Initiated the Human Resources Data Warehouse Project and hired a project manager.

  • Completed development and unit testing on the Asset Management Data Warehouse and Purge Project and began quality assurance testing to validate the load process.

  • Began investigating architecture and process changes for the development and loading of the Data Warehouse so it can accommodate Human Resources and Student data within the nightly batch window.

  • Continued the ongoing exploration of synergies between the OSU:pro database of profiles of faculty and staff and Data Warehouse projects.