Chapter 6 Data Warehouses, Online Analytical Processing, and Metadata
The hub of the business intelligence (BI) environment is the data warehouse, which is a centralized repository of data that has been compiled from a number of disparate data sources and is in turn used to power the analytical processing from which business value is derived. For the savvy manager to get the high-level view of the data warehouse, he or she must first be aware of the differences between traditional entity-relationship models and dimensional modeling, which is more suitable to the data warehouse environment.
The importance of data modeling in an analytical context, coupled with managing the metadata associated with that data, has evolved as a critical component ...
Get Business Intelligence now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
