arrow_back
Course Introduction
Course Content
Datawarehouse Introduction
What is a Data Warehouse?
Why do we need a Data Warehouse?
Key Features of Data Warehouse
In-Memory Database
Cube
MCQ on basic of Data Warehouse
Core Concepts
OLTP vs OLAP
Database Vs Data Lake Vs Data Marts Vs Data Warehouse
What is Staging Area and Why we need it?
ODS
Difference between ODS and Data Staging Area
Datawarehouse Architecture
Components & Building Blocks of Data Warehouse
Key Approaches to Designing a Data Warehouse
Top-Down Approach
Bottom-Up Approach
Difference between Top-Down Approach and Bottom-Up Approach
Hybrid Approach
Federated Approach
Types of Data Warehouse
MCQ on DataWarehouse Architecture
Data Modeling Fundamentals
Data Modeling
The Building Blocks of Data Modeling
Data modeling building blocks
Data Modeling Phases
Data Modeling Types
Data Modeling Techniques and Applications
Data Modeling Techniques Introduction
Relational Model
ER - Diagram
Relationships & Cardinalities
Importance of ER - Model
Example of ER - Model
Demo : Understanding ER -Model Requirement-Part 1
Demo ER -Model using Lucid Chart-Part 2
ER-Model Walmart
Hierarchial Model
Network Data Model
Dimensional Data Modeling
Dimensional Modeling
Why Dimensional Modeling
Facts
Dimensions
Star Schema
Snowflake Schema
Dimensional Modeling Quiz
Assignment 1: Facts & Dimensions
Assignment 2: Facts & Dimensions (SalesTransactions)
Facts
Additivity in Facts
Handle Nulls in Facts
Year-To-Date Facts
Types of Facts Table
Transactional Fact Table
Periodic Snapshot Fact Table
Accumulating Snapshot Fact Table
Factless Fact Table
Aggregate Fact Table
Choosing the Right Fact Table
Identifying the facts
Dimensions
Types of Dimensions
Conformed Dimension
Role Playing Dimension
Slowly changing Dimension (SCD)
Junk Dimension
Degenerate Dimension
Mini Dimensions
Outrigger Dimensions
Inferred Dimension
Shrunk Dimension
Swappable Dimensions
Choosing the correct Dimension
Dimension MCQ
Identifying types of dimensions
MCQ on Role-Playing Dimensions VS Swapable Dimensions
ETL Process
ETL Introduction
Major Steps in ETL Process
Data Extraction Steps
Transform
Basic Transformations
The Modern Data Warehouse
On-Premise Vs Cloud Data Warehouse
Data Warehouse Migration
Steps for a successful Data Warehouse Migration
Challenges of Data Warehouse Migration
Migration Tools Examples
Case Study: Designing a Data Warehouse
Understanding Problem statement & Design Solution
Demo: Dimension Tables
Demo: Fact Tables
Demo: Data Model
Design, Develop, Deliver: End-to-End Data Warehouse Lifecycle
Data Warehouse Architecture Explained
Data Warehouse Setup
Creating a Date and Time Dimension Table Step-by-Step
Building the Staging Area: OLTP to Staging Table Automation Using ETL
Dimension Table Creation: ETL Process from Staging to Data Warehouse
Fact Table Creation: ETL Process from Staging to Data Warehouse Part 1
Fact Table Creation: ETL Process from Staging to Data Warehouse Part 2
Data to Dashboard: Linking Your Data Warehouse with Reporting Tools
Project: Data Warehouse