Project Overview

The Sweet Success Metrics dashboard is a meticulously designed data tool that provides a comprehensive overview of sales performance and product insights, focusing on individual salespersons and overall sales metrics. Key features include:

Sales, Sold Boxes, and Profit Metrics

This dashboard offers a quick view of total sales, sold boxes, and profits, enabling an immediate assessment of overall performance.

Top 25 Sales Persons Analysis

Detailed metrics for the top 25 salespersons, including sales, expenses, profit, profit percentage, and sold boxes, provide a clear picture of individual performance and contribution.

Top 5 Sold Products

A list of the top-selling products and their associated sales and total profits is presented, aiding product management and marketing decisions.

Quarterly Metrics

Bar graphics break down sales, boxes, and profit metrics by quarter, helping users identify seasonal patterns for informed strategic decisions.

Filtering Options

The dashboard’s filtering capabilities based on category and product allow for customized analysis tailored to specific needs.

The dashboard’s design prioritizes a minimal yet highly functional and compact layout, making it easy to navigate and extract critical insights. The use of conditional formatting in sales and profit percentage metrics enhances data readability. Sweet Success Metrics is a potent tool for the chocolate shop, providing valuable insights for both individual and overall sales performance and product management.