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

ISBN: B000YIVXC2
EAN: N/A

Year: 2006
Pages: 125

Authors: Joy Mundy, Warren Thornthwaite, Ralph Kimball

BUY ON AMAZON

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
Identifying the Security Manager
Securing the Hardware
Securing the Operating System
Securing the Development Environment
Securing the Data
Usage Monitoring
Protecting Privacy
Summary
Chapter 13: Metadata Plan
Metadata Basics
Metadata Standards
SQL Server 2005 Metadata
A Practical Metadata Approach
Summary
Chapter 14: Deployment
System Deployment
Data Warehouse and BI Documentation
User Training
User Support
Desktop Readiness and Configuration
Summary
Chapter 15: Operations and Maintenance
Providing User Support
System Management
Summary
Part Five: Extending the DWBI System
Chapter 16: Managing Growth
Lifecycle Iteration: Growing the DWBI System
Marketing and Expectation Management
System Interconnection
Summary
Chapter 17: Real-Time Business Intelligence
Making the Case For (and Against) Real-Time Data
Executing Reports in Real Time
Loading the DWBI System in Real Time
Using Analysis Services to Deliver Real-Time Data
Summary
Chapter 18: Present Imperatives and Future Outlook
What We Like in the Microsoft BI Toolset
Future Directions: Room for Improvement
Conclusion
List of Figures
List of Tables
List of Examples
List of Sidebars