First, balancing the data warehouse and source systems shows up on every Top-10 list of things *not* to do. Why? Because both are probably incorrect. Users must be weaned off operational system reporting and learn to approach the data warehouse as the trusted source of enterprise intelligence. The availability of metadata (e.g. what data is there?, how did it get here?, what does it mean?) will help users make the change.
Second, aside from "nuggets of gold" popping out of the data warehouse (e.g. a company discovering it's under-billing customers or over-paying suppliers), use control groups to determine what value the DW is providing. That is, do not leverage the DW for a small percent of business decisions and compare their result to others. Otherwise, with all other changes going on in an enterprise, it may be hard to attribute business benefit directly and confidently to the DW.
Dig Deeper on CRM strategy and implementation
Related Q&A from Doug Laney
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.