1. Introduction

1.1 Background
1.2 Section Summaries

1.1 Background

This project began as an Executive Information System (EIS, sometimes known as an Enterprise Information System) project. Federal Government funding was offered from the National Priority (Reserve) Fund in 1994 for two categories of project - management improvement and course development. Avondale College was successful in obtaining a $20,000 grant in the category of "management improvement". In the proposal applying for the grant, the project was summarized as follows:

"A corporate database will be designed with improved management information and decision support as the primary focus. Key administrators will be trained in the use of EIS tools to enable them to make the best use of the data resource.

"Transfer programs will be written to automate the replication of data held in existing systems into the new corporate database. The database will be designed to be CASMAC(1) compliant, so that as legacy systems are replaced, they will operate on the new database."

Given that the initial impetus for this project came at least partly from a management improvement grant, it is appropriate to examine briefly the management and decision making processes at Avondale College. Owing to its small size, Avondale has a relatively simple management structure.

Management Structure
Figure 1. Management Structure

An administrative group consisting of the five people represented in this chart meets weekly. It is responsible for tactical and operational policies and procedures, as well as strategic planning and long term goal setting. It is supported by other management and advisory committees.

This administrative group and department heads reporting directly to them will be the major users this data warehousing system and its associated desktop tools.

1.2 Section Summaries

The report opens with an Executive Summary and this Introduction.

Section 2 lists some of the pressing reasons why Avondale College undertook this Data Warehousing pilot project.

Section 3 is a summary of Data Warehousing principles, particularly those that have relevance at Avondale.

Section 4 documents aspects of the project itself that were significant in terms of the time or effort they demanded, social or technical implications, or their overall importance to the success of the project.

Section 5 concludes the report with some observations on the pilot project and suggestions for the future.

The report also includes a comprehensive bibliography, some appendices and an index.

Section Endnotes

(1) CASMAC is the Core Australian Specification for Management Computing.

Next section, Previous section or return to table of contents

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