<aside>

Table of Contents

</aside>

Project Overview and Data Pipeline

This project presents the design and implementation of a Sales Data Warehouse based on the Medallion Architecture (Bronze → Silver → Gold).

It combines customer, product, and sales data from ERP and CRM systems into a single structure that supports analytics and business reporting.

The architecture includes three main layers:

• Bronze Layer: collects raw CSV files from the source systems.
• Silver Layer: cleans and standardizes the data.
• Gold Layer: creates business-ready tables for analysis.

The next diagram shows how data flows from one layer to the next during the ETL process.

Database Initialization

The init_database.sql script builds the DataWarehouse database and the three schemas: bronze, silver, and gold.

It first drops any existing database with the same name and then recreates it. This keeps the setup clean and repeatable.

• init_database.sql script (click arrow to reveal)

🥉 Bronze Layer: Raw Data Storage