The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence : remastered collection / / Ralph Kimball [and four others]

• Record Nr.: UNINA9910830844203321
• Autore: Kimball Ralph
• Pubbl/distr/stampa: Indianapolis, Indiana : , : Wiley, , 2016; ©2016
• ISBN: 1-119-23879-X; 1-119-22891-3; 1-119-21659-1
• Edizione: [2nd ed.]
• Descrizione fisica: 1 online resource (966 p.)
• Disciplina: 658.40380285574
• Soggetti: Data warehousing; Business intelligence
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes indexes.
• Nota di bibliografia: Includes bibliographical references and indexes.
• Nota di contenuto: Table 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; Chapter 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; Fact 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; Supporting 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; A Look to the FutureArticle Index; Index; End User License Agreement
• Sommario/riassunto: The 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.