This dashboard in excel based on sales data Using piviot table to find
Sum of unit price by Branch
Count of sales by segment
Sum of sales by product
insert slicer for each piviot table
insert piviot chart for all piviots and link them together