ANALYSING SALES IN SUPERSTORE

Context

With growing demands and cut-throat competition in the market, Superstore Giant is seeking your knowledge in understanding what works best for them. They would like to understand which products, regions, categories, and customer segments they should target or avoid. You can even take this a step further and try and build a Regression model to predict Sales or Profit. Go crazy with the dataset, but also make sure to provide some business insights to improve.

Acknowledgements

I do not own this data. I merely found it from the Tableau website. All credits to the original authors/creators. For educational purposes only.

Questions

1 • What are the top selling products in the superstore?

2 • What is the sales trend over time (monthly, yearly)?

3 • Which category of products generates the highest revenue and profit?

4 • Which region generates the most sales?

5 • What is the impact of discounts and promotions on sales?

6 • What is the average profit margin for each product category?

7 • Which sub-category of products has the highest demand?

Insights

The best sales are when the discount is 50% but this is non-profitability.

But a discount of 10% to 20% is the best solution.