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
Absolute Beginner[ap]s Guide to Project Management
One Title, Many Roles
Creating a Schedule
Identify, Protect, and Track: The Principles of Managing Work Products
The Common Sources of Project Risk
Seven Tips for Sellers
VBScript Programmers Reference
Client-Side Web Scripting
Super-Charged Client-Side Scripting
HTML Applications
Appendix B Variable Naming Convention
Appendix I VBScript Features not in VBA
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Overview of Java UI Toolkits and SWT/JFace
Text Controls
Printing
Programming OLE in Windows
Sample Application
.NET-A Complete Development Cycle
The Need for .NET
Getting Started
Visual Studio.NET: Platform of Choice
GDI+ Graphics Extensions
Dynamic Loading of Components
Java All-In-One Desk Reference For Dummies
Book II - Programming Basics
Making Your Own Classes
Using the Object and Class Classes
Book IV - Strings, Arrays, and Collections
Book IX - Fun and Games
Understanding Digital Signal Processing (2nd Edition)
UNDERSTANDING THE DFT EQUATION
BANDPASS FIR FILTER DESIGN
EXPONENTIAL AVERAGING
COMPUTING THE INVERSE FFT USING THE FORWARD FFT
DC REMOVAL
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