raghukovvuru/gosales_project

Data transformation project with dbt using Great Outdoors database

Analytics Engineering project with Great Outdoors dataset.

dbt Project docs url - https://cloud.getdbt.com/accounts/68052/develop/1204134/docs/index.html

dbt Lineage Graph

Technologies Used

• MySQL- as transaction database(OLTP)
• Airbyte- as Extract-Load(EL) tool between MySQL database and Snowflake data warehouse
• Snowflake - as Data Warehouse for loading raw data and performing transformations using dbt
• dbt - as Transformation tool
• Metabase - as data visualization tool

Arctitecture diagram

Sample queries

select products.product_category,sum(sales.sale_total) 
from fct_sales sales 
join dim_products as products
on sales.product_key=products.product_key
group by 1 order by 2 desc;