Recente Projetcs

NovaDrive

NovaDrive, an company in the car sales sector, implemented a robust data engineering project to optimize its operations and enhance its sales analytics. This project aimed to collect sales data, process it, and integrate it into a data warehouse (DW) on the Snowflake platform, using Apache Airflow for data orchestration and DBT (Data Build Tool) for advanced analytics.

Relational Sales Database

The first step of the project involved collecting data from different sources within NovaDrive's sales system. This data included sales transactions, customer information, product inventory, and other business-relevant metrics.

Orquestration

In this project, the pipeline orchestrator used is Airflow, running on an Ubuntu server in AWS (EC2). 

Data WareHouse

After processing, the data was loaded into the Snowflake data warehouse.

Camada Analítica

With the data properly stored in Snowflake, the next step was advanced analysis using DBT (Data Build Tool).

Stack

  • AWS
  • Airflow
  • Snowflake
  • DBT

© Copyright 2024- All Rights Reserved