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