Product Description: This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.
Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.
Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.
Intended Audience
The target audience for this book is the IT department or service provider (consultant) who is:
Planning a small to mid-range data warehouse project;
Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology;
Familiar with the general concepts of data warehousing and business intelligence.
The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book’s content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interesting to a database administrator or programmer as guiding information.
The book is focused on the mass market, where the volume of data in a single application or data mart is less than 500 GB of raw data. While the book does discuss issues around handling larger warehouses in the Microsoft environment, it is not exclusively, or even primarily, concerned with the unusual challenges of extremely large datasets.
About the Authors
JOY MUNDY has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy co-founded InfoDynamics LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse.
Before returning to consulting with the Kimball Group in 2004, Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy began her career as a business analyst in banking and finance. She graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.
WARREN THORNTHWAITE has been building data warehousing and business intelligence systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm, with his co-author, Joy Mundy. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting with the Kimball Group. In addition to designing data warehouses for a range of industries, Warren speaks at major industry conferences and for leading vendors, and is a long-time instructor for Kimball University. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan.
RALPH KIMBALL, PH.D., has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known authors, speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine.
Very complete I bought this book for a class. It is very complete. I am an IT person who need this sense of Business Size of BI while I am updating my SQL Server skills. I recommend this book.
Essential Reading for Data Warehousing with SQL Server 2005 Having spent more time doing data warehousing than reading about it, I didn't realize what a phenomenon the Kimball Method had become. I was interviewing with a company that mentioned Kimball and wanted to use his methods to build a data warehouse on SQL Server 2005, so I turned to Amazon, found this book, used my Amazon Prime to get the tome and got the job. So how was the book? Honestly, it covers the Kimball Method well and most experienced analysts will not find much new other than the jargon. The practical advice from Mundy and Thornthwaite is valuable and will help you make some practical decisions on implementation, if not spell out all the steps. My feeling was that if you are comfortable with implementing data marts or data warehouses, this book will give you the advice you need for setting up a SQL Server 2005 data warehouse and implementing Analysis Services. For a more in depth look at how to implement Analysis Services, I recommend Melomed's book as a follow on.
The only complaint I have with this book is it over sells SQL Server Integration Services (SSIS) as an ETL tool. That is probably Mundy's Microsoft viewpoint speaking rather than actual experience with the tool. After using SSIS, I look at it as Data Transformation Services (DTS) with a nice face on it, but really its just lipstick on the same pig. I have picked up several books on SSIS to try find out how to do all the wonderful things it promises, but they pretty much echo the documentatiion, so I can't really recommend any of them.
Overall, this is book well worth reading. After spending the last year on an Oracle/Teradata project, its refreshing to get back to SQL Server 2005 and Analysis Services. If you are just making the jump to data warehousing on SQL Server 2005, this is a must read. If you are already familiar with Kimball, you will skip a lot but get some good implementation advice and that makes it worth the price. If you want to know more about MDX or SSIS, this isn't what you are looking for.
More an academic discussion, than hands-on I found this a frustrating book. Eventually I skipped this first 43 pages of introduction plus 120 first pages of the book proper. I felt the authors were more interested in using esoteric language than actually showing how to use the product. If you're trying to baffle someone with tech-speak, this is the book for you. If you have a deadline, and are trying to actually accomplish something, I would suggest looking elsewhere. Disappointed.
Very approachable but authoritative source on DW Having inherited a mature DW, I was weak on the Theory behind what I was supporting. I needed to be able to be confident of not breaking the current system, but still be able to take this vital system forward with the business. I am also under the Time pressure that we all work with. This book gave thorough but clear explanations of the concepts that underlie DW/BI solutions and then went on to particularise these explanations with details based on SQL Server. I am still working through it, but it is a pleasure rather than a chore.
Thanks for the great work that you and the editorial team put into this book. JK.
Not for Beginners? Mundy and Thornthwaite provide the knowledgeable SQL Server technician with many of the soft and hard tools required to deliver a successful BI project. And even if most beginners might miss most of the authors' finer points and hard earned wisdom, they'll still be further ahead on a steep learning curve.
Only wish the Kimball team had written the same book for Analysis Server 2000. It'd have saved me much time! ;-)
Anything Goes Trivia
Megaton Man
Tailipoe
Trevor
