The MicrosoftData Warehouse Toolkit
With SQL Server2005 and the Microsoft Business Intelligence Toolset
By Joy Mundy, Warren Thornthwaite
Publisher: Wiley
Final Release Date: May 2006
Pages: 792

As longtime data warehousing practitioners and former Microsoftinsiders, authors Joy Mundy and Warren Thornthwaite have extensiveexperience in building and managing data warehouse (DW) andbusiness intelligence (BI) systems. With this book, they share bestpractices for using SQL Server 2005 to build a successful DW/BIsystem. Covering the complete suite of data warehousing tools thataccompanies SQL Server 2005, they focus on the full projectlifecycle, including design, development, deployment, andmaintenance.

You'll learn how and when to use BI tools such as AnalysisServices, Integration Services, and the SQL Server database toaccomplish various data warehousing tasks. A helpful case studyused throughout the book provides examples of the techniquespresented. You'll find practical guidance for every member of thedata warehouse team and learn how to:

  • Identify high-value business requirements and buildorganizational support for the project
  • Design an information infrastructure for the enterprise usingestablished dimensional design
  • Design and build a flexible and powerful ETL system to clean,align, and restructure data for business use
  • Provide decision makers with tools to analyze business problemsand opportunities
  • Use data mining to uncover data relationships and trends
  • Build BI applications in Reporting Services
  • Maintain, secure, and operate the DW/BI system

Visit the companion Web site atwww.wiley.com/go/MsftDWToolkit

The companion Web site contains all the code samples, the sampledatabase used throughout, sample templates, and other job aids.

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $55.00
Formats:  PDF