The Data Warehouse Project

1
The Data Warehouse Project

• Administrative Computing Information Services
• Carnegie Mellon University

2
The Data Warehouse Vision

• Carnegie Mellons Data Warehouse will empower
  staff, faculty, and students by providing a
  secure, well-organized, easily interfaced, and
  universal point of access to authorized data
  resources. The Data Warehouse will facilitate
  business intelligence by integrating previously
  disparate, inaccessible, and unorganized data
  stores, leveraging a variety of reporting and
  analysis tools, and promoting sharing among users.

3
Purposes

• Query
• Reporting
• Analysis
• Data Extraction

4
Approach

• Evolutionary
• Controlled
• Opportunistic
• Iterative

5
Targeted Data

• Student
• Financial
• Personnel
• Alumni
• Directory

6
Features and Functions

• Certified reports/queries
• Contributed reports/queries
• Ad hoc query
• Data extraction
• Optimized for query performance
• Inherited access rights from source systems
• Regular refresh from source systems

7
Accessing the Data Warehouse

• ACIS will provide user support for specified
  tools. The currently supported tool is Oracle
  Discoverer
• Desktop web clients
• Canned reports
• Ad hoc query
• Data extraction
• Retained and shared queries
• Security layers
• Data dictionary

8
Project Timeline

• Phase I Proof of Concept (Complete)
• Establish Technical Infrastructure
• Prototype Data Extraction/Transformation/Load
• Prototype Financial Analysis Reporting
• Phase II Controlled Release (In Process)
• Current Financial Data (Oracle Apps)
• Legacy Financial Data (FRIS PEP History)
• Salary Inquiry and BDI Extract (DRIVE)
• Student Data (QSIS )
• Virtual LDAP
• Phase III General Availability

9
Next Steps

• Evaluate Discoverers web client
• Convene pilot user group
• Develop user administration procedures
• Perform security and data audits
• Develop Salary Inquiry BDI extract
• Launch targeted marketing and training efforts

10
Technical Specification

• Database Oracle Version 9i
• Hardware Sun Enterprise Server 4500
• 8 CPU
• 8 GB RAM
• Operating
• System Solaris 2.8

11
The Project Team

• Project Sponsors Len Brush
• Martha Baron
• Mary Ann Blair
• Project Director Joyce Moore
• Database Admin Massimo Bigliardo
• Thang Vu

12
The Project Team

• Financials
• Functional Team Alison Campbell
• Liz Cooke
• Beth Meiser
• Steven Selig
• Linda Schmidt
• Deanne Weaver
• Tech Team Bob Gabert
• Krishna Kumar
• Joyce Moore
• Bob Rittiger
• Thang Vu

13
The Project Team

• DRIVE
• Functional Team Linda Schmidt
• Tech Team Dave Burzese
• Bob Gabert
• Joyce Moore

14
The Project Team

• Additional Resources
• CFOs Office Beth Meiser
• Planning Office Stacey Lopez
• Linda Schmidt
• HR/Training Len Stellitano

15
End

16
(No Transcript)