Dynamic-Sales-Analytics-Pipeline-with-dbt-and-BigQuery

This project demonstrates a dynamic, scalable data analytics pipeline built using Google BigQuery and dbt (data build tool) to transform raw sales data into analytics-ready datasets.

The pipeline follows modern data engineering best practices, including ELT architecture, modular data modeling, and automated transformations, enabling efficient reporting and business insights.

Architecture

Source Data → BigQuery → dbt Models → Analytics Layer

Raw sales data is stored in BigQuery

dbt is used to:

Transform raw data into clean staging models

Build fact and dimension tables

Apply business logic and calculations

Final models are optimized for BI tools and analytics

Technologies Used

Google BigQuery – Cloud Data Warehouse

dbt Core – Data transformation and modeling

SQL – Data transformations and analytics