The Data Warehouse Toolkit, 3rd Edition

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

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.

Table of Contents

Chapter 1. Data Warehousing, Business Intelligence, and Dimensional Modeling Primer
Chapter 2. Kimball Dimensional Modeling Techniques Overview
Chapter 3. Retail Sales
Chapter 4. Inventory
Chapter 5. Procurement
Chapter 6. Order Management
Chapter 7. Accounting
Chapter 8. Customer Relationship Management
Chapter 9. Human Resources Management
Chapter 10. Financial Service
Chapter 11. Telecommunications
Chapter 12. Transportation
Chapter 13. Education
Chapter 14. Healthcare
Chapter 15. Electronic Commerce
Chapter 16. Insurance
Chapter 17. Kimball DW/BI Lifecycle Overview
Chapter 18. Dimensional Modeling Process and Tasks
Chapter 19. ETL Subsystems and Techniques
Chapter 20. ETL System Design and Development Process and Tasks
Chapter 21. Big Data Analytics