Skip to content

Latest commit

 

History

History
17 lines (13 loc) · 1020 Bytes

README.md

File metadata and controls

17 lines (13 loc) · 1020 Bytes

DBT and BigQuery Data Modeling Project

Summary

This is a data modelling exercise based on HR employee data. The dataset comes from the City of Chicago which can be found here. This project follows the 4-step dimensional design process from The Data Warehouse Toolkit by Ralph Kimball and Mary Ross.

Step 1: Select the Business Process Step 2: Declare the grain Step 3: Identify the dimensions Step 4: Identify the facts

DBT Resources

  • Learn more about dbt in the docs
  • Check out Discourse for commonly asked questions and answers
  • Join the dbt community to learn from other analytics engineers
  • Find dbt events near you
  • Check out the blog for the latest news on dbt's development and best practices