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.
Related Q&A from William McKnight
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight.continue reading
Get examples of how data mining is used in vertical industries, such as retail, manufacturing, healthcare, financial and telecommunications.continue reading
Learn the advantages and disadvantages of data mining tools and of implementing data mining technology.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.