The Data Warehouse Toolkit 2nd edition: The Complete Guide to Dimensional Modeling by Ralph Kimball and Margy Ross is the most authoritative information on dimensional modeling for data warehousing! Dimensional modeling has change into the most extensively accepted approach for knowledge warehouse design. The information warehouses are needed to assist businesses make higher decisions.
Authors present complete library of dimensional modeling methods, essentially the most comprehensive assortment ever written. Significantly expanded to cover each fundamental and advanced strategies for optimizing data warehouse design, this second version to Ralph Kimball’s basic information is greater than sixty percent updated.
The Data Warehouse Toolkit 2nd edition, by Ralph Kimball begins with elementary design suggestions and steadily progress step-by-step by way of increasingly complicated eventualities with all core principles in dimensional information modeling using examples.
Clear-cut tips for designing dimensional models are illustrated utilizing actual-world information warehouse case studies drawn from quite a lot of enterprise application areas and industries, including retail gross sales and e-commerce, stock management, procurement, buyer relationship management (CRM) and human assets management.
Different subjects embody accounting, monetary providers, telecommunications and utilities, training, transportation, well being care and insurance. By reading this book, you will have mastered the full vary of highly effective techniques for designing dimensional databases which can be easy to grasp and provide quick query response. You will also learn how to create an architected framework that integrates the distributed knowledge warehouse utilizing standardized dimensions and facts.
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
Ralph Kimball and Margy Ross
Wiley; 2 edition