Understanding operational reporting and the data warehouse

Should operational reporting come out of a data warehouse? Get an expert's take, plus learn about the relationship between operational systems, decision support and trend analysis.

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