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
Inside Network Security Assessment: Guarding Your IT Infrastructure
Process for Assessing Risk
Understanding the IT Security Process
Compiling the Needed Documentation
What Do Attackers Do?
Recommendations
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Organizational change
Leading change
Cultural change
IT-based process change
Cisco Voice Gateways and Gatekeepers
The Role of Voice Gateways
Analog Circuits
Connecting to an IP WAN
Dial Plan Considerations
E.164 Number Resolution
802.11 Wireless Networks: The Definitive Guide, Second Edition
Cryptographic Background to WEP
The Temporal Key Integrity Protocol (TKIP)
WWiSE
Windows 2000
11 Performance Tuning
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Working with Ideas
Data Collection
Variation Analysis
Selecting and Testing Solutions
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
Using the Database for Job Storage
Using the JobStoreCMT
Listening for Job Events
What Is a Plug-In?
Configuring the JobStoreTX JobStore
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