Project Description:

Objective:

The Sales Dashboard in Tableau aims to provide a comprehensive overview of sales performance, order metrics, and key performance indicators (KPIs) for a company. This interactive dashboard will enable stakeholders to make data-driven decisions and gain insights into their sales operations.

Features and Components:

Number of Orders: This section of the dashboard will display the total number of orders made within a selected time frame, allowing users to track order trends.

Profit Distribution in 1k Bins: The profit distribution will be divided into 1k bins, providing a visual representation of profit ranges. This helps in understanding the distribution of profits across different orders.

Sales by Segment and Category: Users can explore sales data based on different segments and product categories. This section will include interactive filters to drill down into specific segments or categories.

Key Performance Indicators (KPIs):

Average Order Quantity: Display the average quantity of products ordered.

Average Time to Deliver: Show the average time it takes to deliver orders.

Average Discount: Present the average discount applied to orders.

Profit by Category: A pie chart will visualize the distribution of profits across different product categories, providing insights into which categories contribute the most to the company's profits.

Number of Orders by Category: A bar graph will display the number of orders for each product category, allowing users to identify the most popular categories.

Scatter Plot: Profit vs. Sales: This scatter plot will illustrate the relationship between profit and sales, helping users identify patterns and outliers in their sales data.

Data Source:

The dashboard will be powered by a data source that includes the following fields: Customer Name, Segment, Order ID, Order Quantity, Ship Mode, Ship Date, Order Priority, Region, Product Name, Subcategory, Profit, Sales, Region, Row ID, Province, Year, Unit Price, Shipping Cost, etc.

Interactivity:

The dashboard will be highly interactive, with the ability to filter data by date range, segment, category, and other relevant dimensions. Users can click on elements to see detailed information and explore data from various angles.

Benefits:

The Sales Dashboard will provide a single point of reference for sales performance analysis.

Stakeholders can quickly identify trends, outliers, and areas for improvement.

Key performance indicators help track the health of sales operations.

Interactive filters and visuals enhance the user's ability to make data-driven decisions.