Dimensional Data Modeling

1h 37m 57s
English
Paid

In today's world, where data plays a key role, effective organization of information is the foundation for quality analytics and report building. Multidimensional data modeling is an important approach that allows structuring data for quick access and informed decision-making.

This course provides a detailed introduction to the fundamental concepts of dimensional modeling. You will learn how fact and dimension tables work, what slowly changing dimensions (SCD) are, as well as the different types of fact tables.

During the course, you will gain practical experience in setting up and working with a data warehouse using real tools - DuckDB and DBeaver. By the end of the training, you will confidently understand how to design a data model for high-performance analytics and reporting.

Read more about the course

Course includes:

Introduction to Data Warehouses

You will learn the basics of building warehouses and their importance for analytical processing. Discover how a data warehouse consolidates information from various sources for fast and scalable analysis.

Basics of Dimensional Modeling

You will become acquainted with key elements: dimensional and fact tables. You will learn how to design a data structure for analytics, determine business metrics, find suitable dimensions, and link them together. Through practical examples, you will master the principles of building a meaningful and efficient data model.

Setting Up a Data Warehouse

You will learn to work with DuckDB and DBeaver: create tables, manage them, and prepare the environment for analytics. The module includes step-by-step instructions for setting up the environment and deploying your first warehouse.

Working with a Data Warehouse

Dive into advanced topics: learn to handle slowly changing dimensions (SCD), work with different types of fact tables - transactional and cumulative. You will understand how to track business events and trends, as well as optimize queries and analyze large volumes of data.

Watch Online Dimensional Data Modeling

Join premium to watch
Go to premium
# Title Duration
1 Introduction 01:58
2 Course Goals 02:06
3 Intro to Data Warehousing 06:43
4 Approaches to building a data warehouse 05:21
5 Dimension tables explained 05:35
6 Fact tables explained 06:35
7 Identifying dimensions 03:17
8 What is duckdb 05:59
9 First DuckDB hands-on 02:21
10 Creating tables in duckdb 02:41
11 Installing dbeaver 06:50
12 Exploring scd0 and scd1 19:58
13 Exploring scd2 13:53
14 Exploring transaction fact table 06:29
15 Exploring accumulating fact table 07:18
16 Conclusion 00:53

Similar courses to Dimensional Data Modeling

Data Engineering on Databricks

Data Engineering on DatabricksAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 27 minutes 29 seconds
Building APIs with FastAPI

Building APIs with FastAPIAndreas Kretz

Category: Python, Data processing and analysis
Duration 1 hour 35 minutes 40 seconds
Complete Machine Learning and Data Science: Zero to Mastery

Complete Machine Learning and Data Science: Zero to Masteryudemyzerotomastery.io

Category: Data processing and analysis
Duration 43 hours 22 minutes 23 seconds
PyTorch for Deep Learning and Computer Vision

PyTorch for Deep Learning and Computer Visionudemy

Category: Data processing and analysis
Duration 10 hours 20 minutes 51 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
PyTorch for Deep Learning with Python Bootcamp

PyTorch for Deep Learning with Python Bootcampudemy

Category: Python, Data processing and analysis
Duration 17 hours 2 minutes 14 seconds
dbt for Data Engineers

dbt for Data EngineersAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 52 minutes 55 seconds
Deep Learning A-Z™: Hands-On Artificial Neural Networks

Deep Learning A-Z™: Hands-On Artificial Neural Networksudemy

Category: Python, Data processing and analysis
Duration 22 hours 36 minutes 30 seconds
Statistics for Data Science and Business Analysis

Statistics for Data Science and Business Analysisudemy

Category: Data processing and analysis
Duration 4 hours 49 minutes 30 seconds
Statistics Bootcamp (with Python): Zero to Mastery

Statistics Bootcamp (with Python): Zero to Masteryzerotomastery.io

Category: Python, ChatGPT, Data processing and analysis
Duration 20 hours 50 minutes 51 seconds