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
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
No records match these filters.
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 studyDashboards
More live dashboards
Finance projects rebuilt for the web from the same data. Switch years, filter and click through them like the originals.
