Categories: Uncategorized
Tags:

Dataset : https://github.com/slidescope/data/blob/master/Sample%20-%20Superstore.xls

  1. Which category has the highest total sales?
    • 📊 Use a bar chart to show Sales by Category.
  2. How have sales changed over time (monthly or yearly)?
    • 📈 Use a line chart with Order Date on the axis and Sales as values.
  3. Which sub-category generated the most profit?
    • 📊 Use a bar chart with Profit by Sub-Category.
  4. What is the total profit of the store?
    • 🧾 Use a card visual showing the total Profit.
  5. Which state has the highest number of orders?
    • 🗺️ Use a map chart with State and Order ID (count) as size or color.
  6. Which customer segment generates the most revenue?
    • 📊 Use a bar chart with Sales by Segment.
  7. How does profit vary across different regions?
    • 📊 Use a bar chart with Region on axis and Profit as values.
  8. Which sub-category had fluctuating sales over the year?
    • 📈 Use a line chart with Order Date and Sales, filtered to a few Sub-Categories.
  9. Which shipping mode is used the most?
    • 📊 Use a bar chart with count of Order ID by Ship Mode.
  10. How does sales performance compare by category over time?
    • 🎗️ Use a ribbon chart with Order Date and Sales, and Category as legend.