Data Transformation dbt repository

Data pipeline to transform shopping data based on daily forex rates for visualization.

Looker visualization: https://lookerstudio.google.com/reporting/177f7681-8063-4f04-8631-4c6772106fc1

dbt DAG

Data and Tools

Data Sources

• Shopping data source: https://www.kaggle.com/datasets/mehmettahiraslan/customer-shopping-dataset
• Forex source: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/eurofxref-graph-try.en.html

Tools

• Warehouse: Google BigQuery

• Transformation: dbt core

• Visualization: Google Looker Studio

Setting up

How to setup

https://medium.com/@zzzzhenya/following-dbt-fundamentals-with-dbt-core-9edb5b8f12d6

Try running the following commands:

• dbt run
• dbt test

Resources:

• 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