If you are looking for a great introduction to the Kimball methodology, the latest edition of Ralph Kimball’s book, ‘The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modelling [Kindle Edition]’. Having read the two other versions, there is some new content that makes the new version worth the read.
The book covers new and enhanced star schema dimensional modelling patterns, in addition to two new chapters on ETL techniques and includes new and expanded business matrices for 12 case studies. As I have not read the book as of yet, I am interested in seeing how they handle they Big Data chapter.
From the Amazon description, the following items are are a summary of what topics are covered;
- 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
I will try and have a full review once I can get the Kindle edition read. 600 pages are a lot to go over. 🙂
A link to the amazon site (no affiliate link) is here;