Microsoft Data Warehouse Toolkit: With SQL Server 2008 and the Microsoft Business Intelligence Toolset / Edition 1by Joy Mundy
As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data… See more details below
As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance.
You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team and learn how to:
- Identify high-value business requirements and build organizational support for the project
- Design an information infrastructure for the enterprise using established 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 problems and 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 at www.wiley.com/go/MsftDWToolkit
The companion Web site contains all the code samples, the sample database used throughout, sample templates, and other job aids.
- Publication date:
- Edition description:
- Older Edition
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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >