This is a repository created for the Analytics Engineering certification by Indicium Academy and Lighthouse Program. In this project we have to create a conceptual model (Kimball's Star Schema) based on AdventureWorks ERP Model, create a DW (using Google Big Query) and modeling the tables using DBT Core. Then, a data vizualization was created using PowerBi, aiming to answer some core business questions.
- Install the virtualenv with
python -m venv /path/to/new/virtual/environment - Activate the venv
- Run
pip install dbt-core - Install
pip install dbt-bigquery - Run
dbt deps
Try running the following commands:
- dbt run
- dbt test
- Learn more about dbt in the docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the blog for the latest news on dbt's development and best practices