LEADER 06130nam 2200589 450 001 9910136431203321 005 20210803111449.0 010 $a1-119-23879-X 010 $a1-119-22891-3 010 $a1-119-21659-1 035 $a(CKB)3710000000587770 035 $a(EBL)4388620 035 $a(MiAaPQ)EBC4388620 035 $a(CaSebORM)9781119216315 035 $a(EXLCZ)993710000000587770 100 $a20160215h20162016 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $2rdacontent 182 $2rdamedia 183 $2rdacarrier 200 04$aThe Kimball Group reader $erelentlessly practical tools for data warehousing and business intelligence : remastered collection /$fRalph Kimball [and four others] 205 $a2nd ed. 210 1$aIndianapolis, Indiana :$cWiley,$d2016. 210 4$dİ2016 215 $a1 online resource (966 p.) 300 $aIncludes indexes. 311 $a1-119-22891-3 311 $a1-119-21631-1 320 $aIncludes bibliographical references and indexes. 327 $aTable of 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; Before Data Warehousing; 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 327 $aChapter 5: Data ArchitectureMaking the Case for Dimensional Modeling; Enterprise Data Warehouse Bus Architecture; Agile Project Considerations; 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 327 $aFact Table Keys and Degenerate DimensionsMiscellaneous 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 Considerations; 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 327 $aSupporting Real TimeChapter 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; Chapter 15: Final Thoughts; Key Insights and Reminders 327 $aA Look to the FutureArticle Index; Index; End User License Agreement 330 $aThe final edition of the incomparable data warehousing and business intelligence reference, updated and expanded The Kimball Group Reader, Remastered Collection is the essential reference for data warehouse and business intelligence design, packed with best practices, design tips, and valuable insight from industry pioneer Ralph Kimball and the Kimball Group. This Remastered Collection represents decades of expert advice and mentoring in data warehousing and business intelligence, and is the final work to be published by the Kimball Group. Organized for quick navigation and easy reference, this book contains nearly 20 years of experience on more than 300 topics, all fully up-to-date and expanded with 65 new articles. The discussion covers the complete data warehouse/business intelligence lifecycle, including project planning, requirements gathering, system architecture, dimensional modeling, ETL, and business intelligence analytics, with each group of articles prefaced by original commentaries explaining their role in the overall Kimball Group methodology. Data warehousing/business intelligence industry's current multi-billion dollar value is due in no small part to the contributions of Ralph Kimball and the Kimball Group. Their publications are the standards on which the industry is built, and nearly all data warehouse hardware and software vendors have adopted their methods in one form or another. This book is a compendium of Kimball Group expertise, and an essential reference for anyone in the field. Learn data warehousing and business intelligence from the field's pioneers Get up to date on best practices and essential design tips Gain valuable knowledge on every stage of the project lifecycle Dig into the Kimball Group methodology with hands-on guidance Ralph Kimball and the Kimball Group have continued to refine their methods and techniques based on thousands of hours of consulting and training. This Remastered Collection of The Kimball Group Reader represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field. 606 $aData warehousing 606 $aBusiness intelligence 608 $aElectronic books. 615 0$aData warehousing. 615 0$aBusiness intelligence. 676 $a658.40380285574 700 $aKimball$b Ralph$0148169 702 $aKimball$b Ralph 712 02$aKimball Group. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910136431203321 996 $aThe Kimball Group reader$91908949 997 $aUNINA