The Data Warehouse Lifecycle Toolkit (Google eBook)

Front Cover
John Wiley & Sons, Mar 8, 2011 - Computers - 672 pages
5 Reviews
A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business.

Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

  

What people are saying - Write a review

User ratings

5 stars
2
4 stars
2
3 stars
0
2 stars
1
1 star
0

Review: The Data Warehouse Lifecycle Toolkit

User Review  - Chris - Goodreads

Kimball is considered one of the fathers of the data warehousing movement and among many consulting firms is considered the de-facto representation of reporting database infrastructure. This specific ... Read full review

Review: The Data Warehouse Lifecycle Toolkit

User Review  - Bj - Goodreads

a great intro to dimensional modeling Read full review

Contents

Introducing the Kimball Lifecycle
1
Launching and Managing the ProjectProgram
15
Collecting the Requirements
63
Introducing the Technical Architecture
109
Back Room Architecture
119
Presentation Server Architecture
133
Creating the Architecture Plan and Selecting Products
179
Introducing Dimensional Modeling
233
Overwrite
389
Create a New Row
390
Add a New Column
391
Surrogate Key Generator
392
Hierarchy Manager
393
Fact Table Builders
395
Transaction Grain Fact Table Loader
396
Accumulating Snapshot Fact Table Loader
397

Designing the Dimensional Model
287
Designing the Physical Database and Planning for Performance
327
Introducing Extract Transformation and Load
369
Security
372
Data Latency
373
Available Skills
374
Extracting Data
375
Change Data Capture System
376
Extract System
378
Cleaning and Conforming Data
380
Data Cleansing System
381
Quality Screens
382
Responding to Quality Events
383
Audit Dimension Assembler
385
Deduplication System
386
Delivering Data for Presentation
387
Surrogate Key Pipeline
398
MultiValued Dimension Bridge Table Builder
400
Dimension Manager System
402
Aggregate Builder
403
OLAP Cube Builder
404
Managing the ETL Environment
405
Job Scheduler
406
Backup System
407
Designing and Developing the ETL System
425
Introducing Business Intelligence Applications
473
Designing and Developing Business Intelligence Applications
505
Deploying and Supporting the DWBI System
541
Expanding the DWBI System
579
Glossary
593
Copyright

Common terms and phrases

About the author (2011)

The authors’ professional careers have followed remarkably similar paths. Each author has focused on data warehousing and business intelligence (DW/BI) consulting and education for more than fifteen years. Most worked together at Metaphor Computer Systems, a pioneering decision support vendor, in the 1980s. All the authors are members of the Kimball Group and teach for KimballUniversity. They contribute regularly to Intelligent Enterprise magazine and other industry publications; most have previously written books in the Toolkit series.
Ralph Kimball founded the Kimball Group. Since the mid 1980s, he has been the DW/BI industry’s thought leader on the dimensional approach and trained more than 10,000 IT professionals. Ralph has his Ph.D. in Electrical Engineering from Stanford University.

Margy Ross is President of the Kimball Group. She has focused exclusively on DW/BI since 1982 with an emphasis on business requirements analysis and dimensional modeling. Margy graduated with a BS in Industrial Engineering from Northwestern University.

Warren Thornthwaite began his DW/BI career in 1980. After managing Metaphor’s consulting organization, he worked for Stanford University and WebTV. Warren holds a BAin Communications Studies from the University of Michigan and anMBA from the University of Pennsylvania’sWharton School.

JoyMundy has focused onDW/BIsystems since 1992 with stints at Stanford, Web TV, and Microsoft’s SQL Server product development organization. Joy graduated from Tufts University with a BA in Economics, and from Stanford University with an MS in Engineering Economic Systems.

Bob Becker has helped clients across a variety of industries with their DW/BI challenges and solutions since 1989, including extensive work with health care organizations. Bob has a BSB in Marketing from the University of Minnesota’s School of Business.

Bibliographic information