Case Study: FreshDirect reduces food waste and optimizes delivery demand with Napkyn's BigQuery solution

A Napkyn Case Study

Preview of the FreshDirect Case Study

Using BigQuery and weather-related data to predict demand and reduce the waste

FreshDirect, a leader in online grocery delivery, partnered with Napkyn to address the challenge of reducing perishable food waste and optimizing its delivery schedules. The company identified weather as a key factor influencing customer demand and needed to share extensive historical data with its partner, Planalytics, for analysis.

Napkyn leveraged BigQuery to build the required reports, writing a series of SQL queries to format historical web and app data. These reports were then sent to Google Cloud Storage, making them available as downloadable CSV files for Planalytics. As a result, FreshDirect optimized its delivery capacity, reduced food waste by two times, and increased revenue by better aligning product availability and delivery slots with predicted demand.


View this case study…

Napkyn

18 Case Studies