front end dev, back end dev, creative technology
Smart Analytics for Retail
Telling Customer Stories at NRF 2020

Predicting Inventory

Working with Google's retail industry team to build an digital demonstration for inventory management for retailers.

Users access a mobile web app through a device, and are given a recipe to shop for.

Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks

With real products pulled from an Instacart dataset, as users browse and add items to cart, custom recommendations are found using BQML based on 20gb of historical shopping data that was generated.

Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks

As users shop using the web app, Cloud Spanner and BigQuery databases are updated and inventory is pushed to Firebase for realtime access. A warehouse manager dashboard reflects these changes, and provides a mechanism for tracking inventory and receiving suggestions for couponed items.

Google BigQuery Analytics 2019 by Marcus Guttenplan for Sparks
Client
Google

Skills
js
tfjs
python
ML

Team
Winston Parker
Thomas Ryun
Jacki Bigas
Brandon Ewer