The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

Front Cover
John Wiley & Sons, Jul 1, 2013 - Computers - 608 pages

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!

The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.

  • Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence
  • Begins with fundamental design recommendations and progresses through increasingly complex scenarios
  • Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more
  • Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more

Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

 

Selected pages

Contents

Cover
Website Resources
Procurement
List of Illustrations
13
Retail Sales
1
10
Hot Swappable Dimensions
Matrix
Profitability Across Channels Including
Transportation
Education
Healthcare
1
Electronic Commerce

13
2
Inventory
Fact Table Types
Enterprise Data Warehouse Bus Architecture
1
ETL Subsystems and Techniques
1
Summary
Invoice Transactions
1
5
Accumulating Snapshot for Order Fulfillment
2
Summary
Human Resources Management
Financial Services
Customer Relationship Management
Customer Dimension Attributes
Insurance
Claim Accumulating Snapshot
1
Factless Accident Events
Kimball DWBI Lifecycle Overview
1
Dimensional Modeling Process and Tasks
1
1
ETL System Design and Development
Develop OneTime Historic Load Processing
Develop Incremental ETL Processing
RealTime Implications
Summary
Kimball Dimensional Modeling Techniques
Index

Other editions - View all

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Ralph Kimball,Margy Ross
Limited preview - 2013

Common terms and phrases

accumulating snapshot fact aggregate analytic applications attribute values bridge table bus matrix business process business users capture Chapter clickstream column conformed dimensions constrain create customer dimension Customer Relationship Management data governance data quality data warehouse data warehouse bus database date/time stamps degenerate dimension denormalized detailed dimension attributes dimension row dimension table dimensional model DW/BI environment DW/BI system enterprise data warehouse ETL process ETL system event example fact row fact table row foreign keys grain granularity handling hierarchy identify illustrated in Figure integration inventory Kimball line item load measurement metrics mini-dimension multiple natural key OLAP cubes operational source organization organization’s outrigger performance periodic snapshot pipeline primary key product dimension query requirements schema separate session shown in Figure single slowly changing dimension snapshot fact table source data source system star schema surrogate key there’s transaction fact table typically updated

About the author (2013)

RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996.

MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years.

Bibliographic information

TitleThe Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
AuthorsRalph Kimball, Margy Ross
Edition3
PublisherJohn Wiley & Sons, 2013
ISBN1118732286, 9781118732281
Length608 pages
Subjects ›  › 

Computers / Data Science / Data Warehousing
Computers / Information Technology
Computers / Networking / General
  
Export CitationBiBTeX EndNote RefMan