Simple Business Intelligence Demonstration

Philippine Retail Example • Fully Offline

How the demonstration works

Change Quantity. Sales is automatically recalculated using the product's Unit Price. Then use filters and grouping to examine the data and identify patterns.
Sales = Unit Price × Quantity

Filters and Grouping

Business Summary

Total Sales
₱0
Transactions
0
Total Quantity
0
Average Sales
₱0

Transaction Data

Quantity is editable. Unit Price is fixed. Sales is automatically calculated and cannot be edited directly.

DateBranchProductUnit PriceQuantitySales

Grouped Sales

Grouping reflects the current filters.

Pattern Finder

Discussion Questions

  1. Which branch has the highest sales?
  2. Which product has the highest sales?
  3. What happens to total sales when quantity is increased?
  4. What happens when you filter to one branch?
  5. Does highest sales automatically mean the branch is the best?
  6. What other information would management need?