Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset |
 |
 click here for more details, find new or used items |
Joy Mundy, Warren Thornthwaite, Ralph Kimball
|
|
Pages: 792 (Paperback)
ISBN: 0471267155
Pub: John Wiley & Sons
Pub date: 2006-02-10
Amazon.co.uk Sales Rank: 70449
Reader Reviews:
Brilliantly covers the BI development lifecycle. (2/2 people found this helpful)
I don't normally enjoy reading technical IT books, but this one was difficult to put down. It covers the whole of the Business Intellegence lifecycle using Microsoft products (namely SQL Server 2005, Inegration Services, Analysis Services and Reporting Services) to build a Kimball Dimensional model data warehouse.
The initial chapters cover the design cycle and reinforce the need to drive the data warehouse design from properly researched client requirements.
It then goes on to implement the design through an ETL process using SQL Server Integration Services. The coverage is complete with particular attention to handling Type 1 and 2 data changes. The Slowly Changing Dimension Task is well described and provokes significant thought about warehouse design.
Designing and building the OLAP database follows with 3 chapters dedicated to Business Intelligence applications, including comprehensive coverage of the role of Reporting Services and Data Mining Modeling. I have found these 3 chapters particularly useful in deciding how to deliver the client side analysis tools.
The final section explains how to setup security, how to deploy your solution, how to manage operations and maintenance and, finally, how to implement Real-Time Business Intelligence in the traditional data warehouse.
A number of tools are available from the books web site, including a well written and fully working (on SQL Server 2005 - needs some small changes for SQL 2008 because the underlying AdventureWorks database is changed in SQL 2008) SSIS package.
This is not a regurgitation of Books On Line, nor is it a step by step 'How To' guide to using Microsoft SQL Server. What it does, and does it brilliantly, is describe in detail the processes that you will need to go through to build a complete working Business Intelligence solution.
It is clear that the authors are proper experts in their field and that many years of experience have been distilled into this book. This is the only one you will need.
Covers everything (5/7 people found this helpful)
A very well written book covering all of the aspects of designing, building and deploying a datwarehouse using the Microsoft toolset.
Some of the sections are a little brief, and I'd reccomend getting supporting material on MDX and Report Services if these technologies are to be used, as the sections in this (admittedly huge) book are a little light.
The only thing it doesn't mention are some of the glaring defects in Microsofts product, but we can hardly blame the authors for that !
Similar Products
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
Professional SQL Server 2005 Integration Services
Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft))
Categories
Amazon.co.uk places this book into the following categories:
Books -> Subjects -> Computing & Internet -> Databases -> Applications -> SQL -> Microsoft SQL Server
Books -> Subjects -> Computing & Internet -> Databases -> Data Storage & Management -> Data Warehousing
Books -> Subjects -> Computing & Internet -> Digital Lifestyle -> Online Shopping -> Amazon
Books -> Subjects -> Computing & Internet -> General
Books -> Subjects -> Computing & Internet -> Software & Graphics -> General AAS
Books -> Subjects -> Computing & Internet -> Web Development -> Web-server Software -> Microsoft -> General AAS
Books -> Subjects -> Computing & Internet -> General AAS
Books -> Refinements -> Language (feature_browse-bin) -> English
Books -> Refinements -> Format (binding_browse-bin) -> Paperback
Books -> Refinements -> Font Size (format_browse-bin) -> Regular Size