Skip to content
Dashboards

Profitability by Segment and Category2014 to 2017

Where does the profit really come from? Filter by year, segment and region, then compare sales with profit for every category and sub-category.

LiveOriginally built in Excel

Year

Segment

Region

Category

Key figures

Sales

$2.3M

Profit

$286.4k

Profit margin

12.5%

Order lines

9,994

Tip: click a bar or slice to filter by it

Sales and margin by quarter

Bars: sales in USD. Line: profit margin

Profit by sub-category

Ranked. Loss-making lines are highlighted

Sales vs profit by category

USD

Sales by customer segment

Share of sales

Ship mode: usage and speed

Bars: order lines. Line: average days to ship

Sales and margin by region

Bars: sales. Line: profit margin

Questions this dashboard answers

  • 01Which segment of clients generates the most sales?
  • 02What are the top performing categories in sales and in profit?
  • 03Which products lose money?
  • 04How long do orders take to reach clients for each ship mode?

Data source

Sample Superstore retail data set (public training data), 9,994 order lines.

Read the case study

Dashboards

More live dashboards

Finance projects rebuilt for the web from the same data. Switch years, filter and click through them like the originals.

Explore all dashboards
Chat on WhatsApp