Master Dimensional Modeling Lesson 01 - Why Use a Dimensional Model?
Description
Dimensional Modeling is a popular and effective way to organize your data to maximize business value. In this video, you will learn what a Dimensional Model, aka a Star Schema is and why you should use them to organize your data warehouse. Support me on Patreon https://www.patreon.com/bePatron?u=63260756 Slides https://github.com/bcafferky/shared/blob/master/MasterDimensionalModeling/lesson_01/DimModelingWhy_lesson01.pdf Understanding Dimensional Modeling https://www.youtube.com/watch?v=lWPiSZf7-uQ&t=1476s Should You Use a Data Vault for a Data Lake? by Advancing Analytics https://www.youtube.com/watch?v=RNMoWnSWcTo Databricks Blog: Dimensional Modeling on Databricks https://www.databricks.com/glossary/star-schema
Description from YouTube. Full content on the video page.
More from Bryan Cafferky
NewsMaster Dimensional Modeling Lesson 03 - Understand the ETL Pipeline
The video explains the typical stages of a data warehouse ETL pipeline, including pre-staging (raw data), staging (cleaned data), operational data store (snapshot), and data mart (star schema). It also details the benefits of having multiple stages, such as easier debugging, data recovery, and auditability, and how this maps to the Medallion Architecture (Bronze, Silver, Gold).
TutorialsMaster Databricks 2nd Ed: Lesson 4 - Use Databricks for Free!
Databricks now offers a free edition for learning purposes, providing access to most core features within a serverless environment without requiring a credit card. This free edition has limitations, including small compute resources, no custom cluster allocation, and the absence of R or Scala language support, and is not suitable for sensitive data or production use.
TutorialsMaster Databricks 2nd Ed: Lesson 3 - Understanding Clusters
This video explains Databricks clusters, detailing their components like driver and worker nodes, configuration options such as autoscaling and Photon acceleration, and how to create and manage them within Azure. It also covers common interview questions related to cluster sizing and performance tuning, emphasizing that Databricks clusters are essentially Spark clusters enhanced with the Databricks runtime for cloud environments.
