CHF47.00
Download est disponible immédiatement
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.
Auteur
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.
Résumé
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.
Contenu
Introduction xxvii
1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer 1
Different Worlds of Data Capture and Data Analysis 2
Goals of Data Warehousing and Business Intelligence 3
Dimensional Modeling Introduction 7
Kimball's DW/BI Architecture 18
Alternative DW/BI Architectures 26
Dimensional Modeling Myths 30
More Reasons to Think Dimensionally 32
Agile Considerations 34
Summary 35
2 Kimball Dimensional Modeling Techniques Overview 37
Fundamental Concepts 37
Basic Fact Table Techniques 41
Basic Dimension Table Techniques 46
Integration via Conformed Dimensions 50
Dealing with Slowly Changing Dimension Attributes 53
Dealing with Dimension Hierarchies 56
Advanced Fact Table Techniques 58
Advanced Dimension Techniques 62
Special Purpose Schemas 67
3 Retail Sales 69
Four-Step Dimensional Design Process 70
Retail Case Study 72
Dimension Table Details 79
Retail Schema in Action 94
Retail Schema Extensibility 95
Factless Fact Tables 97
Dimension and Fact Table Keys 98
Resisting Normalization Urges 104
Summary 109
4 Inventory 111
Value Chain Introduction 111
Inventory Models 112
Fact Table Types 119
Value Chain Integration 122
Enterprise Data Warehouse Bus Architecture 123
Conformed Dimensions 130
Conformed Facts 138
Summary 139
5 Procurement 141
Procurement Case Study 141
Procurement Transactions and Bus Matrix 142
Slowly Changing Dimension Basics 147
Hybrid Slowly Changing Dimension Techniques 159
Slowly Changing Dimension Recap 164
Summary 165
6 Order Management 167
Order Management Bus Matrix 168
Order Transactions 168
Invoice Transactions 187
Accumulating Snapshot for Order Fulfillment Pipeline 194
Summary 199
7 Accounting 201
Accounting Case Study and Bus Matrix 202
General Ledger Data 203
Budgeting Process 210
Dimension Attribute Hierarchies 214
Consolidated Fact Tables 224
Role of OLAP and Packaged Analytic Solutions 226
Summary 227
8 Customer Relationship Management 229
CRM Overview 230
Customer Dimension Attributes 233
Bridge Tables for Multivalued Dimensions 245
Complex Customer Behavior 249
Customer Data Integration Approaches 256
Low Latency Reality Check 260
Summary 261
9 Human Resources Management 263
Employee Profile Tracking 263
Headcount Periodic Snapshot 267
Bus Matrix for HR Processes 268
Packaged Analytic Solutions and Data Models 270
Recursive Employee Hierarchies 271
Multivalued Skill Keyword Attributes 274
Survey Questionnaire Data 277
Summary 279
10 Financial Services 281
Banking Case Study and Bus Matrix 282
Dimension Triage to Avoid Too Few Dimensions 283
Supertype and Subtype Schemas for Heterogeneous Products 293
Hot Swappable Dimensions 296
Summary 296
11 Telecommunications 297
Telecommunications Case Study and Bus Matrix 297
General Design Review Considerations 299
Design Review Guidelines 304
Draft Design Exercise Discussion 306
Remodeling Existing Data Structures 309 Geographic ...