The Sales Analysis Dashboard provides a detailed overview of sales data across various dimensions such as date, product, region, and salesperson. Here’s a comprehensive description of the dashboard:

Filter Options (Left Panel):

• Slice by Date: A date range filter allows users to select a specific period for analysis.

• Slice by Year: Allows filtering of data by selecting either the year 2020 or 2021.

• Slice by Month: Provides the option to filter data by each month from January to December.

• Slice by Quarter: Allows filtering data by quarters (Qtr 1, Qtr 2, Qtr 3, Qtr 4).

• Slice by Region: Users can filter sales data by region: Central, East, or West.

Summary Metrics (Top Panel):

• Total Quantity: Displays the total quantity of products sold.

• Average Quantity: Shows the average quantity sold.

• Total Sale: The total sales amount.

• Average Sale: Displays the average sales amount per transaction.

• Low Sale: Shows the lowest sales amount recorded.

• High Sale: Indicates the highest sales amount recorded.

Sales Breakdown (Right and Center Panels):

• Slice by Product: Allows filtering by different product categories like Binder, Desk, Pen, Pen Set, and Pencil.

• Sale by Product: A bar chart showing sales by different products, with Desk leading at €14K, followed by Binder at €9K, and Pencil at €5K.

• Sale by Region: A bar chart showing sales distribution by region, with the Central region leading at €25K, followed by the East region at €8K, and the West region at €2K.

• Top 3 Products by Sale: A pie chart showing the top three products by sales amount, with Desk at €14.20K, Binder at €9.38K, and Pencil at €5.03K.

• Top 3 Sales Persons by Sale: A pie chart showing the top three salespersons by sales amount, with Waqar leading at €15.61K, followed by Saud at €3.10K, and Qadeer at €2.81K.

• Sale by Person: A tree map showing sales by different salespersons, with Waqar leading at €15.61K, followed by Saud at €3.10K, and Qadeer at €2.81K. Other salespersons include Mehran, Ali, Nabeel, Usman, Saeed, Imran, Sumair, and Nasir.

Yearly Sales by Product (Bottom Center):

• Yearly Sales by Product: An area chart displaying sales by product over the years 2020 and 2021. The chart shows the distribution of sales among various products across the selected years.

This dashboard provides a comprehensive view of sales performance, allowing users to drill down into specific time periods, regions, products, and salespersons. It is designed to help users analyze sales trends, identify top-performing products and salespersons, and make data-driven decisions.