> Markdown version of [/events/world-congress-2026-north-america/sessions/1814-optimizing-coffee](https://www.wearedevelopers.com/events/world-congress-2026-north-america/sessions/1814-optimizing-coffee). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Optimizing Coffee Stand Locations with Gemma 4 and BigQuery


- **Date:** Thursday, Sep 24, 2026
- **Time:** 11:00–13:00 (120 min)
- **Room:** Stage 8
- **Event:** World Congress 2026 North America

## Description

Learn how to leverage open-weights models and data warehousing to solve a spatial analytics problem: finding the most profitable locations for new coffee stands. By analyzing datasets of popular bike routes, we will guide you through building an AI-powered solution using Gemma 4 and the BigQuery Model Context Protocol (MCP) server. You will gain hands-on experience connecting LLMs to enterprise data and learn how to use AI to drive smart, data-driven business decisions.


## Related talks at this congress

- [Managing GPUs by Just Asking, Infrastructure in the Age of MCP](https://www.wearedevelopers.com/events/world-congress-2026-north-america/sessions/1812-managing-gpus-by) — Jessica Garson Beauchemin
- [No Single Model to Rule Them All: Building Resilient AI Agents Across Open & Closed LLMs](https://www.wearedevelopers.com/events/world-congress-2026-north-america/sessions/1671-no-single-model-to) — Emmanuel Acheampong
- [Building AI that fits your business](https://www.wearedevelopers.com/events/world-congress-2026-north-america/sessions/1915-building-ai-that) — Benny Chen
- [Agents That Own Their Inference: Building Production AI Agents on Dedicated GPUs](https://www.wearedevelopers.com/events/world-congress-2026-north-america/sessions/1717-agents-that-own) — Duan Lightfoot

## Watch remotely

Can’t make it to San José? Watch this session live with Pro. You also get:

- All full videos, bookmarks, and playlists
- World Congress livestreams

[See pricing](https://www.wearedevelopers.com/pricing)

## Links

- [Get tickets](https://www.wearedevelopers.com/world-congress-north-america/tickets)