The Kimball Group reader relentlessly practical tools for data warehousing and business intelligence : remastered collection
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 insig...
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Indiana :
Wiley
2016.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630186206719 |
Tabla de Contenidos:
- 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
