Data Warehouse
University Data Warehouse (UDW) Initiative
UDW will contain historical data derived from transaction data stored in the PeopleSoft systems and other sources. It will separate analysis workload from transaction workload and enable TCU to have a single source of University Data. UDW will be used for reporting, data analysis, ad-hoc queries, and dashboards with a rich end-user experience.
Initial Goals of the Initiative:*
- Conducting a Readiness Assessment
- Developing a business case and obtaining funding
- Determining organization structure
- Defining scope and key measures
- Defining initial roles in UDW team
- Conducting a current state analysis
- Building a phased project plan including launch and communication
Future Goals of the Initiative:
- Providing Decision Support Services based on the data analysis
- Creating Data Management Policies to ensure integrity and accessibility of the data
- Creating Internal Training Program to improve adoption and use of UDW
