dbt build Star Schema using dimensional modeling | data modeling with dbt | build dims & fact | P4

BI Insights Inc
BI Insights Inc
3.8 هزار بار بازدید - 12 ماه پیش - In this installment of the
In this installment of the DBT series we build Dimensions and Facts tables using our staging models. Our DBT project takes the shape of an actual Data Warehouse. We code model dimensions and fact table definitions, log all the tables in the schema.yaml file. We utilize DBT various packages and built in functions to build data dimension, surrogate keys and model references. Finally, we review the data model's lineage using DBT Docs.

Link to the whole series: https://hnawaz007.github.io/mds.html

Link to previous video in this series:
Transform data with DBT | Stage raw t...

DBT build a Datawarehouse using Kimba...

Link to GitHub repo: https://github.com/hnawaz007/dbt-dw

DBT packages: https://docs.getdbt.com/docs/build/pa...


#dbt #datawarehouse  #etl

💥Subscribe to our channel:
haqnawaz

📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣

🔗 GitHub: https://github.com/hnawaz007
📸 Instagram: Instagram: bi_insights_inc
📝 LinkedIn: LinkedIn: haq-nawaz
🔗 Medium: hnawaz100

-----------------------------------------


Topics covered in this video:
==================================
0:00 - Recap of the series
0:40 - Introduction to dbt agenda
1:01 - Configuration Updtes to packages & package yaml
1:53 - Source and Final Schema Compare
3:09 - Create Address Dimension (Dnormalization & Surrogate Key)
6:18 - Customer Dimension
7:54 - Date Dimension using dbt_date package
9:26 - OrderStatus Dimension
9:44 - Product Dimension
9:59 - Sales Territory Dimension
10:14 - Fact Table
11:13 - Run all models & Preview Schema ERD
11: 48 - DBT DAGs: Data & Model Lineage
13:17 - Recap & Looking ahead
12 ماه پیش در تاریخ 1402/05/10 منتشر شده است.
3,848 بـار بازدید شده
... بیشتر