The data warehouse toolkit : the definitive guide to dimensional modeling

Mostrar todas las versiones(2)
Detalles Bibliográficos
Autor Principal: Kimball, Ralph
Otros autores o Colaboradores: Ross, Margy
Formato: Libro
Lengua:inglés
Datos de publicación: Indianapolis : Wiley, c2013
Edición:3rd ed.
Temas:
DATA WAREHOUSE
DISEÑO DE BASES DE DATOS
Acceso en línea:Consultar en el Cátalogo
Notas:Incluye índice
Descripción Física:xxxiv, 564 p. : il.
ISBN:9781118530801
Tabla de Contenidos:
  • Introduction
  • 1. Data Warehousing, Business Intelligence, and Dimensional Modeling Primer
  • Different Worlds of Data Capture and Data Analysis
  • Goals of Data Warehousing and Business Intelligence
  • Dimensional Modeling Introduction
  • Kimball’s DW/BI Architecture
  • Alternative DW/BI Architectures
  • Dimensional Modeling Myths
  • More Reasons to Think Dimensionally
  • Agile Considerations
  • Summary
  • 2. Kimball Dimensional Modeling Techniques Overview
  • Fundamental Concepts
  • Basic Fact Table Techniques
  • Basic Dimension Table Techniques
  • Integration via Conformed Dimensions
  • Dealing with Slowly Changing Dimension Attributes
  • Dealing with Dimension Hierarchies
  • Advanced Fact Table Techniques
  • Advanced Dimension Techniques
  • Special Purpose Schemas
  • 3. Retail Sales
  • Four-Step Dimensional Design Process
  • Retail Case Study
  • Dimension Table Details
  • Retail Schema in Action
  • Retail Schema Extensibility
  • Factless Fact Tables
  • Dimension and Fact Table Keys
  • Resisting Normalization Urges
  • Summary
  • 4. Inventory
  • Value Chain Introduction
  • Inventory Models
  • Fact Table Types
  • Value Chain Integration
  • Enterprise Data Warehouse Bus Architecture
  • Conformed Dimensions
  • Conformed Facts
  • Summary
  • 5. Procurement
  • Procurement Case Study
  • Procurement Transactions and Bus Matrix
  • Slowly Changing Dimension Basics
  • Hybrid Slowly Changing Dimension Techniques
  • Slowly Changing Dimension Recap
  • Summary
  • 6. Order Management
  • Order Management Bus Matrix
  • Order Transactions
  • Invoice Transactions
  • Accumulating Snapshot for Order Fulfillment Pipeline
  • Summary
  • 7. Accounting
  • Accounting Case Study and Bus Matrix
  • General Ledger Data
  • Budgeting Process
  • Dimension Attribute Hierarchies
  • Consolidated Fact Tables
  • Role of OLAP and Packaged Analytic Solutions
  • Summary
  • 8. Customer Relationship Management
  • CRM Overview
  • Customer Dimension Attributes
  • Bridge Tables for Multivalued Dimensions
  • Complex Customer Behavior
  • Customer Data Integration Approaches
  • Low Latency Reality Check
  • Summary
  • 9. Human Resources Management
  • Employee Profi le Tracking
  • Headcount Periodic Snapshot
  • Bus Matrix for HR Processes
  • Packaged Analytic Solutions and Data Models
  • Recursive Employee Hierarchies
  • Multivalued Skill Keyword Attributes
  • Survey Questionnaire Data
  • Summary
  • 10. Financial Service
  • Banking Case Study and Bus Matrix
  • Dimension Triage to Avoid Too Few Dimensions
  • Supertype and Subtype Schemas for Heterogeneous Products
  • Hot Swappable Dimensions
  • Summary
  • 11. Telecommunications
  • Telecommunications Case Study and Bus Matrix
  • General Design Review Considerations
  • Design Review Guidelines
  • Draft Design Exercise Discussion
  • Remodeling Existing Data Structures
  • Geographic Location Dimension
  • Summary
  • 12. Transportation
  • Airline Case Study and Bus Matrix
  • Extensions to Other Industries
  • Combining Correlated Dimensions
  • More Date and Time Considerations
  • Localization Recap
  • Summary
  • 13. Education
  • University Case Study and Bus Matrix
  • Accumulating Snapshot Fact Tables
  • Factless Fact Tables
  • More Educational Analytic Opportunities
  • Summary
  • 14. Healthcare
  • Healthcare Case Study and Bus Matrix
  • Claims Billing and Payments
  • Electronic Medical Records
  • Facility/Equipment Inventory Utilization
  • Dealing with Retroactive Changes
  • Summary
  • 15. Electronic Commerce
  • Clickstream Source Data
  • Clickstream Dimensional Models
  • Integrating Clickstream into Web Retailer’s Bus Matrix
  • Profitability Across Channels Including Web
  • Summary
  • 16. Insurance
  • Insurance Case Study
  • Policy Transactions
  • Premium Periodic Snapshot
  • More Insurance Case Study Background
  • Claim Transactions
  • Claim Accumulating Snapshot
  • Policy/Claim Consolidated Periodic Snapshot
  • Factless Accident Events
  • Common Dimensional Modeling Mistakes to Avoid
  • Summary
  • 17. Kimball DW/BI Lifecycle Overview
  • Lifecycle Roadmap
  • Lifecycle Launch Activities
  • Lifecycle Technology Track
  • Lifecycle Data Track
  • Lifecycle BI Applications Track
  • Lifecycle Wrap-up Activities
  • Common Pitfalls to Avoid
  • Summary
  • 18. Dimensional Modeling Process and Tasks
  • Modeling Process Overview
  • Get Organized
  • Design the Dimensional Model
  • Summary
  • 19. ETL Subsystems and Techniques
  • Round Up the Requirements
  • The 34 Subsystems of ETL
  • Extracting: Getting Data into the Data Warehouse
  • Cleaning and Conforming Data
  • Delivering: Prepare for Presentation
  • Managing the ETL Environment
  • Summary
  • 20. ETL System Design and Development Process and Tasks
  • ETL Process Overview
  • Develop the ETL Plan
  • Develop One-Time Historic Load Processing
  • Develop Incremental ETL Processing
  • Real-Time Implications
  • Summary
  • 21. Big Data Analytics
  • Big Data Overview
  • Recommended Best Practices for Big Data
  • Summary
  • Index

Ejemplares similares