Record:   Prev Next
作者 Kimball, Ralph
書名 The Kimball Group Reader : Relentlessly Practical Tools for Data Warehousing and Business Intelligence
出版項 Hoboken : John Wiley & Sons, Incorporated, 2010
©2010
國際標準書號 9780470630532 (electronic bk.)
9780470563106
book jacket
版本 1st ed
說明 1 online resource (747 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
附註 The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Businss Intelligence -- About the Authors -- Contents at a Glance -- Contents -- Introduction -- Intended Audience and Goals -- Preview of Contents -- Navigation Aids -- Terminology Notes -- Chapter 1: The Reader at a Glance -- Setting Up for Success -- Tackling DW/BI Design and Development -- Chapter 2: Before You Dive In -- Historical Perspective -- Dealing with Demanding Realities -- Chapter 3: Project/Program Planning -- Professional Responsibilities -- Justification and Sponsorship -- Kimball Methodology -- Chapter 4: Requirements Definition -- Gathering Requirements -- Organizing around Business Processes -- Wrapping Up the Requirements -- Chapter 5: Data Architecture -- Making the Case for Dimensional Modeling -- Enterprise Data Warehouse Bus Architecture -- Integration Instead of Centralization -- Contrast with the Corporate Information Factory -- Chapter 6: Dimensional Modeling Fundamentals -- Basics of Dimensional Modeling -- Dos and Don'ts -- Myths about Dimensional Modeling -- Chapter 7: Dimensional Modeling Tasks and Responsibilities -- Design Activities -- Design Review Activities -- Chapter 8: Fact Table Core Concepts -- Granularity -- Types of Fact Tables -- Parent-Child Fact Tables -- Fact Table Keys and Degenerates -- Miscellaneous Fact Table Design Patterns -- Chapter 9: Dimension Table Core Concepts -- Dimension Table Keys -- Date and Time Dimension Considerations -- Miscellaneous Dimension Patterns -- Slowly Changing Dimensions -- Chapter 10: More Dimension Patterns and Case Studies -- Snowflakes, Outriggers, and Bridges -- Dealing with Hierarchies -- Customer Issues -- Addresses and International Issues -- Industry Scenarios and Idiosyncrasies -- Chapter 11: Back Room ETL and Data Quality -- Planning the ETL System -- Data Quality Considerations
Populating Fact and Dimension Tables -- Supporting Real Time -- Chapter 12: Technical Architecture Considerations -- Overall Technical/System Architecture -- Presentation Server Architecture -- Front Room Architecture -- Metadata -- Infrastructure and Security Considerations -- Chapter 13: Front Room Business Intelligence Applications -- Delivering Value with Business Intelligence -- Implementing the Business Intelligence Layer -- Mining Data to Uncover Relationships -- Dealing with SQL -- Chapter 14: Maintenance and Growth Considerations -- Deploying Successfully -- Sustaining for Ongoing Impact -- Article Index -- Index
An unparalleled collection of recommended guidelines for data warehousing and business intelligence pioneered by Ralph Kimball and his team of colleagues from the Kimball Group. Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have written articles covering more than 250 topics that define the field of data warehousing. For the first time, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation. Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology and cover the complete lifecycle-including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence and analytics. This easily referenced collection is nothing less than vital if you are involved with data warehousing or business intelligence in any capacity
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
鏈接 Print version: Kimball, Ralph The Kimball Group Reader : Relentlessly Practical Tools for Data Warehousing and Business Intelligence Hoboken : John Wiley & Sons, Incorporated,c2010 9780470563106
主題 Data warehousing.;Business intelligence
Electronic books
Alt Author Ross, Margy
Becker, Bob
Mundy, Joy
Thornthwaite, Warren
Record:   Prev Next