How healthy is your data warehouse?
1. Do you have difficulty conducting what-if analysis for a variety of business or product or geographical hierarchies?
2. Would it be hard for your current system to determine the impact of a business organization change on Operating Income?
3. Would it be hard for your current system to determine the impact of realigning geographical associations on regional profitability estimates?
4. Do you have difficulty restating historical data?
5. Can you view historic data using both a time-of-transaction basis and a current basis?
6. Can you currently restate historical data using new account structures?
7. Do you have difficulty viewing composites of data from sources with different granularities along key dimensions (i.e., comparing daily sales for a month, to forecast sales done monthly, to your annual profit plan, and to a five year long-range projection)?
8. Do you have difficulty with "bad data" getting into your current data warehouse?
9. Do you have difficulty maintaining the accuracy of your reference data?
10. Do you have difficulty with traceability from source to report?
So, how did your data warehouse application score? If it did not do well (i.e. failed on several of these ten points) then you should be concerned, because business users are likely to do exactly these types of things with the data in the warehouses, if not today then at some point. When they struggle, they will come looking for you.
A potential application of this checklist would be identify the best and worst data warehouses in your company. This type of "health check" could be useful in prioritising future investment e.g. it may highlight that some systems are in urgent need of overhaul or replacement. If you work in an IT department then going to business users with this kind of health check could be seen as being very pro-active and enhance the IT department's credibility with the business. If you are a systems integrator then creating a process for measuring the health of a data warehouse along these lines could be a useful tool that could be sold as a consulting engagement for clients.