This project involves the creation of two interactive dashboards: Sales Dashboard and Customers Dashboard, which provide insightful visualizations for sales and customer-related data. The dashboards are designed with interactive features to enhance user engagement and navigation.
- Interactive Navigation: Easily switch between the Sales and Customers dashboards using navigation buttons.
- Clickable Visuals: Bar charts and other elements are interactive, allowing for deeper exploration of the data.
- Filters by Year, State, Region, etc.: Drill down to specific dimensions for more targeted insights.
This dashboard provides insights into sales performance, profitability, and trends. It includes the following:
-
Key Performance Indicators (KPIs):
- Total Sales: Monthly trend line visualizing sales performance in comparisson with previous year.
- Total Profit: Monthly trend line tracking profit performance in comparisson with previous year.
- Quantity Sold: Monthly trend line showing total units sold in comparisson with previous year.
-
Sales by Category and Sub-Category:
- Bar-in-Bar Chart: Visualizes sales comparison for the current year versus the previous year across categories and sub-categories.
-
Profit and Sales Trend Over Time:
- Line Chart: Tracks profit and sales performance on a monthly basis.
- Highlights average profit and sales for quick benchmarking.
This dashboard offers insights into customer behavior, distribution, and profitability. It includes the following:
-
Key Performance Indicators (KPIs):
- Number of Customers: Monthly trend line showcasing customer growth in comparisson with previous year.
- Total Sales Per Customer: Monthly trend line tracking customer spending trends in comparisson with previous year.
- Total Orders: Monthly trend line showing the number of orders placed in comparisson with previous year.
-
Customer Distribution by Orders:
- Bar Chart: Visualizing the distribution of customers by the number of orders placed.
-
Top 10 Customers by Profit:
- Table: Lists the top 10 customers based on profitability. Includes details such as:
- Customer Name
- Last Order Date
- Profit
- Sales
- Number of Orders
- Table: Lists the top 10 customers based on profitability. Includes details such as:
- Open the dashboard file using the provided tool or application.
- Use the navigation buttons to switch between the dashboards.
- Click on bar charts or other interactive elements to filter and explore the data.
- Use filters for year, state, or region to focus on specific data subsets.
The dashboards were designed to:
- Provide actionable insights for business decision-making.
- Analyze customer behavior and sales performance trends.
- Assist in identifying growth opportunities and areas for improvement.
This project was created for educational and portfolio purposes. If you wish to utilize any part of this repository, please provide appropriate credit.
This project is licensed for educational and non-commercial use only.