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 |
| 9 | ETL | ETL |
| 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 |
Author Description
