Skip to content

Onboarding a New Brand - Data Engineering

Step-by-step Guide

1. Create Brand Master Records

  1. Insert Brand into Master Tables
    • Add new record to ORBITAL_KITCHENS_STAGE.MASTER_FILES.BRAND_MAP
      • Use next highest integer as brand ID
      • Enter official brand name
    • Add new record to ORBITAL_KITCHENS_DW.DW.BRAND_MASTER
      • Use same brand ID and name

2. Configure Brand Mappings in Snowflake

  1. Station Mapping
    • Add station mapping to ORBITAL_KITCHENS_DW.DW.V_BRAND_TO_STATION_MAPPING
    • Push changes to GitHub

3. Update Sigma Custom Functions

  1. Brand Mapping Function
    • Navigate to Sigma admin/settings
    • Update ActiveBrands custom function to include new brand
    • Update BrandToStationMapping custom function
    • Update BrandToPrinterMapping custom function
    • Update BrandToExpoMapping custom function
    • Update BrandToCuisineMapping custom function

4. Update Sigma Dashboard Manual Mappings

Update manual brand and cuisine mapping formulas in the following dashboards:

  1. Daily Kitchen Performance Review

    • Order Issues table → Brand ID mapping
    • Historical Cancellation Categorization table → Brand ID mapping
    • Ratings table → Brand ID mapping

  2. Customer Ratings Dashboard

    • Ratings table → Official Brand Name mapping
    • Add new brand to Brand Sections input table

  3. Weekly Review Report

    • Ratings table → Brand ID mapping
    • Uber Targeted Item Rating table → Brand ID mapping

  4. Midweek Review Report

    • Ratings table → Brand ID mapping

  5. Ops Metrics Order Issues Dashboard

    • Order Issues table → Brand ID mapping
    • Issues by Employee table → Brand ID mapping

  6. Weekly Food Quality Report

    • Ratings table → Brand ID mapping

  7. Weekly Kitchen Announcements

    • Order Issues table → Official Brand Name mapping

Only complete this section if the brand requires a new station

  1. Daily Kitchen Performance Review

    • Orders table → Add to Station with Target field
    • Ratings table → Add to Station with Target field

  2. Weekly Food Quality Report

    • Orders table → Add to Station with Target field
    • Ratings table → Add to Station with Target field

  3. Weekly Kitchen Announcements

    • Order Issues table → Add to Grouped Station field

6. Update Chatbot Configuration (If Multiple Brand Names)

Only complete if brand has >= 2 names in BRAND_MAP (e.g., "Nimbu" and "Nimbu - Fresh Modern Indian")

  1. Update Chatbot Configuration
    • Update chatbot orders semantic view custom instructions to add the brand name mapping
    • Once station mappings are in the model, this step will also require updating that logic

7. Menu Item Master Data Setup

  1. Create Master IDs for Menu Items
    • Coordinate with Anh to receive list of new menu items for review
    • Once approved, use Change Log App to create master IDs
    • Verify all menu items are properly logged

8. ERP Configuration

  1. Add Transfer Units
    • Add new transfer units to ERP system for the brand
    • Ensure proper unit of measure and inventory tracking setup

9. Create Bills of Materials

  1. Prep Recipes

    • Create BOMs for all new prep recipes in the system

  2. Menu Items

    • Create BOMs for all new menu items
    • Link to appropriate prep recipes and ingredients