| Title : | The Data Warehouse toolkit : the definitive guide to dimensional modeling | | Material Type: | printed text | | Authors: | Ralph Kimball, Author | | Publisher: | Indianapolis, IN : John Wiley & Sons, Inc. | | Publication Date: | 2013 | | Pagination: | xxxiv, 564 p. | | Layout: | ill. | | Size: | 24 cm | | ISBN (or other code): | 978-1-11-853080-1 | | General note: | Includes index (p. 543-564) | | Languages : | English (eng) Original Language : English (eng) | | Descriptors: | Business enterprises--Data processing.
Business intelligence
Data warehousing
Database design
| | Class number: | 005.74 | | Abstract: | "The Data Warehouse Toolkit"- is recognized as the definitive source for dimensional modeling techniques, patterns, and best practices. This third edition of the classic reference delivers the most comprehensive library of dimensional modeling techniques ever assembles. Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models-and needs of those new to data warehousing as well as experienced professionals. All the techniques in the book are illustrated wit real-world case studies based on the authors’ actual DW/BI design experiences. In addition, the Kimballl Group’s “official” list of dimensional modeling techniques is summarized in a single chapter for easy reference , with pointers from each technique to the case studies where the concepts are brought to life.
The third edition of The Data Warehouse Toolkit covers:
-Practical design techniques-both basic and advanced-for dimension and fact tables
-14 case studies, including retail sales, electronic commerce, customer relationship management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation
-Sample data warehouse bus matrices for 12 case studies
-Dimensional modeling pitfalls and mistakes to avoid
-Enhanced slowly changing dimension techniques type 0 through 7
-Bridge tables for ragged variable depth hierarchies and multivalued attributes
-Best practices for Big Data analytics
-Guidelines for collaborative, interactive design sessions with business stakeolders
-An overview of the Kimball DW/BI project lifecycle methodology
-Comprehensive review of extract, transformation, and load (ETL) systems and design considerations
-The 34 ETL subsystems and techniques to populate dimension and fact tables | | Contents note: | Introduction; Data Warehousing, Business Intelligence, and Dimensional Modeling Primer; Kimball Dimensional Modeling Techniques Overview; Retail Sales; Inventory; Accounting; Customer Relationship Management; Human Resources Management; Financial Service; Telecommunications; Transportation; Education; Healthcare; Electronic commerce; Insurance; Kimball DW/BI Lifecycle Overview; Dimensional Modeling Process and Tasks; ETL Subsystems and Techniques; ETL System Design and Development Process and Tasks; Big Data Analytics; Summary; Index; | | Record link: | https://library.seeu.edu.mk/index.php?lvl=notice_display&id=17939 |
|  |
EBSCOhost
World Bank
EconBiz
De Gruyter
OpenEdition
European Respiratory Journal
Mathematical Sciences Publishers Journals
Make a suggestion Refine your searchBusiness intelligence guidebook / Rick Sherman
