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 (26 April 2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second ed.). Wiley. ISBN 0-471-20024-7). Inmon’s approach emphasizes the importance of data integration and consistency, while Kimball’s...
