retail-etl-pipeline-medallion
Turn raw retail data into business-ready analytics.
What it does
Builds a retail data pipeline that turns raw CRM/ERP CSV data into cleaned records and business-ready analytics through Bronze, Silver, and Gold layers.
When to use it
Use when building a retail ETL pipeline or data warehouse for sales, inventory, and analytics using Bronze, Silver, and Gold layers.
How to use it
Give it retail CSV data; it builds an ETL project with sequential Bronze ingestion, Silver transformations, and Gold aggregations.
What you provide
- Your files
Uses
Good to know
- cannot be undone: SQL Server
What you need · 7
Requires Docker with Docker Compose to start the SQL Server container.
Requires SQL Server 2019 or later; the setup starts it in a container.
Access · 3
This skill
SQL Server
Truncates and reloads warehouse tables (irreversible)
GitHub
Downloads the retail pipeline repository