---

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