List of Figures

Figure 1. Management Structure
Figure 2. Definition of a Data Warehouse
Figure 3. Operational and Informational Data
Figure 4. Sample Data Consolidation Paths
Figure 5. Growth of Impact
Figure 6. Data Warehousing - A Process View
Figure 7. Data Warehousing Functions
Figure 8. Data Cube Example
Figure 9. Star Schema Example
Figure 10. Tasks and Metadata
Figure 11. "New Roadmap To Data Warehousing"
Figure 12. Decision Support Stages
Figure 13. DEET Files & COHORT Methodology
Figure 14. Derivation of Student Progress Unit
Figure 15. A Simplified Data View
Figure 16. Relational View of Operational Data, With Data Warehouse
Figure 17. Architecture For Analysis
Figure 18. Entity Relationship Diagram for ODS
Figure 19. Entity Relationship Diagram for DW
Figure 20. Sample QTP source code
Figure 21. Sample JCL for scheduling -

List of Tables

Table 1. Information System Components and Platforms
Table 2. Semantic Differences in STUDENT ID
Table 3. Comparing a Data Warehouse and an Operational Database
Table 4. Comparing OLTP,DSS and OLAP Databases
Table 5. Evolution of data across three server platforms
Table 6. Benefits of Data Warehousing
Table 7. Limitations of Traditional Tools
Table 8. Costs of Data Warehousing
Table 9. Evaluation Rules for Multi-dimensional Analysis Tools
Table 10. Levels of Decision Support Tools
Table 11. Checklist for Data Warehousing Success
Table 12. Information requirements for specific management areas
Table 13. Data Warehouse User and Access Types
Table 14. Indicators of Student Performance and Progress
Table 15. Cohort Analysis Model Dimensions
Table 16. Data Integration & Cleanup Issues
Table 17. Semantic Differences in STUDENT ID


Used in this report:
Word Processing
Word processing was done using Microsoft Word 7.0a.

All diagrams were drawn using Microsoft Word Draw. The diagrams were grouped and pasted into SmartDraw 3.0, a shareware program from SmartDraw Software Inc. ( and exported in Windows Meta File format and in GIF format. The WMF files were linked and embedded in the Word document. The GIF files were linked to the web version of the report.

A bibliographic database was maintained in Microsoft Access. Access reports were written to export this as HTML with hypertext links for the web references, and as Word formatted for inclusion in this report.

The conversion to HTML was assisted using WebEdit PRO 2.0.1 for Windows 95, a shareware program from Nesbitt Software Corporation (

Used in the project:
Visible Analyst Workbench from Visible Systems was used for developing data models for the data warehouse. It was used for creating diagrammatic representations of the data warehouse, as well as for generating the relational database schema definition.

Relational Database
The data warehouse was built using Oracle RDB/SQL V6.1 on a DEC Vax Cluster running VMS V6.0.

Data Replication
Programs were written to extract data, and translate and load it into the data warehouse using the Cognos 4GL PowerHouse QTP.

Data descriptions and meanings were extracted from the PowerHouse data repository using the Cognos 4GL PowerHouse QUIZ. A Microsoft Word macro then formatted this into user documentation. Data replication programs recorded update counts and times.

User Desktop Tools
For end user reporting and enquiry, Cognos Impromptu was used. For multidimensional analysis, Cognos PowerPlay was used.

I would like to thank Professor C.N.G. (Kit) Dampney from Macquarie University and Mr. Lyndon Harris, Director of Information Technology Services at Avondale College, for their encouragement and support in this project.

Next section or table of contents

Last Modified: Monday, September 2, 2002 12:12 PM