Flylib.com
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
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
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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Using a Web Service as a Data Source
Merging Data
Specifying Locking Hints in a SQL Server Database
Using XSD Schema Files to Load and Save a DataSet Structure
Listing Installed OLE DB Providers
Metrics and Models in Software Quality Engineering (2nd Edition)
Software Quality Metrics Overview
Product Quality Metrics
Examples of Metrics Programs
The Rayleigh Model
The Summarization Phase
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Team change
Leading change
Part II - The Applications
Restructuring
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Two Principles
Chapter Four Precall Planning and Research
Chapter Eight Creating Visions Biased to Your Solution
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Appendix A Value Justification Example
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Project A: Build a Connection Document Database
Troubleshooting
How to Set the ReturnReceipt for LotusScript-Generated Email
Create a Custom Application Interface
Exporting Data
Python Programming for the Absolute Beginner, 3rd Edition
Python/Tkinter for Tcl/Tk Converts
Advanced GUI Coding Techniques
Utility Modules
Browsing PyErrata Reports
Section A.2. Major Changes in 1.6
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies