The Microsoft Data Warehouse Toolkit: With SQL Server 2008 and the Microsoft Business Intelligence Toolset / Edition 1

Paperback (Print)
Buy New
Buy New from
Buy Used
Buy Used from
(Save 37%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (33) from $1.99   
  • New (6) from $29.70   
  • Used (27) from $1.99   


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.

Read More Show Less

Product Details

  • ISBN-13: 9780471267157
  • Publisher: Wiley
  • Publication date: 2/13/2006
  • Edition description: Older Edition
  • Edition number: 1
  • Pages: 792
  • Sales rank: 1,057,770
  • Product dimensions: 9.10 (w) x 7.30 (h) x 1.80 (d)

Meet the Author

Joy Mundy, a member of the Kimball Group, has beendeveloping, consulting on, and speaking and writing about businessintelligence systems and technology since 1992. Joy began hercareer as a business analyst in banking and finance as one of thepower users we talk about in business intelligence. In 1992 shejoined the data warehouse team at Stanford University, an effortthat was both educational and character building. She nextco-founded InfoDynamics LLC, a data warehouse consulting firm, andthen joined Microsoft WebTV to develop closed-loop analyticapplications and a packaged business intelligence system. From 2000to 2004, Joy worked with the Microsoft SQL Server BusinessIntelligence product development team. She managed a team thatdeveloped the best practices for building business intelligencesystems on the Microsoft platform. Joy graduated from TuftsUniversity with a B.A. in Economics, and from Stanford with an Engineering Economic Systems.

Warren Thornthwaite, a member of the Kimball Group, hasbeen building decision support and data warehousing systems since1980. Warren co-authored the best-selling Data WarehouseLifecycle Toolkit (Wiley, 1998). Warren worked at MetaphorComputer Systems for eight years starting in 1983, where he managedthe consulting organization and implemented many major datawarehouse systems. After Metaphor, Warren managed theenterprise-wide data warehouse development at Stanford University.He then cofounded InfoDynamics LLC, a data warehouse consultingfirm. Warren joined up with WebTV to help build a world-class,multi-terabyte customer-focused data warehouse before returning toconsulting.
In addition to designing data warehouses for a range of industries,Warren has extensive experience helping clients develop scalable,practical information access architectures. Warren holds an MBA inDecision Sciences from the University of Pennsylvania’sWharton School, and a BA in Communications Studies from theUniversity of Michigan.

Ralph Kimball, Ph.D., founder of the Kimball Group,has been designing information systems and data warehouses since1972. Ralph wrote his Ph.D. dissertation in the ElectricalEngineering department at Stanford University on the design of aman–machine system for tutoring mathematics students. In 1972he joined the Xerox Palo Alto Research Center as a researchscientist. Over the following ten years at Xerox, he became adevelopment manager and the product marketing manager for the XeroxStar workstation, the first commercial product that used windows,icons, and the mouse. For this work at Xerox, he received theAlexander Williams Award from the IEEE Human Factors Society foruser interface design. Following his years at Xerox, Ralph was avice president and member of the founding team at Metaphor ComputerSystems, the first data warehousing company. Between 1982 and 1986,Metaphor installed many client-server data warehouse systems. In1986 Ralph founded Red Brick Systems, which developed the firsthigh-performance relational database for decision support. Since1993, Ralph has designed data warehouse systems, writtenbestselling data warehouse books, and taught data warehousingskills to more than 10,000 IT professionals.

Read More Show Less

Table of Contents





Part One Requirements, Realities, and Architecture.

Chapter 1 Defining Business Requirements.

Chapter 2 Designing the Business Process Dimensional Model.

Chapter 3 The Toolset.

Part Two Developing and Populating the Databases.

Chapter 4 Setup and Physical Design.

Chapter 5 Designing the ETL System.

Chapter 6 Developing the ETL System.

Chapter 7 Designing the Analysis Services OLAP Database.

Part Three Developing the BI Applications.

Chapter 8 Business Intelligence Applications.

Chapter 9 Building the BI Application in Reporting Services.

Chapter 10 Incorporating Data Mining.

Part Four Deploying and Managing the DW/BI System.

Chapter 11 Working with an Existing Data Warehouse.

Chapter 12 Security.

Chapter 13 Metadata Plan.

Chapter 14 Deployment.

Chapter 15 Operations and Maintenance.

Part Five Extending the DW/BI System.

Chapter 16 ManagingGrowth.

Chapter 17 Real-Time Business Intelligence.

Chapter 18 Present Imperatives and Future Outlook.


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 5 Customer Reviews
  • Posted December 29, 2008

    Successful application of data warehousing expertise to a real-world platform

    I've enthusiastically referenced Kimball publications for business intelligence projects over the years; everything from how to manage history in slowly changing dimensions to fact-less fact tables to creating an initial data warehouse project plan, always with outstanding results. Mundy, Thornthwaite, and Kimball achieve two key milestones with The Microsoft Data Warehouse Toolkit. First, they successfully apply many years of data warehousing scholarship and expertise to a real-world platform. This is accomplished from a practical perspective with respect to MS SQL Server, as the authors are realistic of both the strengths and weaknesses of the platform and tailor their approach accordingly. Second, this publication is one of the first to recognize modern incarnations of the MS SQL Server as a viable platform for data warehousing. Microsoft has addressed the stability issues that plagued earlier releases of the SQL Server. If you're considering an MS SQL warehouse deployment, I would strongly encourage you and your staff to read this book.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 28, 2007

    Excellent book

    I work for 3 years now as a datawarehouse designer and developer using SQL Server 2000 tools. The Microsoft Data Warehouse Toolkit is one of the best books covering IT I have ever come across. It covers everything you want to know, displaying expert knowledge of the writers, and is pleasant and easy to read.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 13, 2006

    A step by step easily undestandable book on using Microsoft Data Warehouse toolkit:

    'The Microsoft Datawarehouse ToolKit' is hands on, no-nonsense, well organized step by step guide to Datawarehousing. This 700 page book is divided into five parts and eighteen chapters, in which author has provided wealth of information on all the pertaining topics. This book is illustrated and provides diagram and figures of every step defined during the process. The five main sections are 'Requirements,Realities and Architecture', 'Developing and Populating Databases','Developing the BI applications', 'Deploying and Managing the dw/bi systems' and 'Extending the DW/BI SYSTEM' covers great topics like collecting requirement, planning, designing and developing datawarehouse environment. The ETL system explained in chapter 5 is clear in its fundamentals. The real interesting topic in this book for me is chapter 11. working with an existing Data warehouse and chapter 12 security. I liked Ralph's explanation of Metadata from Chapter 13. The best part of the book is mainly focusing on relating data warehousing to Business Intelligence. I recommend this book to everyone who currently working with Microsoft products to generate the reports.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 9, 2007

    BI Project Plan (w/Instructions)

    Only wish I'd read this book before completing several data warehousing projects! The Kimball folks provide concise and easy to understand instructions for building a dw ala Microsoft. The discussion covers both technical and not so technical issues.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 25, 2008

    No text was provided for this review.

Sort by: Showing all of 5 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)