6
Data Warehousing
As businesses collect ever-increasing amounts of data, data warehousing has become a critical component in managing and analyzing data. Cloud-based data warehousing provides a flexible and cost-effective solution for building systems that support data analytics as well as reporting. Here, we’ll explore the fundamental concepts of data warehousing, as well as the different approaches to designing a data warehouse.
We will start by discussing the two main approaches to data warehousing: the normalized approach by Bill Inmon (Inmon, William H. (1992). Building the Data Warehouse. Boston: QED Technical Pub. Group. ISBN 0-89435-404-3. OCLC 24846118) and the dimensional approach by Ralph Kimball (Ralph Kimball and Margy Ross (
Get Azure Data and AI Architect Handbook 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.