Skip to content

The Supermarket Sales Dashboard offers a concise overview of sales performance, featuring key metrics and detailed analyses by product, category, and time period. Interactive filters enable data-driven decisions to improve profitability and efficiency.

Notifications You must be signed in to change notification settings

ahmadayman28/Sales-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

The Supermarket Sales Dashboard offers a concise overview of sales performance, featuring key metrics and detailed analyses by product, category, and time period. Interactive filters enable data-driven decisions to improve profitability and efficiency.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published