All Case Studies

The Resource Group

Backorder Delivery-Time Analytics

Built a Tableau dashboard delivering evidence-based estimated delivery times to improve backorder management.

Role Data Management & Operations Co-op
Tools Tableau, SQL
Data Scope Operations & backorder data
Timeframe November 2022

The Problem

The team lacked a reliable, data-backed estimate of delivery times, making backorder management reactive.

Approach

I developed a dataset and Tableau dashboard that surfaced evidence-based estimated delivery times, and supported SQL projects to standardize data and improve process efficiency.

Background

Backorder management depended on knowing when items would actually arrive — but delivery-time estimates weren’t grounded in data.

What I Built

I developed a dataset and Tableau dashboard providing evidence-based estimated delivery times, and contributed to SQL-based projects that improved process efficiency and data standardization.

Outcome

  • Evidence-based delivery-time estimates for better backorder decisions
  • More efficient, standardized operational data
  • A clearer, data-driven view for the team

Impact

  • Provided evidence-based estimated delivery times
  • Improved backorder management decisions
  • Enhanced process efficiency and data standardization via SQL

Tools & Methods

TableauOperationsSQLSupply Chain