The Data Warehouse Lifecycle Toolkit
17%
off

The Data Warehouse Lifecycle Toolkit

3.89 (210 ratings by Goodreads)
By (author)  , By (author)  , By (author)  , By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 1 business day
When will my order arrive?

Description

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.
show more

Product details

  • Paperback | 672 pages
  • 188 x 230 x 38mm | 979.75g
  • John Wiley & Sons Ltd
  • Chichester, United Kingdom
  • English
  • 2nd Edition
  • 0470149779
  • 9780470149775
  • 129,547

Back cover copy

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.

With substantial new and updated content, this second edition of The Data Warehouse Lifecycle Toolkit again sets the standard in data warehousing for the next decade. It shows you how to: Identify and prioritize data warehouse opportunities Create an architecture plan and select products Design a powerful, flexible, dimensional model Build a robust ETL system Develop BI applications to deliver data to business users Deploy and sustain a healthy DW/BI environment

The authors are members of the Kimball Group. Each has focused on data warehousing and business intelligence consulting and education for more than 15 years; most have written other books in the Toolkit series. Learn more about the Kimball Group and Kimball University at www.kimballgroup.com.

Wiley Technology Publishing Timely. Practical. Reliable.

Visit the book's companion website at www.wiley.com/compbooks/kimball Find templates, sample documents, checklists, and task lists on the book's companion website at www.kimballgroup.com
show more

Table of contents

Chapter 1 Introducing the Kimball Lifecycle 1


Chapter 2 Launching and Managing the Project/Program 15


Chapter 3 Collecting the Requirements 63


Chapter 4 Introducing the Technical Architecture 109


Chapter 5 Creating the Architecture Plan and Selecting Products 179


Chapter 6 Introducing Dimensional Modeling 233


Chapter 7 Designing the Dimensional Model 287


Chapter 8 Designing the Physical Database and Planning for Performance 327


Chapter 9 Introducing Extract, Transformation, and Load 369


Chapter 10 Designing and Developing the ETL System 425


Chapter 11 Introducing Business Intelligence Applications 473


Chapter 12 Designing and Developing Business Intelligence Applications 505


Chapter 13 Deploying and Supporting the DW/BI System 541


Chapter 14 Expanding the DW/BI System 579


Glossary 593
show more

Review quote

(...)
Das Buch richtet sich primdr an Designer und Informations-Manager im Umfeld von Data-Warehouse-Anwendungen. Diese Zielgruppe erhdlt Ratschldge und Handlungsanleitungen, um deren Anforderungen optimal zu bewdltigen. Dabei ist der ganzheitliche Ansatz zu betonen, der eine evolutiondre Weiterentwicklung besser als singuldre Schnellsch]sse unterst]tzen kann. auch der zugrundeliegende Architekturcharakter trdgt zur Festigung dieser Intension bei. Zu knapp werden die Themen Data Mining und Parallelverarbeitung angesprochen; ebenfalls fehlen zur Vertiefung weiterf]hrende Literaturhinweise. Insbesondere SMP und MPP bieten f]r die praktische Realisierung wichtige Unterst]tzungshilfen. Wobei zur Verbesserung der Performance die Fdhigkeit einiger DBMS Abfragen zu optimieren und parallel zu verarbeiten n]tzlich ist.
IT-Director 10/2000
show more

About Margy Ross

Ralph Kimball, PhD, is the Founder of the Kimball Group and has been a leading visionary in the data warehouse industry since 1982.
show more

Rating details

210 ratings
3.89 out of 5 stars
5 30% (62)
4 38% (80)
3 26% (54)
2 5% (11)
1 1% (3)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X