Data Warehouse & Its Best Practices Warehouse & Its Best Practices

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.

No Title Link
0 Syllabus RPS
Course Rules
1 Introduction to DW Intro to DW
2 DW Architecture DW Architecture
3 DW Development Phase DW Deveopment Phase
4 Data Quality in DW Development Phase DQ in DW Deveopment
5 DW Framework with DQ Consideration DW Framework with DQ
6 DW Requirements Analysis Requirements Analysis
7 DW Conceptual Design Conceptual Design
8 DW Logical Design Logical Design
10 Physical Design Physical Design
11 DW Benefits DW Benefits
12 OLAP Operations & Query OLAP Operations and Query
13 DW Optimization DW Optimizations
14 Building the DW & Case Study Sample OLAP Pivot Table

Intro to Pivot Table

Author Description