The data warehouse toolkit : the definitive guide to dimensional modeling

Incluye índice

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