Beschreibung

An unparalleled collection of recommended best practices from the data warehousing pioneers of the Kimball Group

Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have pioneered methods and standards that have been adopted by nearly every leading data warehouse vendor. For the first time ever, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation.

Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology; they cover such topics as pre-project planning, organizing the project, business requirements, data architecture, dimensional modeling, ETL, , technical architecture, business intelligence and analytics, and maintenance and growth.
The Kimball Group is a world-renowned consulting and training group that has pioneered innovative data warehousing methods and techniques
Presents a collection of updated articles that share best practices and invaluable advice on every major topic involved in designing, building, and managing a a data warehouse
Covers the complete data warehouse lifecycle Provides novel data warehouse design techniques not found in their previously published books

This useful and easily referenced collection is nothing less than vital if you are involved with data warehousing in any capacity.

Inhaltsangabe

Introduction.
1 The Reader at a Glance.
Setting Up for Success.
2 Before You Dive In.
Historical Perspective.
3 Project / Program Planning.
Professional Responsibilities.
4 Requirements Definition.
Gathering Requirements.
5 Data Architecture.
Making the Case for Dimensional Modeling.
Integration Instead of Centralization.
6 Dimensional Modeling Fundamentals.
Basics of Dimensional Modeling.
7 Dimensional Modeling Tasks and Responsibilities.
Design Activities.
8 Fact Table Core Concepts.
Granularity.
9 Dimension Table Core Concepts.
Dimension Table Keys.
Miscellaneous Dimension Patterns.
10 More Dimension Patterns and Case Studies.
Snowflakes, Outriggers, and Bridges.
11 Back Room ETL and Data Quality.
Planning the ETL System.
Data Quality Considerations.
12 Technical Architecture Considerations.
Overall Technical / System Architecture.
13 Front Room Business Intelligence Applications.
Delivering Value with Business Intelligence.
Implementing the Business Intelligence Layer.
Mining Data to Uncover Relationships.
Dealing with SQL.
14 Maintenance and Growth Considerations.
Deploying Successfully.
Sustaining for Ongoing Impact.
Index of Articles.
Index.

Klappentext

An unparalleled collection of recommended guidelines for data warehousing and business intelligence pioneered by Ralph Kimball and his team of colleagues from the Kimball Group.

Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have written articles covering more than 250 topics that define the field of data warehousing. For the first time, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation.

Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology and cover the complete lifecycle--including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence and analytics.

This easily referenced collection is nothing less than vital if you are involved with data warehousing or business intelligence in any capacity.

Sonstiges

Lieferung vom Verlag mit leichten Qualitätsmängeln möglich