๐ 1. Executive Summary Dashboard
- Total Sales
- Average Weekly Sales
- Number of Stores
- Holiday vs Non-Holiday Sales (comparison)
- Sales Trend (line chart with slicer for date)
Dataset Link : https://www.kaggle.com/datasets/yasserh/walmart-dataset
๐บ๏ธ 2. Store Performance Dashboard
- Store-wise Sales (bar chart or map if store locations are available)
- Top 5 / Bottom 5 Performing Stores
- Store filter to drill down into weekly trends
๐ 3. Time-Series Analysis Dashboard
- Weekly Sales Trends
- Month-over-Month / Year-over-Year Growth
- Sales vs Holiday Weeks (with color-coded line)
๐ฏ 4. Holiday Impact Dashboard
- Sales on Holiday Weeks vs Non-Holiday Weeks
- Sales Trend Around Key Holidays (Super Bowl, Thanksgiving, etc.)
- Slicer for selecting a holiday to analyze
๐ก๏ธ 5. External Factors Impact Dashboard
- Sales vs Temperature (scatter plot or trend line)
- Sales vs Fuel Price, CPI, and Unemployment
- Correlation Indicators
๐งฉ 6. Store Segment Analysis
- Cluster stores based on performance and factors (e.g., High Sales + High CPI = Resilient Stores)
- Use filters to segment by sales volume, CPI level, or unemployment rate
๐ 7. Forecasting Dashboard
- Use Power BIโs forecasting tools to project future sales
- Allow users to choose store and time range for predictions