Datawarehouse and BusinessIntelligence Concepts

Datawearhouse 

• What is a Data Warehouse?

• Data Warehouse Architectures

• Datawearhouse Architecture Overview

• Data Mart

• Datawearhousing Schemas

• Dimention Data Modeling

• Dimention & types of Dimention

• Fact & Types of Fact

• OLAP vs OLTP

• Types of DataLoading in Datawearhouse(Incremental load & Full Load)

• Operational System In datawearhouse

• Surrogate key in Datawearhouse

• Design Apporach In Datawearhouse

• Physical design In Datawearhouse

• Logical Design In Datawearhouse

• What Is ETL

• Change Data Capture(CDC)

• Data Profiling in Datawarehouse

• BusinessIntelligence (What is BI ?)

Datawearhouse concepts     Data Warehouse Architectures   Datawearhouse Architecture Overview
Data Mart   Datawearhousing Schemas  Dimention Data Modeling  Dimention  Fact  OLAP vs OLTP

Facebook Commentbox