Super Store is a small retail business located in the United States with stores across 49 states. They sell Furniture, Office Supplies and Technology, their customers are the mass Consumer, Corporate, Home Offices and Small Businesses.
This data contains Sales, Profit, Shipping Cost, Quantity ordered, Product, Customer Segment, Region and Cities, these make of properties or a customer order.
The task is to analyse the sales data and identify weak areas and opportunities for Super Store to boost business growth and customers.
- Which Manager is the best selling, and most Profitable?
- Which Category is Best Selling and Most Profitable?
- What are the best selling and most profitable sub-category?
- Which is the top selling Product sub category?
- Which customer segment is most profitable?
- Which is the most preferred ship mode?
- Which city has the highest number of sales and profit?
- Focus on Technology sub-category, Office Machines, and Telephones and Communication they are among the highest selling and most profitable. we can promote it with less profitable product sub-category such as Office Furnishings, Tables, Pens & Art Supplies, Scissors, Rulers and Trimmers Labels Rubber Bands to offset the losses.
- Sales of Scissors, Rulers and Trimmers, Rubber Bands, Bookcases, and Tables results in huge losses, it's important that we bundle them with high selling and profittable product sub-category.
- Not specified order priority should be completely struck off, this will prevent customer's order from getting to them after 90 days.
- For Corporate customers, these people might be busy with work and less likely to spend time selecting individual products, we can create packages that best suits this type of customer.
- We should consider dropping from the catalogue products that incur losses on the company such as Scissors, Rulers and Trimmers, Rubber Bands, Bookcases, Tables. Alternatively, We can consider changing suppliers or bargain for a cheaper production cost.
- Manager Sam Smith recorded the least sales, profit and quantity sold, emphasis on the need to conduct analytical studies to ascertain the challenges experienced by the manager, also we should consider promoting the least profitable products with the most profitable products.
- Home Office and Corporate make up more than 60% of our orders. We should target customers in these categories, especially customers from the central and eastern regions in the top 10 cities.
- We can introduce special promotions and bundles for Home Office and Corporate customer segment. Sending these promotions as email will be effective as these customers are very busy but will have time to check their emails.