Data to Dashboard (Sales & Inventory Reordering Point)

Tennessee Spirit provides Customers, Products and Order Line data. The following are the key findings and Access for information updates.

Raw Data

Monitoring Backlog, Setting Reorder point and quantity

With adjustable score bar, manager can slide the level of reorder point and quantity to see the trend

(Unfortunate Wix does Not support Macro Enable file)

Findings using Excel

Customers Distribution; Product sales Distribution; Sales By Region/Age

Findings using Tableau

Customers Distribution; Product sales Distribution; Sales By Region/Age

Dashboard in Power Pivot and Access

#Excel #Access #Tableau #Data #Sales #Dashboard