The MicrosoftВ Data Warehouse Toolkit: With SQL ServerВ 2005 and the MicrosoftВ Business Intelligence Toolset
Introduction
- BETTER LATE THAN NEVER
Chapter 1: Defining Business Requirements
- ENTERPRISE VERSUS PROJECT
- BUSINESS PROCESS: THE DW/BI SYSTEM UNIT OF WORK
- A CREDIBILITY BOOSTER
- ALTERNATIVES TO INDIVIDUAL INTERVIEWS
- THE HISTORY OF ADVENTURE WORKS
- THE NAME GAME IN ACTION
Chapter 2: Designing the Business Process Dimensional Model
- THE POWER OF DIMENSIONS
- HOW SLOW IS SLOW?
- RECURSIVE CAPABILITIES
- DATA-DRIVEN MODELS VERSUS BUSINESS REQUIREMENTSDRIVEN MODELS
- TREAD LIGHTLY
- TRACKING HISTORYONCE MORE WITH FEELING
Chapter 3: The Toolset
- USE BOTH RELATIONAL AND OLAP DATA STORES
- INTEGRATE DEVELOPMENT DATABASES EARLY
- EDITIONS AND FEATURES OF SQL SERVER 2005
Chapter 4: Setup and Physical Design
- COMPARING DATABASE SIZES
- HOW POWERFUL SHOULD DEVELOPMENT AND TEST SYSTEMS BE?
- SQL SERVER 2000/2005 CHANGE: ANALYSIS SERVICES METADATA
- INDEXING VERY LARGE DIMENSIONS
- PSEUDO-PARTITION CHARACTERISTICS
- PARTITIONED TABLE LIMITATIONS
Chapter 5: Designing the ETL System
- SQL SERVER 2000/2005 CHANGE: DATA TRANSFORMATION SERVICES
- SORTING AND AGGREGATING LARGE DATASETS
- A CAUTIONARY TALE
- THE IDEAL PACKAGED BI MODULE
- THE SAP .NET PROVIDER
- ANOTHER CAUTIONARY TALE
- STAGE FACT DATA FOR RECOVERABILITY
Chapter 6: Developing the ETL System
- SCRIPTS WITH MULTIPLE INPUTS OR OUTPUTS
- ITS NOT OUR PROBLEM
- SIMILARITY VERSUS CONFIDENCE
- INTEGRATION SERVICES RAW FILES
- MORE ON THE OLE DB COMMAND TRANSFORM
- PRECEDENCE CONSTRAINT CONDITIONS
- ADVANCED TOPIC: LATE ARRIVING FACTS
- PARTITIONED FACT TABLES
- AN EVEN SIMPLER AUDITING SYSTEM
Chapter 7: Designing the Analysis Services OLAP Database
- WHATS NEW IN ANALYSIS SERVICES 2005 OLAP ENGINE?
- STARTING THE ANALYSIS SERVICES SERVER
- RUNNING THE CUBE WIZARD: THE ONE-CLICK CUBE
- ANALYSIS SERVICES DIMENSION TERMINOLOGY
- BUILD THE DIMENSION WITHOUT USING A DATA SOURCE
- CONFORMED DIMENSIONS
- ATTRIBUTE HIERARCHIES
- ANALYSIS SERVICES CUBE TERMINOLOGY
- THOSE PESKY ATTRIBUTE RELATIONSHIPS AGAIN
- WHERE TO GO FOR HELP
- CUBE PHYSICAL STORAGE TERMINOLOGY
Chapter 8: Business Intelligence Applications
- VIPS
- THE DANGER OF DASHBOARDS
- THE BASIC BUSINESS ANALYSIS CYCLE
Chapter 9: Building the BI Application in Reporting Services
- LEARNING REPORTING SERVICES
- REPORT DEFINITION LANGUAGE
- REPORT BUILDER
- THE LIMITS OF SECURITY
- REPORTING SERVICES WORKAROUNDS
- TWEAKING THE REPORT LAYOUT
- TABLE-DRIVEN REPORT DISTRIBUTION
Chapter 10: Incorporating Data Mining
- THE POWER OF NAMING
- ADDITIONAL INFORMATION ON THE DATA MINING PROCESS
- SECURITY
- WORKING WITH THE TREE VIEWER
Chapter 12: Security
- UNEXPECTED VALUE OF OPEN ACCESS
- DATA ACCESS POLICY
- SAMPLE DATA SENSITIVITY DOCUMENT
- SOME COMMENTS ON THE SCALABILITY OF DIMENSION SECURITY
- SPECIAL PRIVILEGES FOR POWER USERS
Chapter 13: Metadata Plan
- IN THEIR OWN WORDS
- METADATA, META DATA, OR META-DATA?
- THE METADATA SCHEMA AND THE ENHANCEMENT PROCESS
Chapter 14: Deployment
- USING INTEGRATION SERVICES CONFIGURATIONS
- BE EXTRA CAREFUL WITH ANALYSIS SERVICES DEPLOYMENTS
- REPORT DEPLOYMENT PROCESS
- INTRODUCTORY ONE-DAY AD HOC QUERY COURSE OUTLINE
Chapter 15: Operations and Maintenance
- REMOTE PACKAGE EXECUTION
- INCREMENTAL BACKUPS
Chapter 16: Managing Growth
- THE COMPETITIVE SPIRIT
- STEALTH MARKETING
Chapter 17: Real-Time Business Intelligence
- LOCATION OF THE REAL-TIME LAYER
- WHY USE BUSINESS KEYS IN THE REAL-TIME LAYER?
- REVIEW OF STORAGE MODE (MOLAP, HOLAP, ROLAP)
- RECOMMENDED STORAGE MODE
- WHATS ALL THIS ABOUT CACHING?
- SAMPLE POLLING AND PROCESSING QUERIES