Informationen zum Autor Ralph Kimball, PhD, founded the Kimball Group and is a leading visionary in the data warehousing industry.Margy Ross, President of the Kimball Group and DecisionWorks Consulting, has focused on DW/BI solutions since 1982. Zusammenfassung The final edition of the incomparable data warehousing and business intelligence reference, updated and expandedThe Kimball Group Reader, Remastered Collection 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.Data 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.* Learn data warehousing and business intelligence from the field's pioneers* Get up to date on best practices and essential design tips* Gain valuable knowledge on every stage of the project lifecycle* Dig into the Kimball Group methodology with hands-on guidanceRalph 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 The Kimball Group Reader represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field. ...

Autorentext

Ralph Kimball, PhD, founded the Kimball Group and is a leading visionary in the data warehousing industry. Margy Ross, President of the Kimball Group and DecisionWorks Consulting, has focused on DW/BI solutions since 1982.

Klappentext

Updated guidelines for data warehousing and business intelligence Recognized 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 The Kimball Group Reader. Now in its second edition, this preeminent text has been updated with 65 new Design Tips and white papers to create a remarkable collection that spans more than two decades at the forefront of DW/BI innovation. From 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, The Kimball Group Reader covers:

• Dos and Don'ts for launching a DW/BI project and gathering requirements
• Essentials for the integrated enterprise data warehouse, including the bus architecture and matrix
• Granularity and three fundamental types of fact tables
• Slowly changing dimension techniques
• Snowflakes, outriggers, and bridge tables
• Dimensional modeling advanced patterns
• Backroom extract, transform, and load (ETL) subsystems and data quality
• BI application best practices
• Big data considerations This easily referenced and newly updated collection is invaluable if you're involved with data warehousing or business intelligence in any capacity. Wiley Computer Publishing Timely. Practical. Reliable.

Zusammenfassung
The final edition of the incomparable data warehousing and business intelligence reference, updated and expanded The Kimball Group Reader, Remastered Collection 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. Data 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. * Learn data warehousing and business intelligence from the field's pioneers * Get up to date on best practices and essential design tips * Gain valuable knowledge on every stage of the project lifecycle * Dig into the Kimball Group methodology with hands-on guidance Ralph 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 The Kimball Group Reader represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field.

Inhalt

Introduction xxv

1 The Reader at a Glance 1

Setting Up for Success 1

1.1 Resist the Urge to Start Coding 1

1.2 Set Your Boundaries 4

Tackling DW/BI Design and Development 6

1.3 Data Wrangling 6

1.4 Myth Busters 9

1.5 Dividing the World 10

1.6 Essential Steps for the Integrated Enterprise Data Warehouse 13

1.7 Drill Down to Ask Why 22

1.8 Slowly Changing Dimensions 25

1.9 Judge Your BI Tool through Your Dimensions 28

1.10 Fact Tables 31

1.11 Exploit Your Fact Tables 33

2 Before You Dive In 35

Before Data Warehousing 35

2.1 History Lesson on Ralph Kimball and Xerox PARC 36

Historical Perspective 37

2.2 The Database Market Splits 37

2.3 Bringing Up Supermarts 40

Dealing with Demanding Realities 47

2.4 Brave New Requirements for Data Warehousing 47

2.5 Coping with the Brave New Requirements 52

2.6 Stirring Things Up 57

2.7 Design Constraints and Unavoidable Realities 60

2.8 Two Powerful Ideas 64

2.9 Data Warehouse Dining Experience 67

2.10 Easier Approaches for Harder Problems 70

2.11 Expanding Boundaries of the Data Warehouse 72

3 Project/Program Planning 75

Professional Responsibilities 75

3.1 Professional Boundaries 75

3.2 An Engineer's View 78

3.3 Beware the Objection Removers 82

3.4 What Does the Central Team Do? 86

3.5 Avoid Isolating DW and BI Teams 90

3.6 Better Business Skills for BI and Data Warehouse Professionals 91

3.7 Risky Project Resources are Risky Business 93

3.8 Implementation Analysis Paralysis 9…