Skip to content

Latest commit

 

History

History
79 lines (50 loc) · 3.25 KB

README.md

File metadata and controls

79 lines (50 loc) · 3.25 KB
Raw

Supermarket Sales Dashboard

This dashboard provides a comprehensive overview of sales performance for a supermarket shop. It visualizes key metrics such as total sales, total profit, and profit percentage. The dashboard allows filtering by sale type and payment mode, making it a versatile tool for analyzing different aspects of sales data.

Table of Contents

  1. Overview
  2. Features
  3. Dashboard Sections
  4. Usage
  5. Future Enhancements

Overview

The sales dashboard offers a visual representation of the supermarket's sales data for the years 2021 and 2022. It helps in understanding the sales trends, product performance, and payment preferences over different time periods.

Features

  • Total Sales: Displays the total sales value.
  • Total Profit: Shows the total profit earned.
  • Profit Percentage: Indicates the profit percentage.
  • Monthly Sales and Profit: Bar chart showing sales and profit by month.
  • Daily Sales: Line chart displaying daily sales values.
  • Product Performance: Bar chart listing products by sales value.
  • Sales Type Distribution: Pie chart showing the distribution of sales types (e.g., direct sales).
  • Payment Mode Distribution: Pie chart displaying the distribution of payment modes (e.g., online, cash).
  • Top Product and Category: Highlights the top-performing product and category.
  • Category Performance: Treemap showing sales distribution across different categories.

Dashboard Sections

Total Sales, Profit, and Profit Percentage

  • Total Sales: 401.41K
  • Total Profit: 69K
  • Profit %: 21%

Monthly Sales and Profit

A bar chart representing total selling value and profit for each month.

Daily Sales

A line chart that shows daily sales values for a month.

Product Performance

A bar chart displaying sales values for top products (Product41, Product30, Product19, etc.).

Sales Type Distribution

A pie chart illustrating the percentage distribution of different sales types.

Payment Mode Distribution

A pie chart showing the percentage distribution of payment modes (50% Online, 50% Cash).

Top Product and Category

  • Top Product: 132 units (22.95K sales value)
  • Top Category: Category02 (95.27K sales value)

Category Performance

A treemap depicting the sales distribution across categories (Category01, Category02, etc.).

Usage

  1. Filtering: Use the drop-down menus at the top right to filter the data by sale type and payment mode.
  2. Time Period Selection: Select the desired year (2021 or 2022) from the year filter to view data for that year.
  3. Month Selection: Click on a month from the month filter on the left side to view detailed monthly data.

Future Enhancements

  • Interactive Filters: Add more interactive filters for a more granular analysis.
  • Comparison Feature: Implement a feature to compare sales data between different years or months.
  • Export Functionality: Enable exporting the dashboard data to CSV or PDF for offline analysis.

This dashboard is an essential tool for the supermarket shop to track and analyze its sales performance, helping in making data-driven decisions to improve profitability and operational efficiency.