Portfolio Project

Delivery Tip

Excel Geo-Analytics & Optimization

Analytics Excel Power Query
Preview image for Delivery Tip

STAR Summary

Situation
I wanted to know which shifts and neighborhoods lead to better tips.
Task
Owned the end-to-end build, from implementation through the final deliverable.
Action
  • Built a geospatial heat map and pivot filters from 1,251 deliveries.
  • Compared tips by daypart, zone, and order size.
Result
  • Mid-week shifts tended to have higher tips per delivery, while Friday evenings tended to have higher tips per hour.
  • Neighborhood and housing type differences explained a lot of the variation in this dataset.
  • Used the dashboard to make better shift and zone choices over time.