> 3. Key Performance Indicators
Search this site
5. A reflective researcher with skills
|Development Plan||Portfolio Documentation|
|Determine the measurable factors that would be most useful to administrators and managers for both tactical and strategic decision support, for implementation using data warehousing technologies.||Describe the role of the Data Warehouse Steering Committee and the techniques used to determine key measurable factors for inclusion in a data warehouse.|
I began with a series of preliminary meetings, then on November 11, 1998, I set up the Data Warehouse Steering Committee. The following links show minutes of those meetings, and reports that were prepared for the committee.
After several meetings, it became clear that we needed to broaden the scope of attendees considerably, because there was an attempt to focus to early on implementation details. On November 11, 1998, we had the inaugural meeting of the Data Warehouse Steering Committee (see minutes). In this meeting, the members introduced themselves, then were taken through two handouts on What is Data Warehousing? and Data Warehouse Elements to Evaluate. The Gary Dickerson conducted a Business Readiness Assessment using a survey instrument, and discussed a framework for data warehousing using an outline from The Data Warehouse Institute (TDWI).
At the next meeting of the Steering Committee (see minutes), we reviewed a dictionary of data warehousing terms, then Gary Dickerson reported the results of the Business Readiness Assessment. Following a demonstration of a an end-user data analysis tool (PowerPlay from COGNOS), the group brainstormed on important subject areas to be included in the data warehouse. Here are the items that were identified in that meeting (listed alphabetically):
The intention was to circulate the list as use it as a basis for further comment and discussion. However, attempts to gain additional funding to staff the project were not successful, and since Gary's team of software developers were already occupied Y2K remediation and web registration, very little was done after this meeting until the middle of the year 2000.
I sent out a memo on June 15, 2000 calling the Steering Committee together again. We reviewed what we had done so far and revisited our objectives. The committee met on June 20 (agenda, minutes). At this meeting, the Dean's Statistics Subject Area was chosen as a starting point. A Data Warehousing Development Committee was set up to be responsible for this pilot project
Resources problems continued to plague ITS, but with the help of student labor, a datamart was built using Microsoft SQL Server, and a Dean's Statistics datacube was developed that supported OLAP data analysis via Microsoft Excel.
Some additional items that have been identified include:
These items came to light during the development of the Strategic Plan, in the Noel-Levitz Student Satisfaction Survey, in focus group meetings, and in meetings to develop a Knowledge Management Strategy (January 2002). While progress on the development of a data warehouse has been disappointingly slow, interest in the decision support improvements that it promises is not waning, but rather is gathering momentum.
Created: Wednesday, January 30, 2002 9:15 PM
Last Modified: Saturday, June 1, 2002 9:48 PM