The technical build
Trusted grocery data becomes business action.
Trusted grocery data in the lakehouse becomes business metrics, AI-assisted insights, and faster inventory actions.
- 3
- Medallion layers
- 8
- Gold objects
- 1
- Daily 6 AM workflow
- <1s
- Cached page load
Bronze → Silver → Gold
One Unity Catalog schema: workspace.grocery_data_intelligence.*. The app only ever reads Gold.
Raw, append-only
bronze_sales_raw
5,150 rows · +150/day
Cleaned + validated masters
silver_stores (10) · silver_products (15)
silver_sales (5,150) · silver_inventory (150)
Business metrics the app reads
gold_inventory_risk_daily · 150 rows/day
+ 7 business-logic views (KPI, risk, story, actions)
Gold objects powering every screen
gold_inventory_risk_daily
150 rows/dayPer-store, per-product daily risk + recommended action.
vw_dashboard_kpi_summary
Chain-wide KPI tiles on the Dashboard.
vw_top_stockout_risk_products
Lowest days of supply, ranked.
vw_top_waste_risk_products
Closest to expiry, ranked.
vw_store_risk_summary
Per-store attention score.
vw_category_risk_summary
Stockout vs waste, by category.
vw_today_inventory_story
Daily narrative for the Story page.
gold_product_action_recommendations
Per-product recommended action for the Actions page.
From raw store data to confirmed action
Raw Grocery Data
Stores · Products · Sales · Inventory
Databricks Lakehouse
Bronze · Silver · Gold layers
Semantic Layer / UC Metric Views-ready
Days of supply, stockout risk, waste risk, priority, recommended actions
Genie-style Ask Data experience
Natural language over trusted business data
LLM / FM API reasoning layer
Interprets the question, generates business-friendly answers
Action Center
Reorder · Promotion · Discount · Donation · Monitoring
Lakebase-ready OLTP layer
Reorder plans, action status, decisions, feedback history
Business outcomes
Fewer stockouts, less waste, better planning, faster action
Deterministic rules, not a black box
Every recommendation in the app comes from these rules in the Gold view — auditable and identical across Dashboard, Actions, and Story pages.
Stockout risk
- High< 2 days of stock remaining
- Medium2 – 5 days remaining
- Low> 5 days remaining
Waste risk (perishables)
- High≤ 1 day until expiry
- Medium2 – 3 days until expiry
- Low> 3 days until expiry
- N/Anon-perishable items
Recommended actions
Reorder Now— stockout imminent
Discount or Donate— expiry within 1 day
Promote Soon— expiry within 2 – 3 days
Monitor Closely— medium stockout risk
No Action Needed— optimal inventory
One 6 AM job refreshes everything
Daily at 06:00 America/Chicago on a Serverless Starter Warehouse (PRO 2X-Small · Photon · 10-min auto-stop).
Bronze append (+150) → Silver clean & validate → Gold risk + actions → Summary
90-day projection
Day Bronze Silver Sales Gold Risk ───── ────── ──────────── ────────── Day 1 5,150 5,150 150 Day 30 9,650 9,650 4,500 Day 60 14,150 14,150 9,000 Day 90 18,650 18,650 13,500
What's live today, what's next
Databricks Free Edition
CurrentBuild and demo without enterprise setup cost.
Lakehouse Architecture
CurrentFoundation that moves grocery data from raw to clean to business-ready.
Bronze Layer
CurrentRaw stores, products, sales, and inventory data.
Silver Layer
CurrentCleans, standardizes, and joins raw data so it's reliable for analysis.
Gold Layer
CurrentBusiness metrics: days of supply, stockout risk, waste risk, priority, recommended action.
Databricks SQL / SQL Warehouse
CurrentPowers the app, dashboard, Ask Data + AI, and approved views.
Gold Views
CurrentSurfaces trusted data to the app instead of raw tables.
Unity Catalog
CurrentCatalog / schema / table / view governance for trusted data assets.
Semantic Layer (concept)
CurrentConsistent business definitions across dashboard, Ask Data, and actions.
AI/BI Genie-style experience
CurrentPlain-English questions answered from trusted data — live for some intents today, powered by a Databricks-hosted Foundation Model.
UC Metric Views
NextNative Databricks semantic layer for reusable metrics like days of supply and reorder priority.
Materialized / Serving Tables
NextFaster dashboard and AI queries as data grows.
Lakebase
NextStore action state — reorder plans, task status, user decisions, feedback history.
Databricks Apps
NextHost the app closer to Databricks data and security.