- Welcome! Thank you for learning the Data Warehouse concepts with me!
- Is Data Warehouse still relevant in the age of Big Data?
- Why do we need a Data Warehouse?
- What is a Data Warehouse?
- Characteristics of a Data Warehouse
- What is Business Intelligence?
- Business Intelligence -Extended Explanation
- Uses of Business Intelligence
- Tools used for (in) Business Intelligence
- Enterprise Architecture or Centralized Architecture
- Federated Architecture
- Multi-Tired Architecture
- Components of a Data Warehouse
- Purpose of a Staging Area in Data Warehouse Architecture - Part 1
- Purpose of a Staging Area in Data Warehouse Architecture - Part 2
- Advantages of Traditional warehouse
- Limitations of Traditional Data Warehouses
- What is ODS?
- Define ODS
- Staging Vs ODS
- Differences between ODS,DWH, OLTP, OLAP, DSS
- OLAP Overview
- OLTP Vs OLAP - Part 1_U
- OLTP Vs OLAP - Part 2
- OLAP Architecture - MOLAP
- ROLAP
- HOLAP
- DOLAP
- What is a Data Mart?
- Fundamental Difference between DWH and DM
- Advantages of a Data Mart
- Characteristics of a Data Mart
- Disadvantages of a Data Mart
- Mistakes and MisConceptions of a Data Mart
- Overview of Metadata
- Benefits of Metadata
- Types of Metadata
- Projects on Metadata
- Best Practices for Metadata Setup
- Summary
- What is Data Modeling?
- Data Modeling Techniques
- ER - (Entity Relation) Data Model
- ER Data Model - What is Entity?
- ER Data Model - Types of Entities - Part 1
- ER Data Model - Types of Entities - Part 2
- ER Data Model - Attributes
- ER Data Model - Types of Attributes
- ER Data Model - Entity-Set and Keys
- ER Data Model - Identifier
- ER Data Model - Relationship
- ER Data Model - Notation
- ER Data Model - Logical Data Model
- ER Data Model - Moving from Logical Data Model to Physical Data Model
- ER Data Model - Differences between CDM, LDM and PDM
- ER Data Model - Disadvantages
- What is Dimension Modelling?
- Benefits of Dimensional Modelling
- What is a Dimension?
- What is a Fact?
- Additive Facts
- Semi Additive Facts
- Non-Additive Facts
- FactLess Facts
- What is a Surrogate key?
- Star Schema
- SnowFlake Schema
- Galaxy Schema or Fact Constellation Schema
- Differences between Star Schema and SnowFlake Schema?
- Conformed Dimension
- Junk Dimension
- Degenerate Dimension
- Slowly Changing Dimensions - Intro and Example Creation
- Slowly Changing Dimensions - Type 1, 2 and 3
- Slowly Changing Dimensions - Summary
- Step by Step approach to set up the Dimensional Model using a retail case study
- ER Model Vs Dimensional Model
- What is an Index?
- Bitmap Index
- B-Tree index
- Bitmap Index Vs B Tree Index
- What is Data Integration?
- What is ETL?
- Common Questions and Summary
- ETL - Explained
- ELT - Explained