for Kindle Fire, Apple, Android, Nook, Kobo, PC, Mac, BlackBerry ...

New to

Learn more

The MicrosoftData Warehouse Toolkit

With SQL Server2005 and the Microsoft Business Intelligence Toolset

The MicrosoftData Warehouse Toolkit by Joy Mundy
Add to cart
US$ 55.00
(If any tax is payable it will be calculated and shown at checkout.)
This groundbreaking book is the first in the Kimball Toolkit seriesto be product-specific. Microsoft’s BI toolset has undergonesignificant changes in the SQL Server 2005 development cycle. SQLServer 2005 is the first viable, full-functioned data warehouse andbusiness intelligence platform to be offered at a price that willmake data warehousing and business intelligence available to abroad set of organizations. This book is meant to offer practicaltechniques to guide those organizations through the myriad ofchallenges to true success as measured by contribution to businessvalue.

Building a data warehousing and business intelligence system isa complex business and engineering effort. While there aresignificant technical challenges to overcome in successfullydeploying a data warehouse, the authors find that the most commonreason for data warehouse project failure is insufficient focus onthe business users and business problems. In an effort to helppeople gain success, this book takes the proven BusinessDimensional Lifecycle approach first described in best selling TheData Warehouse Lifecycle Toolkit and applies it to the MicrosoftSQL Server 2005 tool set.

Beginning with a thorough description of how to gather businessrequirements, the book then works through the details of creatingthe target dimensional model, setting up the data warehouseinfrastructure, creating the relational atomic database, creatingthe analysis services databases, designing and building thestandard report set, implementing security, dealing with metadata,managing ongoing maintenance and growing the DW/BI system. All ofthese steps tie back to the business requirements. Each chapterdescribes the practical steps in the context of the SQL Server 2005platform.

Intended Audience

The target audience for this book is the IT department orservice provider (consultant) who is:

  • Planning a small to mid-range data warehouse project;
  • Evaluating or planning to use Microsoft technologies as theprimary or exclusive data warehouse server technology;
  • Familiar with the general concepts of data warehousing andbusiness intelligence.

The book will be directed primarily at the project leader andthe warehouse developers, although everyone involved with a datawarehouse project will find the book useful. Some of thebook’s content will be more technical than the typicalproject leader will need; other chapters and sections will focus onbusiness issues that are interesting to a database administrator orprogrammer as guiding information.

The book is focused on the mass market, where the volume of datain a single application or data mart is less than 500 GB of rawdata. While the book does discuss issues around handling largerwarehouses in the Microsoft environment, it is not exclusively, oreven primarily, concerned with the unusual challenges of extremelylarge datasets.

About the Authors

JOY MUNDY has focused on data warehousing and businessintelligence since the early 1990s, specializing in businessrequirements analysis, dimensional modeling, and businessintelligence systems architecture. Joy co-founded InfoDynamics LLC,a data warehouse consulting firm, then joined Microsoft WebTV todevelop closed-loop analytic applications and a packaged datawarehouse.

Before returning to consulting with the Kimball Group in 2004,Joy worked in Microsoft SQL Server product development, managing ateam that developed the best practices for building businessintelligence systems on the Microsoft platform. Joy began hercareer as a business analyst in banking and finance. She graduatedfrom Tufts University with a BA in Economics, and from Stanfordwith an MS in Engineering Economic Systems.

WARREN THORNTHWAITE has been building data warehousingand business intelligence systems since 1980. Warren worked atMetaphor for eight years, where he managed the consultingorganization and implemented many major data warehouse systems.After Metaphor, Warren managed the enterprise-wide data warehousedevelopment at Stanford University. He then co-founded InfoDynamicsLLC, a data warehouse consulting firm, with his co-author, JoyMundy. Warren joined up with WebTV to help build a world class,multi-terabyte customer focused data warehouse before returning toconsulting with the Kimball Group. In addition to designing datawarehouses for a range of industries, Warren speaks at majorindustry conferences and for leading vendors, and is a long-timeinstructor for Kimball University. Warren holds an MBA in DecisionSciences from the University of Pennsylvania's Wharton School, anda BA in Communications Studies from the University of Michigan.

RALPH KIMBALL, PH.D., has been a leading visionary in thedata warehouse industry since 1982 and is one of today's mostinternationally well-known authors, speakers, consultants, andteachers on data warehousing. He writes the "Data WarehouseArchitect" column for Intelligent Enterprise (formerly DBMS)magazine.

Wiley; May 2006
794 pages; ISBN 9780470007365
Read online, or download in secure PDF format
Title: The MicrosoftData Warehouse Toolkit
Author: Joy Mundy; Warren Thornthwaite; Ralph Kimball
Buy, download and read The MicrosoftData Warehouse Toolkit (eBook) by Joy Mundy; Warren Thornthwaite; Ralph Kimball today!