Should operational reporting come out of a data warehouse if possible?
I think the reverse is true. Unfortunately, not much reporting is possible without a data warehouse. Operational systems are focused on running the business, not providing analytics, decision support and trend analysis. They can quickly get tapped out doing operational functions, but reporting and other means of data access are still necessary -- hence, the data warehouse. Operational systems do not attend to data quality and are not structured well for data access. However, even after the data warehouse emerges with clean and integrated data, there remains a place for reporting out of the operational environment. A split of responsibility is healthy.
Dig Deeper on Business intelligence best practices
Related Q&A from William McKnight
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight. Continue Reading
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Learn the best way to select or customize your business activity monitoring software -- which begins with analyzing your business requirements. Continue Reading