Retail transaction data typically arrives as messy, disconnected extracts. The goal: make it trustworthy and fast to query by landing it raw, cleaning and standardizing it, then modeling it for analytics on sales, customers, and product performance.
Retail transaction data usually arrives as messy, disconnected CSV extracts that nobody fully trusts, so analysts end up cleaning the same data again for every question. A layered warehouse lands the raw data once, cleans it once, and gives the business one tested, documented model for sales, customer, and product questions.
Built on the public Supermarket Transactional Data dataset by Nadin Ramadan on Kaggle. The warehouse design, ETL, tests, and documentation are my own work.
An end-to-end data warehouse in SQL Server that turns raw grocery-transaction CSV extracts into a business-ready star schema. It is built on the public Supermarket Transactional Data dataset on Kaggle; the warehouse design, ETL, tests, and documentation are my own work.
It follows the Medallion pattern: Bronze keeps an untouched copy of the six source files, Silver cleans and standardizes them, and Gold exposes a star schema of views that BI tools and analysts can query directly.
The whole load is automated with stored procedures that log their timing and catch errors, and 21 automated data-quality checks run after each layer: keeping completed orders cut 10M raw transactions to 3.3M and flagged 1.58M orders whose header totals did not match their line items.