The Microsoft? Data Warehouse Toolkit: With SQL Server? 2005 and the Microsoft? Business Intelligence Toolset - page 1
- 1
- 2
- The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset
- The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset
- Back Cover
- About
- Credits
- Foreword
- Preface
- Introduction
- The Business Dimensional Lifecycle
- How This Book Is Organized
- Additional Information
- On the Web Site
- Part One: Requirements, Realities, and Architecture
- Chapter 1: Defining Business Requirements
- The Most Important Determinant of Long-Term Success
- Uncovering Business Value
- Business Requirements Example: Adventure Works Cycles
- Summary
- Chapter 2: Designing the Business Process Dimensional Model
- Dimensional Modeling Concepts and Terminology
- Additional Design Concepts and Techniques
- The Dimensional Modeling Process
- Case Study: Creating the Adventure Works Cycles Orders Dimensional Model
- Summary
- Chapter 3: The Toolset
- The Microsoft DWBI Toolset
- Why Use the Microsoft Toolset?
- Architecture of a Microsoft DWBI System
- Overview of the Microsoft Tools
- Summary
- Part Two: Developing and Populating the Databases
- Chapter 4: Setup and Physical Design
- System Sizing Considerations
- System Configuration Considerations
- Software Installation and Configuration
- Physical Data Warehouse Database Design
- Summary
- Chapter 5: Designing the ETL System
- An Introduction to SQL Server Integration Services
- High-Level Planning
- Updating Analysis Services Databases
- ETL System Physical Design
- Developing a Detailed Specification
- Summary
- Chapter 6: Developing the ETL System
- Getting Started
- Dimension Processing
- Fact Processing
- Tying It All Together
- Summary
- Chapter 7: Designing the Analysis Services OLAP Database
- Why Analysis Services?
- Designing the OLAP Structure
- Physical Design Considerations
- Summary
- Part Three: Developing the BI Applications
- Chapter 8: Business Intelligence Applications
- Business Intelligence Basic Concepts
- The Value of Business Intelligence Applications
- Delivery Platform Options
- The BI Application Development Process
- Summary
- Chapter 9: Building the BI Application in Reporting Services
- A High-Level Architecture for Reporting
- Building and Delivering Reports
- Summary
- Chapter 10: Incorporating Data Mining
- Defining Data Mining
- SQL Server Data Mining Architecture Overview
- Microsoft Data Mining Algorithms
- The Data Mining Process
- Data Mining Examples
- Summary
- Part Four: Deploying and Managing the DWBI System
- Chapter 11: Working with an Existing Data Warehouse
- The Current State of Affairs
- Conversion from SQL Server 2000
- Integrating with Non-SQL Server 2005 Components
- Summary
- Chapter 12: Security
- 1
- 2
Similar products
Building a Data Warehouse: With Examples in SQL Server (Expert's Voice)
The Data Warehouse Lifecycle Toolkit
The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence
The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset