The data warehouse toolkit : the definitive guide to dimensional modeling / Ralph Kimball, Margy Ross.

Incluye índice.

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 - 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 - 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 - Inventory - Value chain introduction - Inventory models - Fact table types - Value chain integration - Enterprise data warehouse bus architecture - Conformed dimensions - Conformed facts - Procurement - Procurement case study - Procurement transactions and bus matrix - Slowly changing dimension basics - Hybrid slowly changing dimension techniques - Slowly changing dimension recap - Order management - Order management bus matrix - Order transactions - Invoice transactions - Accumulating snapshot for order fulfillment pipeline - 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 - Customer relationship management - CRM overview - Customer dimension attributes - Bridge tables for multivalued dimensions - Complex customer behavior - Customer data integration approaches - Low latency reality check - Human resources management - Employee profile 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 - Financial services - Banking case study and bus matrix - Dimension triage to avoid too few dimensions - Supertype and subtype schemas for heterogeneous products - Hot swappable dimensions – 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 - Transportation - Airline case study and bus matrix - Extensions to other industries - Combining correlated dimensions - More date and time considerations - Localization recap - Education - University case study and bus matrix - Accumulating snapshot fact tables - Factless fact tables - More educational analytic opportunities - Healthcare - Healthcare case study and bus matrix - Claims billing and payments - Electronic medical records - Facility/equipment inventory utilization - Dealing with retroactive changes - Electronic commerce - Clickstream source data - Clickstream dimensional models - Integrating clickstream into web retailer's bus matrix - Profitability across channels including web - 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 - Kimball dw/bi lifecycle overview - Lifecycle roadmap – Lifecycle launch activities - Lifecycle technology track - Lifecycle data track - Dimensional modeling process and tasks - Modeling process overview - ETL subsystems and techniques – ETL system design and development process and tasks - Big data analytics big data overview recommended best practices for big data summary index advertisement

M. de tecnología de la información