Adding the full architecture here below. The goal is to keep the data flow simple, trusted, and reusable across dashboards, Ask Data + AI, inventory storytelling, and action recommendations.

Raw Grocery Data: Stores, Products, Sales, Inventory
↓
Bronze Layer: Raw data stored in Databricks
↓
Silver Layer: Cleaned, standardized, and joined data
↓
Gold Layer: Days of supply, stockout risk, waste risk, and recommended actions
↓
Grocery Data Intelligence App: Dashboard, Ask Data + AI, Inventory Story, and Action Flow
↓
Business Action: Reorder, Monitor, Promote, Discount, or Donate

For more details - https://grocerydataintelligence.com/about