Sales Dashboard for Comprehensive Business Insights
Introduction:
This Excel project aims to provide a comprehensive and visually appealing overview of sales data for better business insights. The dataset consists of key information such as order date, customer details, product categories, sales, and profit. The dashboard is designed to facilitate data analysis and decision-making through various charts and slicers.
Data Cleaning:
The initial step involved thorough data cleaning, which included the removal of duplicates to ensure data accuracy. Additionally, a new column was created to extract the month and year from the order date, allowing for more granular analysis.
Dashboard Components:
- Funnel Chart - Sub-category vs. Sales: Visualizes the sales performance across different sub-categories in a funnel chart, providing a clear representation of sales progression.
- Pie Chart - Top 5 Profitable Customers: Highlights the top 5 customers contributing the highest profits, offering insights into key accounts for focused business strategies.
- Area Chart - Monthly Sales Trends: Presents monthly sales trends over time through an area chart, allowing users to identify patterns and seasonality in the data.
- Bar Chart - Yearly Customer Count: Displays the count of customers on a yearly basis, providing a high-level view of customer acquisition and retention over the years.
- Map - Sales by State: Utilizes a map chart to showcase sales distribution across different states, helping identify regions of high and low sales.
- Line Chart - Profit Over Years by Category: Illustrates the profit gained over the years for each product category, aiding in the assessment of long-term profitability trends.
Slicers for Interactivity:
- Year Slicer: Allows users to focus on data for a specific year, facilitating year-wise analysis.
- Category Slicer: Enables users to filter data based on product categories, aiding in targeted analysis for specific product lines.
Conclusion:
This Excel sales dashboard provides a holistic view of the sales data, empowering stakeholders to make informed decisions based on key insights. The combination of charts, slicers, and data cleaning ensures a user-friendly and effective tool for exploring and understanding sales performance.