Online Sales Dashboard

Overview

This Excel-based dashboard provides a comprehensive view of sales data, enabling businesses to track and analyze their sales performance across various dimensions.

Features

• Tracks key sales metrics:
  • Date
  • Product Category
  • Product Name
  • Units Sold
  • Unit Price
  • Total Revenue
  • Region
  • Payment Method
• Visual representations of data trends
• Easy-to-use interface for data input and analysis

Requirements

• Microsoft Excel (version 2010 or later recommended)

Installation

1. Download the OnlineSalesDataset.xlsx file from this repository.
2. Open the file using Microsoft Excel.

Usage

1. Input your sales data into the 'Data' sheet.
2. Navigate to the 'Dashboard' sheet to view automatically updated charts and metrics.
3. Use filters and slicers to drill down into specific data subsets.

Customization

You can customize the dashboard by:

• Adding new charts or pivot tables
• Modifying existing visualizations
• Creating additional calculation fields

Contributing

Contributions to improve the dashboard are welcome. Please fork the repository and submit a pull request with your changes.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Support

For support or questions, please open an issue in this repository.