Data Warehousing Concepts and Data Warehouse Project Lifecycle

Data Warehousing Concepts

What is Data Warehouse
OLTP vs OLAP : Difference
What is dimensional modeling
What is star schema
What is snowflake schema
What is slowly changing dimension
SCD Type 1
SCD Type 2
SCD Type 3
What is surrogate key
What is Metadata
Whats is ODS
Data Warehouse Conceptual Data Model
Data Warehouse Conceptual Logical Model
Data Warehouse Conceptual Physical Model
Data Warehouse Conceptual Semantic Model

Data Warehouse Project Lifecycle

Data Warehouse Lifecycle
Problem Analysis and Design
Requirement Gathering and Analysis
Prototyping
Environment Setup
Design and Development
Testing
Deployment and Training
Enhancement and Helpdesk

Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!

Related posts:

1. Data Warehouse Project Life Cycle
2. Semantic Data Model
3. Design and Development

Tagged as: Data Warehousing Concepts