This repository showcases interactive Excel dashboards analyzing sales, profits, discounts, and product-level performance trends using the fictional Superstore dataset.
- Description: A dashboard providing insights into sales performance by region, manager, and customer segments.
- Key Features:
- Regional and managerial filters using slicers for dynamic analysis.
- Visual breakdown of category performance (e.g., Furniture, Technology, Office Supplies).
- Integrated Charts:
- Category-Wise Pie Charts: Visualize sales distribution among customer segments.
- Customer Segment vs. Category Performance: Compare sales and profits for customer segments by product categories.
- Description: A dashboard analyzing product-level performance across categories and subcategories.
- Key Features:
- Regional slicers for dynamic insights.
- Category and subcategory-level performance summaries.
- Integrated Charts:
- Top 10 Products by Sales, Profit, and Discount: Highlight top-performing products using bar charts.
- Source: Superstore Dataset (fictional retail data).
- File:
SuperStoreUS-2015.xlsx - Details: Contains sales, profit, discount, and order information for a fictional store.
- Open the
SuperStoreUS-2015.xlsxfile in Microsoft Excel. - Navigate through the different dashboard sheets:
- Sales Performance Dashboard
- Product Insights Dashboard
- Use slicers to filter and dynamically analyze the data.
- Modular dashboards with slicers for dynamic interactivity.
- Clear breakdown of sales and profit performance by categories and regions.
- Top 10 product insights for strategic decision-making.