| Developing Data Warehouse Design for the
Postgraduate School, University of Ibadan
by Dr. Mrs. Adenike Osofisan and Rising
Osazuwa
We have been involved in the Design of a Data warehouse for
the postgraduate school of the University of Ibadan. This strategic
Information Technology project is of utmost relevance, in view of the
emerging systematic transformation of the University of Ibadan to a
Postgraduate University.
Developing a good data warehouse is no different from any
other IT project; it requires careful planning, requirements definition,
design, prototyping and implementation. The first and most important element
is a planning process that determines what kind of data warehouse strategy
the organization is going to start with.
Only a small fraction of the data that is captured,
processed and stored in the University enterprise is actually available to
executives and decision makers.
In developing the data warehouse for the University of
Ibadan, we are pragmatically addressing the critical issues of developing a
balanced data warehousing strategy that is appropriate for its needs and its
user population.
The emerging Data warehouse is tuned to achieving the
sustenance and maintenance of good quality data, as well as the deployment
of an effective, robust Decision Support System for the University Of Ibadan,
thus making significant contribution to the realization of the VISION of the
University of Ibadan as the leading educational Institution in Nigeria.
| Performance Indicators
|
| 1. |
Common data definitions
|
| 2. |
Properly trained users |
| 3. |
Improved Community communication
level |
| 4. |
Increasing stress elimination
(communication) path |
| 5. |
Improved Human resources efficiency
|
| 6. |
Improved SQL skills |
| 7. |
Improved Data Quality |
| 8. |
Reduced Information Management cost
|
| Benefits and Improvements |
| 1. |
Capacity Development and Knowledge
sharing. |
| 2. |
This project and interaction with
professionals from different parts of the world has improved the
development of the University ICT, communication and management skills. |
| 3.
|
The University has an improved and effective
Decision Support System. |
| 4. |
Training and Capacity Building for
the University community.
|
| 5. |
Reduction in cost of operation.
|
| 6.
|
Increase in resource utilization and preservation.
|
| 7.
|
Transparent and stress free information Processing.
|
| 8.
|
Commencement of Training the Trainer’s scheme
|
By investing in managing and improving data quality, the
University is bountifully reaping tangible and intangible benefits.
-----
Dr. Mrs. Adenike Osofisan
Head Department of Computer Science, University of Ibadan
&
Rising Osazuwa
Systems Analyst, Management Information System (MIS) Unit,
Vice-Chancellor’s Office,
University of Ibadan, Nigeria.
|