Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!
About the Author: RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982.
608 Pages
Computers + Internet, Databases
Description
Book Synopsis
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!
The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.
Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence
Begins with fundamental design recommendations and progresses through increasingly complex scenarios
Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more
Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more
Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.
From the Back Cover
The most authoritative and comprehensive guide to dimensional modeling, from its originators--fully updated
Ralph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of The Data Warehouse Toolkit (1996). Since then, dimensional modeling has become the most widely accepted approach for presenting information in data warehouse and business intelligence (DW/BI) systems. The Data Warehouse Toolkit is recognized as the definitive source for dimensional modeling techniques, patterns, and best practices.
This third edition of the classic reference delivers the most comprehensive library of dimensional modeling techniques ever assembled. Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models--and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals.
All the techniques in the book are illustrated with real-world case studies based on the authors' actual DW/BI design experiences. In addition, the Kimball Group's "official" list of dimensional modeling techniques is summarized in a single chapter for easy reference, with pointers from each technique to the case studies where the concepts are brought to life.
The third edition of The Data Warehouse Toolkit covers:
Practical design techniques--both basic and advanced--for dimension and fact tables
14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation
Sample data warehouse bus matrices for 12 case studies
Dimensional modeling pitfalls and mistakes to avoid
Enhanced slowly changing dimension techniques type 0 through 7
Bridge tables for ragged variable depth hierarchies and multivalued attributes
Best practices for Big Data analytics
Guidelines for collaborative, interactive design sessions with business stakeholders
An overview of the Kimball DW/BI project lifecycle methodology
Comprehensive review of extract, transformation, and load (ETL) systems and design considerations
The 34 ETL subsystems and techniques to populate dimension and fact tables
About the Author
RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996.
MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years.
Dimensions (Overall): 9.23 Inches (H) x 7.4 Inches (W) x 1.15 Inches (D)
Weight: 2.2 Pounds
Suggested Age: 22 Years and Up
Sub-Genre: Databases
Genre: Computers + Internet
Number of Pages: 608
Publisher: Wiley
Theme: Data Warehousing
Format: Paperback
Author: Ralph Kimball & Margy Ross
Featured book lists: Textbooks
Language: English
Street Date: July 1, 2013
TCIN: 80826270
UPC: 9781118530801
Item Number (DPCI): 315-00-5028
Origin: Made in the USA or Imported
If the item details aren’t accurate or complete, we want to know about it.
Shipping details
Estimated ship dimensions: 1.15 inches length x 7.4 inches width x 9.23 inches height
Estimated ship weight: 2.2 pounds
We regret that this item cannot be shipped to PO Boxes.
This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO, Alaska, Hawaii
Return details
This item can be returned to any Target store or Target.com.
This item must be returned within 30 days of the date it was purchased in store, delivered to the guest, delivered by a Shipt shopper, or picked up by the guest.