What to Do with a Data Warehouse - dummies

By Thomas C. Hammergren

Part of Data Warehousing For Dummies Cheat Sheet

A data warehouse is a home for your high-value data, or data assets, that originates in other corporate applications, such as the one your company uses to fill customer orders for its products, or some data source external to your company, such as a public database that contains sales information gathered from all your competitors.

Why build a data warehouse? This table gives you four different classes of what you can do with a data warehouse:

Basic query and reporting “Tell me what happened.”
Business analysis (OLAP) “Tell me what happened and why.”
Data mining “Tell me what may happen” or “Tell me something
interesting.”
Dashboards and scorecards “Tell me how I’m doing currently and against my plan.”