Welcome! Thank you for learning the ETL Testing Course with me!
- Welcome! Thank you for learning the ETL Testing Course with me!
Before we start
- What is Data Testing/ETL Testing and the Challenges in ETL testing?
- What will be the future of ETL tools/testing as big data is getting popular?
The Basics - Data warehouse Concepts course
- Master Data Warehouse Concepts, Step by Step from Scratch
- Is Data Warehouse still relevant in the age of Big Data?
- What is Data?
- Why Data Warehouse is implemented?
- What is a Data Warehouse?
- Test your understanding on the Data Warehouse basics
Data Mart
- What is a Data Mart?
- Fundamental difference between Data Warehouse and Data Mart
- Advantages of a Data Mart
- Characteristics of a Data Mart
- Disadvantages of a Data Mart
- Mistakes and Misconceptions of a Data Mart
- Test your understanding on the Data Mart Concepts
Data Warehouse Architectures
- Revised: Enterprise Architecture or Centralized Architecture
- Revised: Federated Data Warehouse Architecture
- Multi Tired Architecture
- Components of a Data Warehouse Architecture
- Purpose of a Staging Area in Data Warehouse Architecture - Part 1
- Purpose of a Staging Area in Data Warehouse Architecture - Part 2
- Test your understanding on the Data Warehouse Architecutre
Dimensional Modeling
- What is Data Modeling?
- Why should a Tester know Data Modeling?
- Data Modeling Techniques
- ER Data Model
- Dimensional Model
- Differences between ER Model and Dimensional Model
How to build a Dimensional Model?
- Different phases required to build a Dimensional Data Model
- Business Requirements
- CDM - Conceptual Data Model
- LDM - Logical Data Model
- Physical Data Model
- Database
- Test your understanding
Various Objects in a Dimensional Model
- What is a Dimension Table?
- What is a Fact Table?
- Additive Facts
- Semi Additive Facts
- Non-Additive Facts
- Fact less Facts
- What is a Star Schema?
- What is a Snow Flake Schema?
- Galaxy Schema or Fact Constellation Schema
- Snow Flake Vs Star Schema
- Conformed Dimensions
- Junk Dimensions
- Degenerate Dimensions
- Role Playing Dimensions
- Slowly Changing Dimensions - Intro and Example Creation
- Slowly Changing Dimensions (SCD) Type 1, 2, 3
- Slowly Changing Dimensions - Summary
- Test your understanding on Dimensional Model Objects
Data Integration and ETL
- What is Data Integration?
- What is ETL?
- Data Acquisition
- Data Transformation
- Common Questions and Summary
- Test your understanding on Data Integration and ETL
ETL Vs ELT
- ETL - Explained
- ELT - Explained
- ETL Vs ELT
Typical Roles In DWH Project
- Project Sponsor
- Project Manager
- Functional Analyst or Business Analyst
- SME - Subject Matter Expert
- DW BI Architect and Data Modeler
- DWH Tech Admin
- ETL Developers
- BI OLAP Developers
- ETL Testers / QA Group
- DB UNIX Network Admins
- Data Architect, Data Warehouse Architect, BI Architect and Solution Architect
- Final Note about the Roles
- Test your understanding on different roles in a DWH project
DW/BI/ETL Implementation Approach
- Different phases in DW/BI/ETL Implementation Approach
- Knowledge Capture Sessions
- Requirements
- Architecture Phase
- Data Model/Database
- ETL Phase
- Data Access Phase
- Data Access Types - Selection
- Data Access Types - Drilling Down
- Data Access Types - Exception Reporting
- Data Access Types - Calculations
- Data Access Types - Graphics and Visualization
