Case study
Data PipelineSQLPythondbt
Supply Chain KPI Pipeline
Automated ELT pipeline landing data from the ERP, a 3PL API, and supplier scorecards into Snowflake, powering a daily on-time-delivery and inventory-health report for the operations team.
Case study
Variation 1/3
Question
How can supply chain kpi data be reliably collected, cleaned, and delivered at scale?
Approach
Using SQL, Python, and dbt, the data was ingested, cleaned, and structured — automated ELT pipeline landing data from the ERP, a 3PL API, and supplier scorecards into Snowflake, powering a…
Result
Automated ELT pipeline landing data from the ERP, a 3PL API, and supplier scorecards into Snowflake, powering a daily on-time-delivery and inventory-health report for the operations team.
Hover a row to edit · changes save to your portfolio
