Data Warehouse Schedule

A Data warehouse Basics Topics

1 DATA WAREHOUSE

1.1 What is Data Warehouse DAY 1

1.2 Why Data Warehouse

1.3 OLTP Online Transaction Processing

1.4 OLTP VS Data Warehouse ( OLAP)

1.5 Criteria for Selecting a Warehouse

2 DATA WAREHOUSE ARCHITECTURE

2.1 Process View DAY 2

2.2 Data Warehouse Structure

2.3 Schema Design

2.3.1 Dimensions And Facts

2.3.2 Star Schema

2.3.3 Fact Contellation Schema

2.3.4 Snow Flake Schema

3 Data Storage in Data Warehouse

3.1 Data Granularity in Warehouse DAY 3

3.2 Estimate of Data Volume

3.3 Dual Level of Granularity

3.4 What must be the Granularity Level

3.5 How to Control Granularity

3.6 Levels of Granularity

3.7 Partitioning

3.7.1 Why Partitioning

3.7.2 Criterion for Partitioning

3.7.3 Partitioning Examples

3.9 Denormalization

3.9.1 Create Arrays

3.9.2 Selective redundancy

3.9.3 Derived Data

4 DATA TRANSFORMATION

4.1 Loading the Warehouse DAY 4

4.2 Source Data

4.3 Data Quality the Reality

4.4 Data Transformation

4.5 Data Transformation Examples

4.6 Data Transformation Terms

4.7 Data Integration Across Sources

4.8 Data Integrity Problems

4.9 Loading data

4.9.1 Load Techniques

4.9.2 Batch Load Utility

4.10 Load Taxonomy

4.10.1 Incremental Load

4.10.2 Online load

4.11 Refresh

4.11.1 When to refresh

4.11.2 Batch Load Utility

4.11.3 Refresh Techniques

4.11.4 Detecting Changes

5 DBMS FOR WAREHOUSE

5.1 Indexing techniques DAY 5

Bitmap Indexing

Join indexing

Star Join Processing

Bitmap Join Processing

5.2 Parallel Query processing

5.3 Pre Computed Aggregrates

5.4 SQLExtension

5.5 Technological Requirements

5.6 Warehouse Server Products

5.7 Server Scalability

SMP

MPP

5.8 Other Warehouse related Products

Connectivity to Sources

Data ETL

Multi Dimensional Database Engines

Types of LAP

Query/reporting environment

Multidimensional Analysis

6 REVISION AND LEFTOVERS

6.1 Dimensional Modelling DAY 6

6.2 Star Schema Database Design

6.3 Types of Facts

6.4 Snow Flake Schema

6.5 Dimensional Modelling

6.6 Types of OLAP

6.7 OLAP InterfaceArchitecture

6.8 Slowly Changing Dimensions - I , II and III

6.9 Operational Data Source ( ODS )

B Cognos Impromptu Topics

1 Components of Cognos Impromptu DAY 7

1.1 What is Catalog

1.2 Types of Catalog

1.3 Creation of Catalog

2 Catalog Objects

2.1 Tables DAY 8

2.2 Joins

2.3 Databases

2.4 User Profiles

2.5 Folders

2.6 Properties

...