Retail Etl Medallion Pipeline

This builds a complete three-layer data warehouse for retail operations with all the messy real-world stuff: inventory shrinkage calculations, meat yield conversions for recipes, supplier rebate tiers, and multi-branch consolidation. It's TSQL stored procedures organized into bronze (raw CSV ingestion), silver (business rules and quality scoring), and gold (aggregated metrics like turnover ratios and reorder alerts) layers. You get the full pipeline from Docker Compose setup through each transformation stage, plus Power BI dashboards. Useful if you're building a retail analytics system from scratch and want a working reference implementation instead of just architectural diagrams. The procedures are verbose but show practical patterns for handling perishables, stock discrepancies, and branch-level reporting.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill retail-etl-medallion-pipeline --agent claude-code