| |
| |
 |
| |
DATA WAREHOUSING COURSE CONTENTS
|
|
Datawarehousing
Fundamentals
Oracle
Discoverer |
| |
| Datawarehousing
Fundamentals |
| |
| Business Intelligence |
- What is Business Intelligence?
- Need of Business Intelligence?
- Key Stages of Business Intelligence
- Components of Business Intelligence
|
|
| Data Warehouse |
- Data Warehouse definition and concepts
- Characteristics of a Data Warehouse
- Components of a Data Warehouse
- Operational Data Store
- Users of a Data Warehouse
|
|
| OLAP |
- What is OLAP?
- Codd Rules for OLAP
- Processing OLAP data
- Storing Active OLAP data
|
|
| Data Marts |
- What is a Data Mart?
- Advantages of a Data Mart
- Dependent and Independent Data Marts
|
|
| Data Warehouse
Design Strategies |
- Top down Approach
- Bottom Up Approach
- Hybrid Approach
|
|
| Data Modeling |
- What is Data Modeling
- Performing Strategic Analysis
- Identifying measures and dimensions
- Creating the dimensional model
- Star Schema model
- Snow Flake Schema model
- Dimensions, Measures, Facts and Summary Tables
- Dimensional Modeling versus ER Diagram
|
| |
|
