Promoted articles
Products Profile Deep Dive in Foodics BI
Dashboard Purpose
Use this dashboard if you want to:
- Track and compare the performance of individual products.
- Monitor net sales, cost, and quantity sold for each product.
- Analyze voids and discount amounts to identify issues or trends.
- Evaluate product performance across different branches and time periods.
Note: Product Name must be selected as it is a mandatory filter to view a product’s performance.
Common Use Cases
| Business Question | Where to Find It |
|---|---|
| How do I select the product I want to analyze? | Apply Product Name filter first; the dashboard updates automatically |
| How can I filter the dashboard for a specific time period? | Use Business Day filter (default: last month) |
| How can I compare product performance between branches? | Use Branch Name filter to select your preferred branches |
| How can I track product sales and quantity? | Check Net Sales and Quantity metrics |
| How can I analyze cost, voids, and discounts for a product? | Use Cost, Voids, and Discount Amount metrics |
Keywords (for search functionality)
💡product performance, product comparison, net sales, quantity sold, cost, discounts, voids, branch comparison, product analysis, sales dashboard
Available Filters
| Filter Name | Description | Notes |
|---|---|---|
| Branch Name | Filter data by specific branches | Examples: Abha, Abu Dhabi, Aden |
| Product Name | Filter data by specific product | Examples: BBQ Chicken Pizza, BBQ Chicken Tenders |
| Business Day | Filter data by specific dates | Default value is "Last Month" |
Metrics & Definitions
| Metric | Definition | Notes |
|---|---|---|
| Net Sales | Total sales revenue for the selected product | |
| Cost | Cost of the product sold | Helps calculate profitability |
| Quantity | Number of units sold | Tracks demand for each product |
| Voids | Orders canceled or removed | Helps identify operational issues |
| Discount Amount | Total discounts applied to the product | Useful for analyzing promotions and pricing strategies |