• views: 108
• date: 22 February 2026
• posted by: voska89

What you'll learn

Understand the purpose and rationale behind a dimensional data model
Learn how to follow the Kimball methodology
Hands on design from start to finish, from source data through a Dimensional Model to a visualization
Gain a deep understanding of SCDs, surrogate keys, date dimension, fact types and dimension types

Requirements

A very basic understanding of database design, eg tables, columns and relationships.

Description

A super practical, hands-on course that steps you through the de facto standard for any analytical layer. Learn the reason for using the Kimball approach, and why it is still very relevant today. Build data marts based on your design, incorporating a slowly-changing dimension, date dimension, and role-playing dimension, as well as 2 types of facts. (transactional and snapshot). We will visualise our data marts and refer back to the original business requirement.
Data modeling is the bridge between the Business world and the Technical teams. This source will should you how to bridge that divide through star-schema, facts and dimensions.
Whether your architecture involves an Enterprise Data Warehouse, Delta Lake, Medallion or Data Vault, you will find that a Dimension Layer is the gold standard for further AI models, analytics and reporting.
Be ready to design, build and discover the rationale behind the various design choices, and learn how to apply this thinking in your own environment.
I will step you through installing a MySQL database, use free data modeling software, and write SQL scripts to transform and load data, thereby creating your very own data marts.
This course will give you a solid foundation, and set you up for greater things.

Who this course is for

Aspiring data modelers, BI analysts, Power BI developers, data engineers who would like to understand the reasoning behind the model, data architects




   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.