Summary
Full Transcript
Join the free boot camp here: https://bootcamp.techcreator.io A setup video for the lab can be found here: https://www.youtube.com/live/9Ng5juIg7LY?si=s9p_Jla7ztT0Pe9W The code and data for the labs is here: https://www.github.com/DataExpert-io/data-engineer-handbook make sure to give this repo a star! Join the paid cloud boot camp here: https://www.dataexpert.io use code LAUNCH20 for 20% off! In this 4 hour course, you will learn: Day 1: - Fact data modeling fundamentals using the Kimball - A lab that creates a proper fact table from game_details Day 2: - Covering the blurry line between fact and dimension. Also the date list data structure! - A lab where we build a date list like they do at Facebook! Day 3: - Covers reduced facts and how to manage shuffling. We cover the long-term analysis framework I built at Facebook - We build a reduced fact table on top of click stream events and devices! Newsletter: https://blog.dataengineer.io IG: https://www.instagram.com/EcZachly X: https://www.twitter.com/EcZachly LinkedIn: https://www.linkedin.com/in/eczachly TikTok: https://www.tiktok.com/@eczachly TIMESTAMPS: 0:00 Course Introduction 3:39 Day 1 Lecture (fundamentals of fact data) begins 52:15 Day 1 Lab (fundamentals of fact data) begins 1:32:31 Day 2 Lecture (the blurry line between fact and dimension) begins 2:03:30 Day 2 Lab (building a datelist data type) begins 2:48:38 Day 3 Lecture (reducing shuffle with reduced facts) begins 3:21:04 Day 3 Lab begins (building reduced facts) begins
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
