|
When it starts, Data Warehouse has a very rosy business case. Once the Data Warehouse is implemented, the following objectives should be followed, which will help justify the business case and establish a solid foundation for the future growth.
Maximizing Data Warehouse performance:
- Constantly review the operations and keep on making the scripts more efficient and be able to process more data in the shorter windows.
- Negotiate lager windows for Extraction from the owners of the source systems.
- Fine-tune the design given the experience of the usage of data.
Optimizing the end user usage of data warehouse
As Data Warehouse is implemented, users will need time to play with it and explore all of it possible applications. In the beginning one can expect to give a free hand to the users. However, as one proceeds forward, through education and training, one can drive the following:
- The information, which is produced, has to be used for some purpose.
- Information should be crisp and actionable. Too much information leads to too little.
- Optimizing ad-hoc queries, and standardizes 'routine' ad-hoc queries.
Ongoing user Training on Data Warehouse
- Refresher training for the users.
- Advanced training for the users, about more advanced and complex features.
Knowledge circles
- A knowledge exchange platform carrying ideas and tips on Data Warehouse
- Repository of report, dash-Board and Scorecard templates
- Case studies of the benefits and experiences on Data Warehouse.
Actual usage of Data Warehouse information
Organization can be 'Information Rich', but 'Action Poor'. The ultimate objective of establishing Data Warehouse business case is not to increase the timeliness and richness of information and saving MIS headcounts. The objective is to help driving business objectives. One should follow-up on: - Did the new and enriched information lead to a better decision and early action?
- Has the information produced become the lifeline of the audience? Do the phone start ringing if the pack is not produced at the given time?
Form an Information Management Council
Information Management council is typically an enterprise wide group of people responsible for information at departmental level.
|
