Interactive and Dynamic Dashboard

Dynamic and functional dashboard in Excel

KPI:

Sales, Boxes sold, Profit margin

Data Visualization:

created KPI cards for Total Sales, Profit Margin (Profit %), Total Boxes.

Top 5 Products in each category, and trend charts for sales, boxes and profit

Table to display Sales Person performance based on Product and/or Category selection.

Conditional formatting on Sales and Profit % columns. Implemented dynamic table title based on selection of slicer.