Until you’ve consumed all of the best Data Warehouse books, can you even claim to be a true fan?
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. Design dimensional databases that are easy to…
2. Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema (2011)
is a step-by-step guide for capturing data warehousing / business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders. The book describes BEAM, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team. BEAM provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and…
Designed for use in undergraduate and graduate information systems database courses, this is an introductory yet comprehensive text that requires no prerequisites. Its goal is to provide a significant level of database expertise to students. Key features include: — Covers operational and analytical database systems. Students will learn to design and use operational and analytical databases and will be prepared to apply their knowledge in today’s business environments. — Provides a theoretical foundation and meaningful hands-on experiences — The book’s website includes access to the free…
The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures. “Building a Scalable Data Warehouse” covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer….
5. Data Warehousing For Dummies (2009)
Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to: Data…
6. Agile Data Warehousing for the Enterprise: A Guide for Solution Architects and Project Leaders (2015)
Building upon his earlier book that detailed agile data warehousing programming techniques for the Scrum master, Ralph’s latest work illustrates the agile interpretations of the remaining software engineering disciplines: Use this step-by-step guide to deepen your own application development skills through self-study, show your teammates the world’s fastest and most reliable techniques for creating business intelligence systems, or ensure that the IT department working for you is building your next decision support system the right way. #984,784 in Books (See Top 100 in Books) #196 in Agile Project…
Three books by the bestselling authors on Data Warehousing! The most authoritative guides from the inventor of the technique all for a value price. Ralph Kimball invented a data warehousing technique called “dimensional modeling” and popularized it in his first Wiley book, The Data Warehouse Toolkit. Since this book was first published in 1996, dimensional modeling has become the most widely accepted technique for data warehouse design. Over the past 10 years, Kimball has improved on his earlier techniques and created many new ones. In this 3rd edition, he will provide a comprehensive collection of…
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…
9. The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection (2015)
The Kimball Group Reader, Remastered Collection is the essential reference for data warehouse and business intelligence design, packed with best practices, design tips, and valuable insight from industry pioneer Ralph Kimball and the Kimball Group. This Remastered Collection represents decades of expert advice and mentoring in data warehousing and business intelligence, and is the final work to be published by the Kimball Group. Organized for quick navigation and easy reference, this book contains nearly 20 years of experience on more than 300 topics, all…
Over the past 5 years, the concept of big data has matured, data science has grown exponentially, and data architecture has become a standard part of organizational decision-making. Throughout all this change, the basic principles that shape the architecture of data have remained the same. There remains a need for people to take a look at the “bigger picture” and to understand where their data fit into the grand scheme of things. Data Architecture: A Primer for the Data Scientist, Second Edition addresses the larger architectural picture of how big data fits…
Data Warehouse Architecture: with a Staging Area.. 1-4 Data Warehouse Architecture: with a Staging Area and Data Marts .. 1-5 Extracting Information from a Data Warehouse This book explains how to build a data warehouse using the Microsoft SQL Server 2008 R2 and Office 2010 technology, including discussions on PowerPivot for Excel and SharePoint, Master Data Services, as well as updated capabilities of SQL Server Analysis, Integration, and Reporting Services. To get a basic to intermediate level of understanding of data warehouse (Dimensional Modelling) in general read the following books. 1. Data warehousing fundamentals The Kimball Group wrote the authoritative books on dimensional data warehousing and business intelligence. Our best-selling Toolkit books are recognized for their specific, practical data warehouse and business intelligence techniques and recommendations. Over 400,000 copies have been sold worldwide. Discover the best Data Warehousing in Best Sellers. Find the top 100 most popular items in Amazon Books Best Sellers.
We highly recommend you to buy all paper or e-books in a legal way, for example, on Amazon. But sometimes it might be a need to dig deeper beyond the shiny book cover. Before making a purchase, you can visit resources like Genesis and download some data warehouse books mentioned below at your own risk. Once again, we do not host any illegal or copyrighted files, but simply give our visitors a choice and hope they will make a wise decision.
Data Warehouse Requirements Engineering: A Decision Based Approach
Author(s): Naveen Prakash,Deepika Prakash
Publisher: Springer Singapore, Year: 2018, Size: 4 Mb, Download: pdf
Developing a Data Warehouse for the Healthcare Enterprise : Lessons from the Trenches
Publisher: Taylor and Francis, Year: 2018, Size: 6 Mb, Download: pdf
The Biml Book. Business Intelligence and Data Warehouse Automation
Publisher: Apress, Year: 2017, Size: 13 Mb, Download: pdf
The BIML Book: Business Intelligence and Data Warehouse Automation
Author(s): Andy Leonard et al.
Publisher: Apress, Year: 2017, Size: 15 Mb, Download: pdf
Exam Ref 70-767 Implementing a SQL Data Warehouse
Author(s): Jose Chinchilla, Raj Uchhana
Publisher: Microsoft Press, Year: 2017, Size: 19 Mb, Download: pdf
Practical Hive: A Guide to Hadoop's Data Warehouse System
Author(s): Scott Shaw, Andreas François Vermeulen, Ankur Gupta, David Kjerrumgaard
Publisher: Apress, Year: 2016, Size: 9 Mb, Download: pdf
Building a Scalable Data Warehouse with Data Vault 2.0
Author(s): Dan Linstedt; Michael Olschimke
Publisher: Morgan Kaufmann Publishers, Year: 2015, Size: 51 Mb, Download: pdf
Data Warehouse Systems: Design and Implementation
Author(s): Alejandro Vaisman, Esteban Zimányi
Publisher: Springer-Verlag Berlin Heidelberg, Year: 2014, Size: 18 Mb, Download: pdf
Please note that this booklist is not definite. Some books are really record-breakers according to The Wall Street Journal, others are composed by unknown authors. On top of that, you can always find additional tutorials and courses on Coursera, Udemy or edX, for example. Are there any other relevant books you could recommend? Drop a comment if you have any feedback on the list.