What Retail Sales Reveal About Profitability

Looking beyond sales

I used the Sample Superstore dataset to explore how sales, discounts and profitability relate to one another. It is a portfolio analysis of sample data, not a report commissioned by a retail client.

The question I wanted to investigate was simple: which parts of the business look strong on revenue but less attractive when profit is included?

The unit of analysis matters

The dashboard labels its loss measure as order lines and displays an 18.65% loss rate in the captured view. To interpret that number, I need to keep the reporting level and filters explicit.

A count of lines with negative profit is not the same as a count of distinct orders whose total profit is negative. An order can contain both profitable and unprofitable lines. I would aggregate profit by order before calculating an order level loss rate.

Reading the discount chart carefully

The screenshot shows a substantially lower average margin for the highest discount band. That makes discounting a useful area to investigate. It does not establish how customer demand would change if the discount were reduced.

I would also distinguish the average of individual line margins from total profit divided by total sales. These calculations answer different questions, and a report should name the one it uses.

What I take from the project

The useful lesson is to keep revenue and profit in the same conversation while being precise about how each measure is built. Before recommending a change to a product range or pricing policy, I would check the period, product mix, costs and potential effect on demand.

View the retail case study to see the existing dashboard and how I frame the findings.