Categories: Uncategorized
Tags:

๐Ÿ“Š 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