Dataset : https://github.com/slidescope/data/blob/master/Sample%20-%20Superstore.xls
- Which category has the highest total sales?
- π Use a bar chart to show
SalesbyCategory.
- π Use a bar chart to show
- How have sales changed over time (monthly or yearly)?
- π Use a line chart with
Order Dateon the axis andSalesas values.
- π Use a line chart with
- Which sub-category generated the most profit?
- π Use a bar chart with
ProfitbySub-Category.
- π Use a bar chart with
- What is the total profit of the store?
- π§Ύ Use a card visual showing the total
Profit.
- π§Ύ Use a card visual showing the total
- Which state has the highest number of orders?
- πΊοΈ Use a map chart with
StateandOrder ID(count) as size or color.
- πΊοΈ Use a map chart with
- Which customer segment generates the most revenue?
- π Use a bar chart with
SalesbySegment.
- π Use a bar chart with
- How does profit vary across different regions?
- π Use a bar chart with
Regionon axis andProfitas values.
- π Use a bar chart with
- Which sub-category had fluctuating sales over the year?
- π Use a line chart with
Order DateandSales, filtered to a fewSub-Categories.
- π Use a line chart with
- Which shipping mode is used the most?
- π Use a bar chart with count of
Order IDbyShip Mode.
- π Use a bar chart with count of
- How does sales performance compare by category over time?
- ποΈ Use a ribbon chart with
Order DateandSales, andCategoryas legend.
- ποΈ Use a ribbon chart with
