{"product_id":"the-kimball-group-reader-isbn-9781119216315","title":"The Kimball Group Reader","description":"\u003cb\u003eThe final edition of the incomparable data warehousing and business intelligence reference, updated and expanded\u003c\/b\u003e \u003cp\u003e\u003ci\u003eThe Kimball Group Reader, Remastered Collection\u003c\/i\u003e is the essential reference for data warehouse and business intelligence design, packed with best practices, design tips, and valuable insight from industry pioneer Ralph Kimball and the Kimball Group. This Remastered Collection represents decades of expert advice and mentoring in data warehousing and business intelligence, and is the final work to be published by the Kimball Group. Organized for quick navigation and easy reference, this book contains nearly 20 years of experience on more than 300 topics, all fully up-to-date and expanded with 65 new articles. The discussion covers the complete data warehouse\/business intelligence lifecycle, including project planning, requirements gathering, system architecture, dimensional modeling, ETL, and business intelligence analytics, with each group of articles prefaced by original commentaries explaining their role in the overall Kimball Group methodology. \u003c\/p\u003e\u003cp\u003eData warehousing\/business intelligence industry's current multi-billion dollar value is due in no small part to the contributions of Ralph Kimball and the Kimball Group. Their publications are the standards on which the industry is built, and nearly all data warehouse hardware and software vendors have adopted their methods in one form or another. This book is a compendium of Kimball Group expertise, and an essential reference for anyone in the field. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eLearn data warehousing and business intelligence from the field's pioneers\u003c\/li\u003e \u003cli\u003eGet up to date on best practices and essential design tips\u003c\/li\u003e \u003cli\u003eGain valuable knowledge on every stage of the project lifecycle\u003c\/li\u003e \u003cli\u003eDig into the Kimball Group methodology with hands-on guidance\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eRalph Kimball and the Kimball Group have continued to refine their methods and techniques based on thousands of hours of consulting and training. This Remastered Collection of \u003ci\u003eThe Kimball Group Reader\u003c\/i\u003e represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field. \u003c\/p\u003e\u003cp\u003eIntroduction xxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 \u003c\/b\u003e\u003cb\u003eThe \u003ci\u003eReader \u003c\/i\u003eat a Glance 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetting Up for Success 1\u003c\/p\u003e \u003cp\u003e1.1 Resist the Urge to Start Coding 1\u003c\/p\u003e \u003cp\u003e1.2 Set Your Boundaries 4\u003c\/p\u003e \u003cp\u003eTackling DW\/BI Design and Development 6\u003c\/p\u003e \u003cp\u003e1.3 Data Wrangling 6\u003c\/p\u003e \u003cp\u003e1.4 Myth Busters 9\u003c\/p\u003e \u003cp\u003e1.5 Dividing the World 10\u003c\/p\u003e \u003cp\u003e1.6 Essential Steps for the Integrated Enterprise Data Warehouse 13\u003c\/p\u003e \u003cp\u003e1.7 Drill Down to Ask Why 22\u003c\/p\u003e \u003cp\u003e1.8 Slowly Changing Dimensions 25\u003c\/p\u003e \u003cp\u003e1.9 Judge Your BI Tool through Your Dimensions 28\u003c\/p\u003e \u003cp\u003e1.10 Fact Tables 31\u003c\/p\u003e \u003cp\u003e1.11 Exploit Your Fact Tables 33\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 \u003c\/b\u003e\u003cb\u003eBefore You Dive In 35\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBefore Data Warehousing 35\u003c\/p\u003e \u003cp\u003e2.1 History Lesson on Ralph Kimball and Xerox PARC 36\u003c\/p\u003e \u003cp\u003eHistorical Perspective 37\u003c\/p\u003e \u003cp\u003e2.2 The Database Market Splits 37\u003c\/p\u003e \u003cp\u003e2.3 Bringing Up Supermarts 40\u003c\/p\u003e \u003cp\u003eDealing with Demanding Realities 47\u003c\/p\u003e \u003cp\u003e2.4 Brave New Requirements for Data Warehousing 47\u003c\/p\u003e \u003cp\u003e2.5 Coping with the Brave New Requirements 52\u003c\/p\u003e \u003cp\u003e2.6 Stirring Things Up 57\u003c\/p\u003e \u003cp\u003e2.7 Design Constraints and Unavoidable Realities 60\u003c\/p\u003e \u003cp\u003e2.8 Two Powerful Ideas 64\u003c\/p\u003e \u003cp\u003e2.9 Data Warehouse Dining Experience 67\u003c\/p\u003e \u003cp\u003e2.10 Easier Approaches for Harder Problems 70\u003c\/p\u003e \u003cp\u003e2.11 Expanding Boundaries of the Data Warehouse 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 \u003c\/b\u003e\u003cb\u003eProject\/Program Planning 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eProfessional Responsibilities 75\u003c\/p\u003e \u003cp\u003e3.1 Professional Boundaries 75\u003c\/p\u003e \u003cp\u003e3.2 An Engineer’s View 78\u003c\/p\u003e \u003cp\u003e3.3 Beware the Objection Removers 82\u003c\/p\u003e \u003cp\u003e3.4 What Does the Central Team Do? 86\u003c\/p\u003e \u003cp\u003e3.5 Avoid Isolating DW and BI Teams 90\u003c\/p\u003e \u003cp\u003e3.6 Better Business Skills for BI and Data Warehouse Professionals 91\u003c\/p\u003e \u003cp\u003e3.7 Risky Project Resources are Risky Business 93\u003c\/p\u003e \u003cp\u003e3.8 Implementation Analysis Paralysis 95\u003c\/p\u003e \u003cp\u003e3.9 Contain DW\/BI Scope Creep and Avoid Scope Theft 96\u003c\/p\u003e \u003cp\u003e3.10 Are IT Procedures Beneficial to DW\/BI Projects? 98\u003c\/p\u003e \u003cp\u003eJustification and Sponsorship 100\u003c\/p\u003e \u003cp\u003e3.11 Habits of Effective Sponsors 100\u003c\/p\u003e \u003cp\u003e3.12 TCO Starts with the End User 103\u003c\/p\u003e \u003cp\u003eKimball Methodology 108\u003c\/p\u003e \u003cp\u003e3.13 Kimball Lifecycle in a Nutshell 108\u003c\/p\u003e \u003cp\u003e3.14 Off the Bench111\u003c\/p\u003e \u003cp\u003e3.15 The Anti-Architect112\u003c\/p\u003e \u003cp\u003e3.16 Think Critically When Applying Best Practices 115\u003c\/p\u003e \u003cp\u003e3.17 Eight Guidelines for Low Risk Enterprise Data Warehousing 118\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 \u003c\/b\u003e\u003cb\u003eRequirements Definition 123\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGathering Requirements 123\u003c\/p\u003e \u003cp\u003e4.1 Alan Alda’s Interviewing Tips for Uncovering Business Requirements 123\u003c\/p\u003e \u003cp\u003e4.2 More Business Requirements Gathering Dos and Don’ts 127\u003c\/p\u003e \u003cp\u003e4.3 Balancing Requirements and Realities 129\u003c\/p\u003e \u003cp\u003e4.4 Overcoming Obstacles When Gathering Business Requirements 130\u003c\/p\u003e \u003cp\u003e4.5 Surprising Value of Data Profiling 133\u003c\/p\u003e \u003cp\u003eOrganizing around Business Processes 134\u003c\/p\u003e \u003cp\u003e4.6 Focus on Business Processes, Not Business Departments! 134\u003c\/p\u003e \u003cp\u003e4.7 Identifying Business Processes 135\u003c\/p\u003e \u003cp\u003e4.8 Business Process Decoder Ring 137\u003c\/p\u003e \u003cp\u003e4.9 Relationship between Strategic Business Initiatives and Business Processes 138\u003c\/p\u003e \u003cp\u003eWrapping Up the Requirements 139\u003c\/p\u003e \u003cp\u003e4.10 The Bottom-Up Misnomer 140\u003c\/p\u003e \u003cp\u003e4.11 Think Dimensionally (Beyond Data Modeling) 144\u003c\/p\u003e \u003cp\u003e4.12 Using the Dimensional Model to Validate Business Requirements 145\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 \u003c\/b\u003e\u003cb\u003eData Architecture 147\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaking the Case for Dimensional Modeling 147\u003c\/p\u003e \u003cp\u003e5.1 Is ER Modeling Hazardous to DSS? 147\u003c\/p\u003e \u003cp\u003e5.2 A Dimensional Modeling Manifesto 151\u003c\/p\u003e \u003cp\u003e5.3 There are No Guarantees 159\u003c\/p\u003e \u003cp\u003eEnterprise Data Warehouse Bus Architecture 163\u003c\/p\u003e \u003cp\u003e5.4 Divide and Conquer 163\u003c\/p\u003e \u003cp\u003e5.5 The Matrix 166\u003c\/p\u003e \u003cp\u003e5.6 The Matrix: Revisited 170\u003c\/p\u003e \u003cp\u003e5.7 Drill Down into a Detailed Bus Matrix 174\u003c\/p\u003e \u003cp\u003eAgile Project Considerations 176\u003c\/p\u003e \u003cp\u003e5.8 Relating to Agile Methodologies 176\u003c\/p\u003e \u003cp\u003e5.9 Is Agile Enterprise Data Warehousing an Oxymoron? 177\u003c\/p\u003e \u003cp\u003e5.10 Going Agile? Start with the Bus Matrix 179\u003c\/p\u003e \u003cp\u003e5.11 Conformed Dimensions as the Foundation for Agile Data Warehousing 180\u003c\/p\u003e \u003cp\u003eIntegration Instead of Centralization 181\u003c\/p\u003e \u003cp\u003e5.12 Integration for Real People 181\u003c\/p\u003e \u003cp\u003e5.13 Build a Ready-to-Go Resource for Enterprise Dimensions 185\u003c\/p\u003e \u003cp\u003e5.14 Data Stewardship 101: The First Step to Quality and Consistency 186\u003c\/p\u003e \u003cp\u003e5.15 To Be or Not To Be Centralized 189\u003c\/p\u003e \u003cp\u003eContrast with the Corporate Information Factory 192\u003c\/p\u003e \u003cp\u003e5.16 Differences of Opinion 193\u003c\/p\u003e \u003cp\u003e5.17 Much Ado about Nothing 198\u003c\/p\u003e \u003cp\u003e5.18 Don’t Support Business Intelligence with a Normalized EDW 199\u003c\/p\u003e \u003cp\u003e5.19 Complementing 3NF EDWs with Dimensional Presentation Areas 201\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 \u003c\/b\u003e\u003cb\u003eDimensional Modeling Fundamentals 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasics of Dimensional Modeling 203\u003c\/p\u003e \u003cp\u003e6.1 Fact Tables and Dimension Tables 203\u003c\/p\u003e \u003cp\u003e6.2 Drilling Down, Up, and Across 207\u003c\/p\u003e \u003cp\u003e6.3 The Soul of the Data Warehouse, Part One: Drilling Down 210\u003c\/p\u003e \u003cp\u003e6.4 The Soul of the Data Warehouse, Part Two: Drilling Across 213\u003c\/p\u003e \u003cp\u003e6.5 The Soul of the Data Warehouse, Part Three: Handling Time 216\u003c\/p\u003e \u003cp\u003e6.6 Graceful Modifications to Existing Fact and Dimension Tables 219\u003c\/p\u003e \u003cp\u003eDos and Don’ts 220\u003c\/p\u003e \u003cp\u003e6.7 Kimball’s Ten Essential Rules of Dimensional Modeling 221\u003c\/p\u003e \u003cp\u003e6.8 What Not to Do 223\u003c\/p\u003e \u003cp\u003eMyths about Dimensional Modeling 226\u003c\/p\u003e \u003cp\u003e6.9 Dangerous Preconceptions 226\u003c\/p\u003e \u003cp\u003e6.10 Fables and Facts 228\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 \u003c\/b\u003e\u003cb\u003eDimensional Modeling Tasks and Responsibilities 233\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDesign Activities 233\u003c\/p\u003e \u003cp\u003e7.1 Letting the Users Sleep 233\u003c\/p\u003e \u003cp\u003e7.2 Practical Steps for Designing a Dimensional Model 240\u003c\/p\u003e \u003cp\u003e7.3 Staffing the Dimensional Modeling Team 243\u003c\/p\u003e \u003cp\u003e7.4 Involve Business Representatives in Dimensional Modeling 244\u003c\/p\u003e \u003cp\u003e7.5 Managing Large Dimensional Design Teams 246\u003c\/p\u003e \u003cp\u003e7.6 Use a Design Charter to Keep Dimensional Modeling Activities on Track 248\u003c\/p\u003e \u003cp\u003e7.7 The Naming Game 249\u003c\/p\u003e \u003cp\u003e7.8 What’s in a Name? 250\u003c\/p\u003e \u003cp\u003e7.9 When is the Dimensional Design Done? 253\u003c\/p\u003e \u003cp\u003eDesign Review Activities 254\u003c\/p\u003e \u003cp\u003e7.10 Design Review Dos and Don’ts 255\u003c\/p\u003e \u003cp\u003e7.11 Fistful of Flaws 257\u003c\/p\u003e \u003cp\u003e7.12 Rating Your Dimensional Data Warehouse 260\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 \u003c\/b\u003e\u003cb\u003eFact Table Core Concepts 267\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGranularity 267\u003c\/p\u003e \u003cp\u003e8.1 Declaring the Grain 267\u003c\/p\u003e \u003cp\u003e8.2 Keep to the Grain in Dimensional Modeling 270\u003c\/p\u003e \u003cp\u003e8.3 Warning: Summary Data May Be Hazardous to Your Health 272\u003c\/p\u003e \u003cp\u003e8.4 No Detail Too Small 273\u003c\/p\u003e \u003cp\u003eTypes of Fact Tables 276\u003c\/p\u003e \u003cp\u003e8.5 Fundamental Grains 277\u003c\/p\u003e \u003cp\u003e8.6 Modeling a Pipeline with an Accumulating Snapshot 280\u003c\/p\u003e \u003cp\u003e8.7 Combining Periodic and Accumulating Snapshots 282\u003c\/p\u003e \u003cp\u003e8.8 Complementary Fact Table Types 284\u003c\/p\u003e \u003cp\u003e8.9 Modeling Time Spans 286\u003c\/p\u003e \u003cp\u003e8.10 A Rolling Prediction of the Future, Now and in the Past 289\u003c\/p\u003e \u003cp\u003e8.11 Timespan Accumulating Snapshot Fact Tables 293\u003c\/p\u003e \u003cp\u003e8.12 Is it a Dimension, a Fact, or Both? 294\u003c\/p\u003e \u003cp\u003e8.13 Factless Fact Tables 295\u003c\/p\u003e \u003cp\u003e8.14 Factless Fact Tables? Sounds Like Jumbo Shrimp? 298\u003c\/p\u003e \u003cp\u003e8.15 What Didn’t Happen 299\u003c\/p\u003e \u003cp\u003e8.16 Factless Fact Tables for Simplification 302\u003c\/p\u003e \u003cp\u003eParent-Child Fact Tables 304\u003c\/p\u003e \u003cp\u003e8.17 Managing Your Parents 304\u003c\/p\u003e \u003cp\u003e8.18 Patterns to Avoid When Modeling Header\/Line Item Transactions 307\u003c\/p\u003e \u003cp\u003eFact Table Keys and Degenerate Dimensions 309\u003c\/p\u003e \u003cp\u003e8.19 Fact Table Surrogate Keys 309\u003c\/p\u003e \u003cp\u003e8.20 Reader Suggestions on Fact Table Surrogate Keys 310\u003c\/p\u003e \u003cp\u003e8.21 Another Look at Degenerate Dimensions 312\u003c\/p\u003e \u003cp\u003e8.22 Creating a Reference Dimension for Infrequently Accessed Degenerates 313\u003c\/p\u003e \u003cp\u003eMiscellaneous Fact Table Design Patterns 314\u003c\/p\u003e \u003cp\u003e8.23 Put Your Fact Tables on a Diet 314\u003c\/p\u003e \u003cp\u003e8.24 Keeping Text Out of the Fact Table 316\u003c\/p\u003e \u003cp\u003e8.25 Dealing with Nulls in a Dimensional Model 317\u003c\/p\u003e \u003cp\u003e8.26 Modeling Data as Both a Fact and Dimension Attribute 318\u003c\/p\u003e \u003cp\u003e8.27 When a Fact Table Can Be Used as a Dimension Table 319\u003c\/p\u003e \u003cp\u003e8.28 Sparse Facts and Facts with Short Lifetimes 321\u003c\/p\u003e \u003cp\u003e8.29 Pivoting the Fact Table with a Fact Dimension 323\u003c\/p\u003e \u003cp\u003e8.30 Accumulating Snapshots for Complex Workflows 324\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 \u003c\/b\u003e\u003cb\u003eDimension Table Core Concepts 327\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDimension Table Keys 327\u003c\/p\u003e \u003cp\u003e9.1 Surrogate Keys 327\u003c\/p\u003e \u003cp\u003e9.2 Keep Your Keys Simple 331\u003c\/p\u003e \u003cp\u003e9.3 Durable “Super-Natural” Keys 333\u003c\/p\u003e \u003cp\u003eDate and Time Dimension Considerations 334\u003c\/p\u003e \u003cp\u003e9.4 It’s Time for Time 335\u003c\/p\u003e \u003cp\u003e9.5 Surrogate Keys for the Time Dimension 337\u003c\/p\u003e \u003cp\u003e9.6 Latest Thinking on Time Dimension Tables 339\u003c\/p\u003e \u003cp\u003e9.7 Smart Date Keys to Partition Fact Tables 341\u003c\/p\u003e \u003cp\u003e9.8 Updating the Date Dimension 342\u003c\/p\u003e \u003cp\u003e9.9 Handling All the Dates 343\u003c\/p\u003e \u003cp\u003eMiscellaneous Dimension Patterns 345\u003c\/p\u003e \u003cp\u003e9.10 Selecting Default Values for Nulls 345\u003c\/p\u003e \u003cp\u003e9.11 Data Warehouse Role Models 347\u003c\/p\u003e \u003cp\u003e9.12 Mystery Dimensions 350\u003c\/p\u003e \u003cp\u003e9.13 De-Clutter with Junk Dimensions 353\u003c\/p\u003e \u003cp\u003e9.14 Showing the Correlation between Dimensions 354\u003c\/p\u003e \u003cp\u003e9.15 Causal (Not Casual) Dimensions 356\u003c\/p\u003e \u003cp\u003e9.16 Resist Abstract Generic Dimensions 359\u003c\/p\u003e \u003cp\u003e9.17 Hot-Swappable Dimensions 360\u003c\/p\u003e \u003cp\u003e9.18 Accurate Counting with a Dimensional Supplement 361\u003c\/p\u003e \u003cp\u003eSlowly Changing Dimensions 363\u003c\/p\u003e \u003cp\u003e9.19 Perfectly Partitioning History with Type 2 SCD 363\u003c\/p\u003e \u003cp\u003e9.20 Many Alternate Realities 364\u003c\/p\u003e \u003cp\u003e9.21 Monster Dimensions 367\u003c\/p\u003e \u003cp\u003e9.22 When a Slowly Changing Dimension Speeds Up 370\u003c\/p\u003e \u003cp\u003e9.23 When Do Dimensions Become Dangerous? 372\u003c\/p\u003e \u003cp\u003e9.24 Slowly Changing Dimensions are Not Always as Easy as 1, 2, and 3 373\u003c\/p\u003e \u003cp\u003e9.25 Slowly Changing Dimension Types 0, 4, 5, 6 and 7 378\u003c\/p\u003e \u003cp\u003e9.26 Dimension Row Change Reason Attributes 382\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 \u003c\/b\u003e\u003cb\u003eMore Dimension Patterns and Considerations 385\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSnowflakes, Outriggers, and Bridges 385\u003c\/p\u003e \u003cp\u003e10.1 Snowflakes, Outriggers, and Bridges 385\u003c\/p\u003e \u003cp\u003e10.2 A Trio of Interesting Snowflakes 388\u003c\/p\u003e \u003cp\u003e10.3 Help for Dimensional Modeling 392\u003c\/p\u003e \u003cp\u003e10.4 Managing Bridge Tables 395\u003c\/p\u003e \u003cp\u003e10.5 The Keyword Dimension 399\u003c\/p\u003e \u003cp\u003e10.6 Potential Bridge (Table) Detours 403\u003c\/p\u003e \u003cp\u003e10.7 Alternatives for Multi-Valued Dimensions 405\u003c\/p\u003e \u003cp\u003e10.8 Adding a Mini-Dimension to a Bridge Table 407\u003c\/p\u003e \u003cp\u003eDealing with Hierarchies 409\u003c\/p\u003e \u003cp\u003e10.9 Maintaining Dimension Hierarchies 409\u003c\/p\u003e \u003cp\u003e10.10 Help for Hierarchies 414\u003c\/p\u003e \u003cp\u003e10.11 Five Alternatives for Better Employee Dimensional Modeling 417\u003c\/p\u003e \u003cp\u003e10.12 Avoiding Alternate Organization Hierarchies 425\u003c\/p\u003e \u003cp\u003e10.13 Alternate Hierarchies 426\u003c\/p\u003e \u003cp\u003eCustomer Issues 427\u003c\/p\u003e \u003cp\u003e10.14 Dimension Embellishments 427\u003c\/p\u003e \u003cp\u003e10.15 Wrangling Behavior Tags 429\u003c\/p\u003e \u003cp\u003e10.16 Three Ways to Capture Customer Satisfaction 431\u003c\/p\u003e \u003cp\u003e10.17 Extreme Status Tracking for Real-Time Customer Analysis 435\u003c\/p\u003e \u003cp\u003eAddresses and International Issues 439\u003c\/p\u003e \u003cp\u003e10.18 Think Globally, Act Locally 439\u003c\/p\u003e \u003cp\u003e10.19 Warehousing without Borders 443\u003c\/p\u003e \u003cp\u003e10.20 Spatially Enabling Your Data Warehouse 448\u003c\/p\u003e \u003cp\u003e10.21 Multinational Dimensional Data Warehouse Considerations 452\u003c\/p\u003e \u003cp\u003eIndustry Scenarios and Idiosyncrasies 453\u003c\/p\u003e \u003cp\u003e10.22 Industry Standard Data Models Fall Short 453\u003c\/p\u003e \u003cp\u003e10.23 An Insurance Data Warehouse Case Study 455\u003c\/p\u003e \u003cp\u003e10.24 Traveling through Databases 460\u003c\/p\u003e \u003cp\u003e10.25 Human Resources Dimensional Models 463\u003c\/p\u003e \u003cp\u003e10.26 Managing Backlogs Dimensionally 467\u003c\/p\u003e \u003cp\u003e10.27 Not So Fast 468\u003c\/p\u003e \u003cp\u003e10.28 The Budgeting Chain 471\u003c\/p\u003e \u003cp\u003e10.29 Compliance-Enabled Data Warehouses 475\u003c\/p\u003e \u003cp\u003e10.30 Clicking with Your Customer 477\u003c\/p\u003e \u003cp\u003e10.31 The Special Dimensions of the Clickstream 482\u003c\/p\u003e \u003cp\u003e10.32 Fact Tables for Text Document Searching 485\u003c\/p\u003e \u003cp\u003e10.33 Enabling Market Basket Analysis 489\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 \u003c\/b\u003e\u003cb\u003eBack Room ETL and Data Quality 495\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePlanning the ETL System 495\u003c\/p\u003e \u003cp\u003e11.1 Surrounding the ETL Requirements 495\u003c\/p\u003e \u003cp\u003e11.2 The 34 Subsystems of ETL 500\u003c\/p\u003e \u003cp\u003e11.3 Six Key Decisions for ETL Architectures 504\u003c\/p\u003e \u003cp\u003e11.4 Three ETL Compromises to Avoid 508\u003c\/p\u003e \u003cp\u003e11.5 Doing the Work at Extract Time 510\u003c\/p\u003e \u003cp\u003e11.6 Is Data Staging Relational? 513\u003c\/p\u003e \u003cp\u003e11.7 Staging Areas and ETL Tools 517\u003c\/p\u003e \u003cp\u003e11.8 Should You Use an ETL Tool? 518\u003c\/p\u003e \u003cp\u003e11.9 Call to Action for ETL Tool Providers 521\u003c\/p\u003e \u003cp\u003e11.10 Document the ETL System 522\u003c\/p\u003e \u003cp\u003e11.11 Measure Twice, Cut Once 523\u003c\/p\u003e \u003cp\u003e11.12 Brace for Incoming 527\u003c\/p\u003e \u003cp\u003e11.13 Building a Change Data Capture System 530\u003c\/p\u003e \u003cp\u003e11.14 Disruptive ETL Changes 531\u003c\/p\u003e \u003cp\u003e11.15 New Directions for ETL 533\u003c\/p\u003e \u003cp\u003eData Quality Considerations 535\u003c\/p\u003e \u003cp\u003e11.16 Dealing With Data Quality: Don’t Just Sit There, Do Something! 535\u003c\/p\u003e \u003cp\u003e11.17 Data Warehouse Testing Recommendations 537\u003c\/p\u003e \u003cp\u003e11.18 Dealing with Dirty Data 539\u003c\/p\u003e \u003cp\u003e11.19 An Architecture for Data Quality 545\u003c\/p\u003e \u003cp\u003e11.20 Indicators of Quality: The Audit Dimension 553\u003c\/p\u003e \u003cp\u003e11.21 Adding an Audit Dimension to Track Lineage and Confi dence 556\u003c\/p\u003e \u003cp\u003e11.22 Add Uncertainty to Your Fact Table 559\u003c\/p\u003e \u003cp\u003e11.23 Have You Built Your Audit Dimension Yet? 560\u003c\/p\u003e \u003cp\u003e11.24 Is Your Data Correct? 562\u003c\/p\u003e \u003cp\u003e11.25 Eight Recommendations for International Data Quality 565\u003c\/p\u003e \u003cp\u003e11.26 Using Regular Expressions for Data Cleaning 568\u003c\/p\u003e \u003cp\u003ePopulating Fact and Dimension Tables 572\u003c\/p\u003e \u003cp\u003e11.27 Pipelining Your Surrogates 572\u003c\/p\u003e \u003cp\u003e11.28 Unclogging the Fact Table Surrogate Key Pipeline 576\u003c\/p\u003e \u003cp\u003e11.29 Replicating Dimensions Correctly 579\u003c\/p\u003e \u003cp\u003e11.30 Identify Dimension Changes Using Cyclic Redundancy Checksums 580\u003c\/p\u003e \u003cp\u003e11.31 Maintaining Back Pointers to Operational Sources 581\u003c\/p\u003e \u003cp\u003e11.32 Creating Historical Dimension Rows 582\u003c\/p\u003e \u003cp\u003e11.33 Facing the Re-Keying Crisis 585\u003c\/p\u003e \u003cp\u003e11.34 Backward in Time 587\u003c\/p\u003e \u003cp\u003e11.35 Early-Arriving Facts 590\u003c\/p\u003e \u003cp\u003e11.36 Slowly Changing Entities 591\u003c\/p\u003e \u003cp\u003e11.37 Using the SQL MERGE Statement for Slowly Changing Dimensions 593\u003c\/p\u003e \u003cp\u003e11.38 Creating and Managing Shrunken Dimensions 595\u003c\/p\u003e \u003cp\u003e11.39 Creating and Managing Mini-Dimensions 597\u003c\/p\u003e \u003cp\u003e11.40 Creating, Using, and Maintaining Junk Dimensions 599\u003c\/p\u003e \u003cp\u003e11.41 Building Bridges 601\u003c\/p\u003e \u003cp\u003e11.42 Being Offl ine as Little as Possible 605\u003c\/p\u003e \u003cp\u003eSupporting Real Time 606\u003c\/p\u003e \u003cp\u003e11.43 Working in Web Time 606\u003c\/p\u003e \u003cp\u003e11.44 Real-Time Partitions 610\u003c\/p\u003e \u003cp\u003e11.45 The Real-Time Triage 613\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 \u003c\/b\u003e\u003cb\u003eTechnical Architecture Considerations 617\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverall Technical\/System Architecture 617\u003c\/p\u003e \u003cp\u003e12.1 Can the Data Warehouse Benefi t from SOA? 617\u003c\/p\u003e \u003cp\u003e12.2 Picking the Right Approach to MDM 619\u003c\/p\u003e \u003cp\u003e12.3 Building Custom Tools for the DW\/BI System 625\u003c\/p\u003e \u003cp\u003e12.4 Welcoming the Packaged App 626\u003c\/p\u003e \u003cp\u003e12.5 ERP Vendors: Bring Down Those Walls 629\u003c\/p\u003e \u003cp\u003e12.6 Building a Foundation for Smart Applications 632\u003c\/p\u003e \u003cp\u003e12.7 RFID Tags and Smart Dust 637\u003c\/p\u003e \u003cp\u003e12.8 Is Big Data Compatible with the Data Warehouse? 640\u003c\/p\u003e \u003cp\u003e12.9 The Evolving Role of the Enterprise Data Warehouse in the Era of Big Data Analytics 641\u003c\/p\u003e \u003cp\u003e12.10 Newly Emerging Best Practices for Big Data 659\u003c\/p\u003e \u003cp\u003e12.11 The Hyper-Granular Active Archive 670\u003c\/p\u003e \u003cp\u003ePresentation Server Architecture 672\u003c\/p\u003e \u003cp\u003e12.12 Columnar Databases: Game Changers for DW\/BI Deployment 672\u003c\/p\u003e \u003cp\u003e12.13 There is no Database Magic 673\u003c\/p\u003e \u003cp\u003e12.14 Relating to OLAP 676\u003c\/p\u003e \u003cp\u003e12.15 Dimensional Relational versus OLAP: The Final Deployment Conundrum 679\u003c\/p\u003e \u003cp\u003e12.16 Microsoft SQL Server Comes of Age for Data Warehousing 682\u003c\/p\u003e \u003cp\u003e12.17 The Aggregate Navigator 686\u003c\/p\u003e \u003cp\u003e12.18 Aggregate Navigation with (Almost) No Metadata 690\u003c\/p\u003e \u003cp\u003eFront Room Architecture 697\u003c\/p\u003e \u003cp\u003e12.19 The Second Revolution of User Interfaces 697\u003c\/p\u003e \u003cp\u003e12.20 Designing the User Interface 700\u003c\/p\u003e \u003cp\u003eMetadata 704\u003c\/p\u003e \u003cp\u003e12.21 Meta Meta Data Data 704\u003c\/p\u003e \u003cp\u003e12.22 Creating the Metadata Strategy 708\u003c\/p\u003e \u003cp\u003e12.23 Leverage Process Metadata for Self-Monitoring DW Operations 709\u003c\/p\u003e \u003cp\u003eInfrastructure and Security Considerations 712\u003c\/p\u003e \u003cp\u003e12.24 Watching the Watchers 712\u003c\/p\u003e \u003cp\u003e12.25 Catastrophic Failure 716\u003c\/p\u003e \u003cp\u003e12.26 Digital Preservation 719\u003c\/p\u003e \u003cp\u003e12.27 Creating the Advantages of a 64-Bit Server 722\u003c\/p\u003e \u003cp\u003e12.28 Server Configuration Considerations 723\u003c\/p\u003e \u003cp\u003e12.29 Adjust Your Thinking for SANs 726\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 \u003c\/b\u003e\u003cb\u003eFront Room Business Intelligence Applications 729\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDelivering Value with Business Intelligence 729\u003c\/p\u003e \u003cp\u003e13.1 The Promise of Decision Support 730\u003c\/p\u003e \u003cp\u003e13.2 Beyond Paving the Cow Paths 733\u003c\/p\u003e \u003cp\u003e13.3 BI Components for Business Value 736\u003c\/p\u003e \u003cp\u003e13.4 Big Shifts Happening in BI 738\u003c\/p\u003e \u003cp\u003e13.5 Behavior: The Next Marquee Application 740\u003c\/p\u003e \u003cp\u003eImplementing the Business Intelligence Layer 743\u003c\/p\u003e \u003cp\u003e13.6 Three Critical Components for Successful Self-Service BI 743\u003c\/p\u003e \u003cp\u003e13.7 Leverage Data Visualization Tools, But Avoid Anarchy 745\u003c\/p\u003e \u003cp\u003e13.8 Think Like a Software Development Manager 747\u003c\/p\u003e \u003cp\u003e13.9 Standard Reports: Basics for Business Users 748\u003c\/p\u003e \u003cp\u003e13.10 Building and Delivering BI Reports 753\u003c\/p\u003e \u003cp\u003e13.11 The BI Portal 757\u003c\/p\u003e \u003cp\u003e13.12 Dashboards Done Right 759\u003c\/p\u003e \u003cp\u003e13.13 Don’t Be Overly Reliant on Your Data Access Tool’s Metadata 760\u003c\/p\u003e \u003cp\u003e13.14 Making Sense of the Semantic Layer 762\u003c\/p\u003e \u003cp\u003eMining Data to Uncover Relationships 764\u003c\/p\u003e \u003cp\u003e13.15 Digging into Data Mining 764\u003c\/p\u003e \u003cp\u003e13.16 Preparing for Data Mining 766\u003c\/p\u003e \u003cp\u003e13.17 The Perfect Handoff 770\u003c\/p\u003e \u003cp\u003e13.18 Get Started with Data Mining Now 774\u003c\/p\u003e \u003cp\u003e13.19 Leverage Your Dimensional Model for Predictive Analytics 778\u003c\/p\u003e \u003cp\u003e13.20 Does Your Organization Need an Analytic Sandbox? 779\u003c\/p\u003e \u003cp\u003eDealing with SQL 781\u003c\/p\u003e \u003cp\u003e13.21 Simple Drill Across in SQL 781\u003c\/p\u003e \u003cp\u003e13.22 An Excel Macro for Drilling Across 783\u003c\/p\u003e \u003cp\u003e13.23 The Problem with Comparisons 785\u003c\/p\u003e \u003cp\u003e13.24 SQL Roadblocks and Pitfalls 789\u003c\/p\u003e \u003cp\u003e13.25 Features for Query Tools 792\u003c\/p\u003e \u003cp\u003e13.26 Turbocharge Your Query Tools 794\u003c\/p\u003e \u003cp\u003e13.27 Smarter Data Warehouses 798\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 \u003c\/b\u003e\u003cb\u003eMaintenance and Growth Considerations 805\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDeploying Successfully 805\u003c\/p\u003e \u003cp\u003e14.1 Don’t Forget the Owner’s Manual 805\u003c\/p\u003e \u003cp\u003e14.2 Let’s Improve Our Operating Procedures 809\u003c\/p\u003e \u003cp\u003e14.3 Marketing the DW\/BI System 811\u003c\/p\u003e \u003cp\u003e14.4 Coping with Growing Pains 812\u003c\/p\u003e \u003cp\u003eSustaining for Ongoing Impact 816\u003c\/p\u003e \u003cp\u003e14.5 Data Warehouse Checkups 816\u003c\/p\u003e \u003cp\u003e14.6 Boosting Business Acceptance 822\u003c\/p\u003e \u003cp\u003e14.7 Educate Management to Sustain DW\/BI Success 825\u003c\/p\u003e \u003cp\u003e14.8 Getting Your Data Warehouse Back on Track 828\u003c\/p\u003e \u003cp\u003e14.9 Upgrading Your BI Architecture 829\u003c\/p\u003e \u003cp\u003e14.10 Four Fixes for Legacy Data Warehouses 831\u003c\/p\u003e \u003cp\u003e14.11 A Data Warehousing Fitness Program for Lean Times 835\u003c\/p\u003e \u003cp\u003e14.12 Enjoy the Sunset 839\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 \u003c\/b\u003e\u003cb\u003eFinal Thoughts 841\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eKey Insights and Reminders 841\u003c\/p\u003e \u003cp\u003e15.1 Final Word of the Day: Collaboration 841\u003c\/p\u003e \u003cp\u003e15.2 Tried and True Concepts for DW\/BI Success 843\u003c\/p\u003e \u003cp\u003e15.3 Key Tenets of the Kimball Method 845\u003c\/p\u003e \u003cp\u003eA Look to the Future 847\u003c\/p\u003e \u003cp\u003e15.4 The Future is Bright 847\u003c\/p\u003e \u003cp\u003eArticle Index 853\u003c\/p\u003e \u003cp\u003eIndex 861\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eRalph Kimball, PhD,\u003c\/b\u003e founded the Kimball Group and is a leading visionary in the data warehousing industry.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eMargy Ross,\u003c\/b\u003e President of the Kimball Group and DecisionWorks Consulting, has focused on DW\/BI solutions since 1982.      \u003c\/p\u003e\u003cp\u003e\u003cb\u003eUpdated guidelines for data warehousing and business intelligence\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eRecognized and respected throughout the world as the most influential leaders in the data warehousing and business intelligence (DW\/BI) industry, Ralph Kimball, Margy Ross and the Kimball Group set the industry standard with \u003ci\u003eThe Kimball Group Reader\u003c\/i\u003e. Now in its second edition, this preeminent text has been updated with 65 new \u003ci\u003eDesign Tips \u003c\/i\u003eand white papers to create a remarkable collection that spans more than two decades at the forefront of DW\/BI innovation. \u003c\/p\u003e\u003cp\u003eFrom project planning and requirements gathering to dimensional modeling, ETL, and BI applications, this indispensable collection covers everything you'll encounter in data warehousing and business intelligence. With incomparable articles that provide critical advice for successfully designing, deploying, and maintaining the DW\/BI system, \u003ci\u003eThe Kimball Group Reader\u003c\/i\u003e covers:  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Dos and Don'ts for launching a DW\/BI project and gathering requirements\u003c\/li\u003e \u003cli\u003e Essentials for the integrated enterprise data warehouse, including the bus architecture and matrix\u003c\/li\u003e \u003cli\u003e Granularity and three fundamental types of fact tables\u003c\/li\u003e \u003cli\u003e Slowly changing dimension techniques\u003c\/li\u003e \u003cli\u003e Snowflakes, outriggers, and bridge tables\u003c\/li\u003e \u003cli\u003e Dimensional modeling advanced patterns \u003c\/li\u003e \u003cli\u003e Backroom extract, transform, and load (ETL) subsystems and data quality\u003c\/li\u003e \u003cli\u003e BI application best practices\u003c\/li\u003e \u003cli\u003e Big data considerations\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003eThis easily referenced and newly updated collection is invaluable if you're involved with data warehousing or business intelligence in any capacity.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eWiley Computer Publishing Timely. Practical. Reliable.\u003c\/b\u003e\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990273409253,"sku":"NP9781119216315","price":50.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119216315.jpg?v=1761787153","url":"https:\/\/k12savings.com\/es\/products\/the-kimball-group-reader-isbn-9781119216315","provider":"K12savings","version":"1.0","type":"link"}