Napkyn
18 Case Studies
A Napkyn Case Study
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.