Portfolio Project

Delivery Tip

Excel Geo-Analytics & Optimization

Analytics Excel Power Query

Project Preview

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.

Notes

The Excel workflow is built from personal delivery-ticket history, so the findings are useful for shift planning but not intended as a universal tipping model.