The Data Warehouse Toolkit
The Definitive Guide to Dimensional Modeling
3. Edition July 2013
608 Pages, Softcover
Practical Approach Book
Short Description
This revised and updated edition of the bestseller provides a complete library of dimensional modeling techniques, the most comprehensive collection ever written. New coverage features specific technologies for common business applications, including retail sales, inventory management, procurement, orders and invoices, customer relationship management, and accounting. Later chapters covers more advanced techniques for specific industries, including financial services, telecommunication and utilities, health care, insurance, and more. This text provides the benchmark reference for both novice and experienced data warehouse professionals.
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.
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
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.
