With SQL Server2005 and the Microsoft Business Intelligence Toolset
By Joy Mundy, Warren Thornthwaite
Final Release Date: May 2006
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.