The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

Front Cover
John Wiley & Sons, 2013 - Computers - 600 pages
1 Review

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.

 

What people are saying - Write a review

A must have.

User Review  - webgeek - Overstock.com

If youre doing anything with BI you must get this book. It lays a foundation for data warehousing which is an essential. Also this is not product specific and therefore will not get outdated. Read full review

Contents

Slowly Changing Dimension Manager
464
Surrogate Key Generator
469
Hierarchy Manager
470
Fact Table Builders
473
Surrogate Key Pipeline
475
Multivalued Dimension Bridge Table Builder
477
Late Arriving Data Handler
478
Dimension Manager System
479

Retail Sales
69
Inventory
111
Summary
139
Order Management
167
Accounting
201
Budgeting Process
210
Consolidated Fact Tables
224
Human Resources Management
263
Summary
279
Telecommunications
297
Transportation
311
Education
325
Healthcare
339
Electronic Commerce
353
Insurance
375
Factless Accident Events
396
Kimball DWBI Lifecycle Overview
403
Common Pitfalls to Avoid
426
Design the Dimensional Model
434
ETL Subsystems and Techniques
443
Data Latency
447
BI Delivery Interfaces
448
Legacy Licenses
449
Getting Data into the Data Warehouse
450
Change Data Capture System
451
Extract System
453
Cleaning and Conforming Data
455
Data Cleansing System
456
Error Event Schema
458
Audit Dimension Assembler
460
Conforming System
461
Prepare for Presentation
463
Fact Provider System
480
Aggregate Builder
481
Data Propagation Manager
482
Managing the ETL Environment
483
Backup System
485
Recovery and Restart System
486
Version Control System
488
Workflow Monitor
489
Sorting System
490
Problem Escalation System
491
ParallelizingPipelining System
492
Compliance Manager
493
Metadata Repository Manager
495
Summary
496
ETL System Design and Development Process and Tasks
497
Develop the ETL Plan
498
Choose an ETL Tool
499
Develop Default Strategies
500
Develop the ETL Specification Document
502
Develop OneTime Historic Load Processing
503
Perform the Fact Table Historic Load
508
Develop Incremental ETL Processing
512
Fact Table Incremental Processing
515
Aggregate Table and OLAP Loads
519
RealTime Implications
520
RealTime Triage
521
RealTime Architecture TradeOffs
522
RealTime Partitions in the Presentation Server
524
Summary
526
Big Data Analytics
527
Index
543
Copyright

Other editions - View all

Common terms and phrases

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