Creating a Data Model w/ dbt: Facts (Part 2/3) скачать в хорошем качестве

Creating a Data Model w/ dbt: Facts (Part 2/3)

Download The Modern Data Architecture Checklist (Free PDF) → https://bit.ly/kds-checklist OR Get 1:1 Guidance For Your Small (Or 1-Person) Data Team → https://bit.ly/kds-advising ----- In last week's video, we walked through creating a Warehouse data modeling layer with dbt. More specifically, we covered creating and configuring the Dimension tables. In this video, we're now going to move to introducing the core Fact table into our model. While Dimensions cover "context", the Fact table is all about capturing data points around a "business action". It should be purposely designed around a real analytical need of the business - not just be created to store data for no reason. So in this video, we'll cover key Fact table concepts like: Storing Metrics Connecting to Foreign Keys Putting it all together within the larger strategy Enjoy. 00:00 Creating a Data Model w/ dbt: Facts (Part 2/3) 00:27 Creating the Fact Table 02:01 Table Design 03:50 Connect to Dimensions 05:36 High Level Review 06:00 Dealing With Dates 07:00 Deploying the Model 08:00 Commiting the Changes