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
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 how you can learn business intelligence (BI), get business intelligence training and discover why analytics is the key to marketing efforts ... Continue Reading
Learn about the different types of data access methods including OLAP and data mining, find out about using query languages to access data warehouses... Continue Reading