book

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

Name: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
ISBN: 9781118530801

by Ralph Kimball, Margy Ross

July 2013

Beginner to intermediate

600 pages

17h 31m

English

Wiley

Read now

Unlock full access

Cover
Introduction
Intended AudienceChapter PreviewWebsite ResourcesSummary
Chapter 1: Data Warehousing, Business Intelligence, and Dimensional Modeling Primer
Different Worlds of Data Capture and Data AnalysisGoals of Data Warehousing and Business IntelligenceDimensional Modeling IntroductionKimball's DW/BI ArchitectureAlternative DW/BI ArchitecturesDimensional Modeling MythsMore Reasons to Think DimensionallyAgile ConsiderationsSummary
Chapter 2: Kimball Dimensional Modeling Techniques Overview
Fundamental ConceptsBasic Fact Table TechniquesBasic Dimension Table TechniquesIntegration via Conformed DimensionsDealing with Slowly Changing Dimension AttributesDealing with Dimension HierarchiesAdvanced Fact Table TechniquesAdvanced Dimension TechniquesSpecial Purpose Schemas
Chapter 3: Retail Sales
Four-Step Dimensional Design ProcessRetail Case StudyDimension Table DetailsRetail Schema in ActionRetail Schema ExtensibilityFactless Fact TablesDimension and Fact Table KeysResisting Normalization UrgesSummary
Chapter 4: Inventory
Value Chain IntroductionInventory ModelsFact Table TypesValue Chain IntegrationEnterprise Data Warehouse Bus ArchitectureConformed DimensionsConformed FactsSummary
Chapter 5: Procurement
Procurement Case StudyProcurement Transactions and Bus MatrixSlowly Changing Dimension BasicsHybrid Slowly Changing Dimension TechniquesSlowly Changing Dimension RecapSummary
Chapter 6: Order Management
Order Management Bus MatrixOrder TransactionsInvoice TransactionsAccumulating Snapshot for Order Fulfillment PipelineSummary
Chapter 7: Accounting
Accounting Case Study and Bus MatrixGeneral Ledger DataBudgeting ProcessDimension Attribute HierarchiesConsolidated Fact TablesRole of OLAP and Packaged Analytic SolutionsSummary
Chapter 8: Customer Relationship Management
CRM OverviewCustomer Dimension AttributesBridge Tables for Multivalued DimensionsComplex Customer BehaviorCustomer Data Integration ApproachesLow Latency Reality CheckSummary

Chapter 9: Human Resources Management
Employee Profile TrackingHeadcount Periodic SnapshotBus Matrix for HR ProcessesPackaged Analytic Solutions and Data ModelsRecursive Employee HierarchiesMultivalued Skill Keyword AttributesSurvey Questionnaire DataSummary
Chapter 10: Financial Services
Banking Case Study and Bus MatrixDimension Triage to Avoid Too Few DimensionsSupertype and Subtype Schemas for Heterogeneous ProductsHot Swappable DimensionsSummary
Chapter 11: Telecommunications
Telecommunications Case Study and Bus MatrixGeneral Design Review ConsiderationsDesign Review GuidelinesDraft Design Exercise DiscussionRemodeling Existing Data StructuresGeographic Location DimensionSummary
Chapter 12: Transportation
Airline Case Study and Bus MatrixExtensions to Other IndustriesCombining Correlated DimensionsMore Date and Time ConsiderationsLocalization RecapSummary
Chapter 13: Education
University Case Study and Bus MatrixAccumulating Snapshot Fact TablesFactless Fact TablesMore Educational Analytic OpportunitiesSummary
Chapter 14: Healthcare
Healthcare Case Study and Bus MatrixClaims Billing and PaymentsElectronic Medical RecordsFacility/Equipment Inventory UtilizationDealing with Retroactive ChangesSummary
Chapter 15: Electronic Commerce
Clickstream Source DataClickstream Dimensional ModelsIntegrating Clickstream into Web Retailer's Bus MatrixProfitability Across Channels Including WebSummary
Chapter 16: Insurance
Insurance Case StudyPolicy TransactionsPremium Periodic SnapshotMore Insurance Case Study BackgroundClaim TransactionsClaim Accumulating SnapshotPolicy/Claim Consolidated Periodic SnapshotFactless Accident EventsCommon Dimensional Modeling Mistakes to AvoidSummary
Chapter 17: Kimball DW/BI Lifecycle Overview
Lifecycle RoadmapLifecycle Launch ActivitiesLifecycle Technology TrackLifecycle Data TrackLifecycle BI Applications TrackLifecycle Wrap-up ActivitiesCommon Pitfalls to AvoidSummary
Chapter 18: Dimensional Modeling Process and Tasks
Modeling Process OverviewGet OrganizedDesign the Dimensional ModelSummary
Chapter 19: ETL Subsystems and Techniques
Round Up the RequirementsThe 34 Subsystems of ETLExtracting: Getting Data into the Data WarehouseCleaning and Conforming DataDelivering: Prepare for PresentationManaging the ETL EnvironmentSummary
Chapter 20: ETL System Design and Development Process and Tasks
ETL Process OverviewDevelop the ETL PlanDevelop One-Time Historic Load ProcessingDevelop Incremental ETL ProcessingReal-Time ImplicationsSummary
Chapter 21: Big Data Analytics
Big Data OverviewRecommended Best Practices for Big DataSummary
Index
Advertisement

404

Not Found

Either this content does not exist or you do not have access to it. Try searching for something new.

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

by Ralph Kimball, Margy Ross

404

Not Found