Portfolio Project
Delivery Tip
Excel Geo-Analytics & Optimization
Context
Drivers wanted optimal shift times & zones for higher tips.
Approach
- Built a geospatial heat map and pivot filters on over 2,000 deliveries.
- Compared tip averages by daypart, zone, and order size.
Impact
- Identified Wednesday as the day tips average the highest dollar amount ($8.07/delivery).
- However, Friday is the best day in terms of tips per hour ($10.34/hour).
- Increased weekly earnings by 12% following the insights.
