Course Highlights
  • Learn all the skill sets that is required to become an Analytics Engineer
  • In-depth understanding of data modelling techniques
  • Ability to participate in architectural decision making and be able to create one
  • Data modelling techniques using DBT
  • Learn hands-on skills required to build a Data Warehouse from scratch
  • Boost your resume with most in-demand Analytics Engineer skills
  • Design & Implement a data warehouse
  • Create Data Warehouse Architecture
  • Design Conceptual, Logical & Physical Models
  • Learn various modelling methodologies (Inmon, Kimball, Data Vault, OBT)
  • Apply principles of dimensional data modeling in a hands-on
  • Learn all the concepts and terms such as the OLTP, OLAP, Facts, Dimensions, Star Schema, Snowflake Schema
Curriculum

4 Topics
Introduction
Course Overview
How to get the best out of this course
Resources

18 Topics
Database Introduction
Database definition
SQL Example
Database Management System (DBMS)
Sheets vs Database
OLTP
OLTP ACID
OLAP
OLTP vs OLAP Summary
NoSQL Introduction
Key Value Store
Document Store
Wide Columns
Graph Database
Search Engines
SQL vs NoSQL
On-Prem vs Cloud
Quiz

14 Topics
Data Warehouse Introduction
Data Warehouse Definition
Data Warehouse Benefits
Data Warehouse Architecture
Data Source
Data Lake
Data Warehouse Layer
Business Intelligence Introduction
Business Intelligence Tools
ETL - ELT Introduction
ETL
ELT
ETL vs ELT
Quiz

11 Topics
Data Modelling & Entity Relationship Diagram (ERD) Introduction
Data Modelling Overview
ERD Overview
Entity Attributes Relationships
Steps to Create an ERD
Build ERD using Chen's Notation Style
Build ERD using Information Engineering Notation Style
Data Modelling Concepts
Different Type of Keys
Recommended Tools for Creating ERD
Quiz

9 Topics
What is Normalisation?
1st Normal Form
2nd Normal Form
3rd Normal Form
Pros & Cons of Normalised Model
What is De-Normalisation?
De-Normalisation Techniques
Pros & Cons of De-Normalised Model
Quiz

20 Topics
Data Warehouse Design Methodologies Introduction
Inmon Methodology
Corporate Information Factory (CIF) Architecture Explained
Inmon Architecture
Pros & Cons of Inmon Methodology
Kimball Methodology
Processes of Kimball Methodology
Kimball Architecture
Pros & Cons of Kimball Methodology
Inmon vs Kimball
Hybrid Architecture
Data Vault Methodology Introduction
Data Vault Components
Data Vault Architecture & Example
Pros & Cons of Data Vault
Inmon vs Kimball vs Data Vault
One Big Table (OBT) / Wide Table
Pros & Cons of OBT
Data Modelling Then Now & Next
Quiz

30 Topics
Dimensional Modelling Introduction
What is Dimensional Modelling?
Data Warehouse LifeCycle Overview
Program/Project Planning
Requirement Gathering
Concept & Steps of Dimensional Modelling
Select Business Process & Declare the Grain
Dimensions (Types)
Conformed Dimensions
Junk Dimensions
Degenerate Dimensions
Role Playing Dimensions
Slowly Changing Dimensions (SCD) - Intro
Type 0 - SCD (Slowly Changing Dimensions)
Type 1 - SCD (Slowly Changing Dimensions)
Type 2 - SCD (Slowly Changing Dimensions)
Type 3 - SCD (Slowly Changing Dimensions)
Type 4 - SCD (Slowly Changing Dimensions)
SCD - Store as Snapshots
Bridge Tables
Facts
Additive Facts
Semi-Additive Facts
Non-Additive Facts
Transaction Facts Tables
Periodic Facts Tables
Accumulative Facts Tables
Star Schema
Snowflake Schema
Quiz

6 Topics
BigQuery Setup Introduction
BigQuery Tables Setup using CSV
BigQuery Tables Setup Using SQL Script
Setting up WSL2 for Windows
Git Repository Setup
dbt setup & Installation

29 Topics
Introduction
Hands-on overview
Use-Case Introduction
Use-Case Detailed Discussion
Requirements Gathering
Data Profiling - Introduction
Data Profiling - Completed
AE Workbook - Walkthrough
Bus Matrix - High Level Entities
Conceptual Model
Architecture Design
Dimensional Modelling Introduction
Bus Matrix Detailed
Source to Target Mapping (Source to BQ Data Lake)
Source to Target Mapping (BQ Data Lake to Staging)
Dimensional Model (Attributes & Measures)
Source to Target Mapping (Data Lake to Data Warehouse)
Source to Target Mapping (Data Warehouse to OBT)
Logical Model Design
Physical Model Design
dbt overview
Physical Implementation (Staging Layer)
Physical Implementation (Staging Layer) Cont.
Physical Implementation Dim Tables (Data Warehouse Layer)
Physical Implementation Fact Tables (Data Warehouse Layer)
Physical Implementation (Analytics OBT)
Debugging (dbt)
Adding Tests (dbt)
Hands-on Complete

1 Topic
Glossary

  Write a Review

Analytics Engineering Bootcamp

Go to Paid Course