The Data Warehouse Toolkit

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 realworld case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, ecommerce, 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.

InhaltsangabeIntroduction xxvii 1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer 1 2 Kimball Dimensional Modeling Techniques Overview 37 3 Retail Sales 69 4 Inventory 111 5 Procurement 141 6 Order Management 167 7 Accounting 201 8 Customer Relationship Management 229 9 Human Resources Management 263 10 Financial Service 281 11 Telecommunications 297 12 Transportation 311 13 Education 325 14 Healthcare 339 15 Electronic Commerce 353 16 Insurance 375 17 Kimball DW/BI Lifecycle Overview 403 18 Dimensional Modeling Process and Tasks 429 19 ETL Subsystems and Techniques 443 20 ETL System Design and Development Process and Tasks 497 21 Big Data Analytics 527 Index 543

Leseprobe