The Goals of a Data Warehouse (R. Kimball)

• The data warehouse shall provide access to the corporate . . . data. => Tap many different data sources.

• The data in a data warehouse is consistent. => Snapshot at specific point in time.

• The data in a data warehouse can be separated and combined by means of every possible measure . . . => Dimensional data warehousing

• A data warehouse is not just data, but also a set of tools to query, analyze, and present information => 60% is data management, 40% analysis tools

• A data warehouse publishes data for being used. => Data Quality Management is important

• The quality of the data . . . is a driver of business reengineering. => Show how valuable good data would be.

Notes: