Promoted articles
Product Mix Deep Dive in Foodics BI
Dashboard Purpose
Use this dashboard if you want to:
- Analyze the top 20 products by Net Sales per branch.
- Understand product pairing ratios (how often two products are sold together).
- Monitor branch-level product mix performance.
- Review order tag and order type details to see how mix ratios vary.
- Optimize menu design, promotions, and bundling strategies.
Example: If 100 pizzas (Product A) were sold yesterday and 10 of those orders also included Coca-Cola (Product B), the mix ratio is 10%.
Note: This report is monthly. Filtering ‘Business Day = Yesterday’ will show results for the month that “yesterday” falls in.
Common Use Cases
| Business Question | Where to Look |
|---|---|
| Where can I filter different branch names? | Use the Branch Name filter to select your preferred branch. |
| Where can I filter by business day? | Use the Business Day filter (default = last month). |
| How do I see which products pair most often with my top sellers? | Check the Branches tab for detailed mix ratios. |
| Which delivery channels (Careem, HungerStation, etc.) affect product pairings? | Use the Order Tags tab. |
| Do product mix ratios vary by dine-in vs delivery? | Use the Order Types tab with the Order Type Name filter. |
| How can I understand the logic behind mix ratio calculations? | Go to the About tab for detailed definitions. |
Keywords (for search functionality)
💡product mix, product pairing, net sales, mix ratio, product A orders, mix orders, branch performance, order tags, order types, top products, bundle analysis, cross-sell, upsell, Foodics BI
Tab / Section Overview
| Tab Name | Description | Example Case |
|---|---|---|
| Branches | Shows detailed product mix ratios and top 20 products by Net Sales for each branch. | A branch manager checks which drinks pair most often with pizzas. |
| Order Tags | Displays product mix by branch order tags (e.g., delivery partners). | A brand wants to know if certain delivery platforms drive different product pairings. |
| Order Types | Shows product mix by branch order types (e.g., Dine In, Delivery). | An operations manager compares mix ratios between dine-in vs delivery. |
| About | Provides detailed definitions, calculation methods, and dashboard purpose. | A new user wants to understand “Product A Orders” |
Here’s the dashboard shown on the Branches tab.
Available Filters
| Filter Name | Description | Notes |
|---|---|---|
| Business Day | Filters data by date. Default is Last Month. | Report is monthly; filtering a day shows data for that entire month. |
| Branch Name | Filters by branch. | Example: Abha, Abu Dhabi. |
| Product Name | Filters by product. | Example: BBQ Chicken Pizza, BBQ Chicken Tenders. |
Metrics & Definitions
| Metric | Definition | Notes |
|---|---|---|
| Product A Orders | Total number of orders in which Product A was included. | Used as the denominator when calculating mix ratios. |
| Mix Orders | Number of orders where both Product Aand Product B were included together. | Used to calculate the pairing ratio with Product A. |
| Major Orders | Represents total orders of the benchmark (Product A). | Indicates the primary product under review. |
| Mix Ratio | (Mix Orders ÷ Product A Orders) × 100 | Shows how often a product (B) is sold with Product A. |