Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Data Warehouse Concepts from Scratch and become an Expert
Brief about the Data warehouse
Is Data Warehouse still relevant in the age of Big Data? (4:25)
Why do we need a Data Warehouse? (5:26)
What is a Data Warehouse? (5:48)
Chareterstics of a data warehouse (5:43)
Quiz: Test your understanding on what is a Data Warehouse
Business Intelligence
What is Business Intelligence? (5:37)
Business Intelligence -Extended Explanation (3:34)
Uses of Business Intelligence (8:02)
Tools used for (in) Business Intelligence (6:25)
Quiz: Test your understanding on Business Intelligence
Data Warehouse Architectures
Enterprise Architecture or Centralized Architecture (4:08)
Federated Architecture (2:49)
Muitli Tired DWH Architectures (3:13)
Components of a Data Warehouse (3:57)
Purpose of a Staging Area in Data Warehouse Architecture - Part 1 (4:43)
Purpose of a Staging Area in Data Warehouse Architecture - Part 2 (3:35)
Advantages of a Traditional Data Warehouse (2:30)
Limitations of Traditional Data Warehouses (6:02)
Quiz: Test your understanding on DWH Architectures
ODS - Operational Data Store
What is ODS? (2:20)
Define ODS (8:41)
Features and Benefits of ODS (2:18)
Differences between ODS,DWH, OLTP, OLAP, DSS (4:01)
Quiz: Test your understanding on ODS
OLAP - Online Analytical Processing
OLAP Overview (5:56)
OLAP Vs OLTP Part 1 (4:33)
OLAP Vs OLTP Part 2 (6:01)
OLAP Architecture - MOLAP (6:36)
ROLAP (3:40)
HOLAP (2:28)
DOLAP (1:28)
Quiz: Test your understanding on OLAP
Data Mart
What is a Data Mart? (1:47)
Fundamental Difference between DWH and DM (0:36)
Advantages of a Data Mart (2:40)
Charecteristics of a Data Mart (4:00)
Disdvantages of a Data Mart (3:13)
Mistakes and MisConceptions of a Data Mart (2:15)
Quiz: Test your understanding on Data Marts
Metadata
Overview of Metadata (1:57)
Benefits of Metadata (1:46)
Types of Metadata (5:32)
Metadata Project Setup (5:34)
Best Practices for Metadata Setup (1:30)
Summary for Metadata (3:16)
Quiz: Test your understanding on Metadata
Data Modeling
What is Data Modeling? (2:13)
Data Modeling Techniques (3:53)
Entity Relational Data Model
ER Data Model (3:41)
ER Modelling Logical Design - What is an Entity? (1:59)
ER Modelling Logical Design - Types of Entities Part 1 (4:01)
ER Modelling Logical Design - Types of Entities Part 2 (2:09)
ER Modelling Logical Design - Attributes (1:55)
ER Modelling Types of Attributes (4:01)
ER Modelling Entity Set and Keys (2:44)
ER Modelling Logical Design - Identifier (2:02)
ER Modelling Logical Design - RelationShip (1:16)
ER Modelling Logical Design - Notation (2:37)
ER Modelling Logical Design - Logical Data Model (1:29)
ER Data Model - Moving from Logical Data Model to Physical Data Model (2:26)
ER Data Model - Differences between CDM, LDM and PDM (3:31)
Disadvantages of ER Model (3:33)
Quiz: Test your understanding in ER Data Model
Dimensional Model
What is Dimensional Modeling? (4:39)
Benefits of Dimensional Modeling (1:50)
What is a Dimension? (2:48)
What is a Fact? (2:05)
Types of Facts - Additive (1:45)
Types of Facts - Semi Additive (2:28)
Types of Facts - Non Additive (1:30)
Types of Facts - FactLess (2:29)
What is a Surrogate Key? (4:01)
Star Schema (5:23)
SnowFlake Schema (3:25)
Galaxy Schema or Fact Constellation Schema (2:20)
Differences between Star and SnowFlake (5:27)
Conformed Dimensions (6:38)
Junk Dimension (3:06)
Degenerate Dimension (3:35)
Slowly Changing Dimensions Introduction and Example Preparation (25:44)
Slowly Changing Dimensions Type 1 2 3 (12:30)
Slowly Changing Dimesnsions - Summary (3:33)
Step by Step approach to set up the Dimensional Model using a retail case study (7:28)
ER Model Vs Dimensional Model (5:51)
Quiz: Test your understanding on Dimensional Model
DWH Indexes
What is an Index? (2:12)
BitMap Indexes (4:17)
BTree Indexes (1:56)
BTree Vs BitMap (3:22)
Quiz: Test your understanding on DWH Indexes
Data Integration and ETL
What is Data Integration? (6:49)
What is ETL? (4:19)
Common Questions on DI and ETL (2:49)
Quiz: Test your understanding on Data Integration and ETL
ETL Vs ELT
ETL - Explained in detail (6:41)
ELT - Explained in detail (5:57)
ETL Vs ELT Differences (2:23)
ETL - Extraction Transformation & Loading
ETL Buy Vs Build (5:10)
ETL Tools for Data Warehouses (1:56)
Full and Incremental Extraction (5:43)
Differences between Full Vs Incremental Loads (1:27)
Quiz: Test your understanding on Full and Incremental loads in ETL
Typical Roles In DWH Project
Project Sponsor (3:24)
Project Manager (1:46)
Functional Analyst or Business Analyst (2:53)
SME - Subject Matter Expert (4:17)
DW BI Architect (3:07)
DWH Tech Admin (1:20)
Data Modeler (8:59)
ETL Developers (1:56)
BI OLAP Developers (1:29)
ETL/QA Testers (1:58)
DB UNIX Network Admins (0:56)
Data Architect, Data Warehouse Architect, BI Architect and Solution Architect (9:57)
Final Note about the Roles (2:16)
DW/BI/ETL Implemetation Approach
Different phases in DW/BI/ETL Implementation Approach (1:51)
Knowledge Capture Sessions (3:34)
Requirements (7:21)
Architecture Phases (4:48)
Data Model/Database (1:35)
ETL Phases (2:43)
Data Access Phases (2:10)
Data Access Types - Selection (1:37)
Data Access Types - Drilling Down (0:58)
Data Access Types - Exception Reporting (0:36)
Data Access Types - Calculations (1:26)
Data Access Types - Graphics and Visualization (0:58)
Data Access Types -Data Entry Options (2:04)
Data Access Types - Customization (1:00)
Data Access Types - WebBased Reporting (0:56)
Data Access Types - BroadCasting (1:05)
Deploy (1:42)
Iterative Approach (3:25)
ER Modelling Types of Attributes
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock