BUSINESS INTELLIGENCE & DATA WAREHOUSING
The road map to Business Intelligence (BI)
Data warehouses compared with Online Transaction Processing (OLTP)
Management information systems and decision support systems (DSS)
Business drivers for data warehouses
Typical uses of a data warehouse
DEFINING DATA WAREHOUSE CONCEPTS AND TERMINOLOGY
Common data warehouse definitions
Data warehouse properties and characteristics
Warehouse development approaches
Components of data warehouse design and implementation
Components of a data warehouse
Data warehouse compared with data mart
Dependent and independent data marts
PLANNING AND MANAGING THE DATA WAREHOUSE PROJECT
Managing financial issues
Obtaining business commitment
Gathering business and user requirements
Evaluating the warehouse project
Implementation processes and requirements
MODELING THE DATA WAREHOUSE
Data warehouse database design phases
Defining the business model
Choosing the architecture
Creating the dimensional model
Using time in the data warehouse
Using summary data
Query rewrite
Creating the physical model
BUILDING THE WAREHOUSE - EXTRACTING DATA
Extracting, transforming, and loading data
Examining data sources
Extracting data
Extraction techniques
BUILDING THE DATA WAREHOUSE - TRANSFORMING DATA
Transforming data: problems and solutions
Resolving quality data issues
Transformation techniques & tools
BUILDING THE DATA WAREHOUSE - LOADING WAREHOUSE DATA
Loading data into the warehouse
Building the loading process
Post-processing of loaded data
Verifying data integrity
REFRESHING WAREHOUSE DATA
Capturing and applying changed data
Batch load requirements
Limitations of methods in applying change
Purging and archiving data
LEAVING A METADATA TRAIL
Defining warehouse metadata
Developing a metadata strategy
Examining types of metadata
Metadata management tools
Common warehouse metadata
MANAGING THE DATA WAREHOUSE
Managing the transition to production
Managing growth
Managing backup and recovery
Identifying data warehouse performance issues