
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 |