I'm involved in data warehouse management and design and am wondering if you could you please outline the procedures required to operationalize a data warehouse?
Data warehouse management and design can be complicated -- but doable. If by operationalize, you mean that you wish to put the data warehouse into a production environment where the users are able to count on it 24/7 for real business decision making with a high degree of predictability, I give you these 10 things:
Data warehouse management and design tips
- Implement strict change control for structure, reports and new data.
- Implement a 24 x 7 bullet-proof on-call rotation for support.
- Implement a user support program where users are able to call for technical or business support.
- Implement a user training program to educate new users on how to use the data warehouse.
- Implement a performance monitoring program to monitor common and important queries.
- Implement metadata, describing the data in the warehouse, that is useful to users.
- Build and publish an iteration plan for the next two to three years describing anticipated data warehouse enhancements over time.
- Establish business data stewardship by subject area.
- Utilize the data stewards to establish a data quality program.
- Communicate all of the above via your intranet page or other means of communication.
Note: I do not say you must get a specific technology, provide a specific level of performance or necessarily have x years of atomic data in order to operationalize a data warehouse. That is all according to user need.
Read more data warehouse management and design tips, articles and expert advice.
Dig Deeper on Business intelligence software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.