Star Schema cung cấp ngữ cảnh cho AI. Mô hình hóa Dimensional là điều cốt lõi.

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.