Dashboard on Superstore data

Our task is to analyze the sales data.

Business Question:

• How many segments are there, and which contributes the most to profit?
• Which subcategory is the most significant driver of profits for each category?
• What percentage of total sales does each contribute?
• Which year had the biggest growth in sales?
• During that year, which category showed the highest growth?
• What total percent of sales did that category make up during the year it had the highest growth?
• Which region had a better average order sale in 2017
• What were the best- and worst-selling quarters?
• The best-performing States in terms of sales and profits

Insights :

This dataset comprises of three segments, with the consumer segment being the biggest driver of profits in 2017, followed closely by the corporate segment which contributed to $26782 of total profits that year.

In the furniture category chairs are the biggest driver of profits with 8,10% of profit margin. In office supplies, there are a number of subcategories that are contributing significantly to profits, with paper being the most profitable with a 43,39% profit margin followed by appliances at 16,87%. In the technology category, copiers with 37,20% of the profit margin, and accessories 25,05% of the profit margin are the most profitable.

2016 saw the biggest growth in sales, with technology having the highest growth in sales. Being down by -7,13% In 2015. Another that had the biggest growth in sales in 2016 was Office Supplies with a growth of 39% and 34% respectively.

Technology contributed to 12,49% of total sales that year (2016) followed by Office Supplies with 10,15% of total sales. There was a huge decrease in 2017 for Technology, going down by 19,02%, with a slight decrease for the Office Supplies category.

Among the four regions, the South had a better Average Order Value (AOV). Followed by the East region. Also compared how they trended mouth-wise. The trend direction is decreasing in the South and increasing in the East Region.

Q3 and Q4 performed relatively better than Q1 and Q2, with Q1, and Q4 being the best-selling quarter and Q1 worst-selling quarter. I also had a look at why Q4 is performing better than other quarters. The month of November and December, had the highest sales as well these are months that generated more profit. And also. Technology contributed significantly to our sales and profits generated.

California and New York are the two major contributors to the sales, followed by Texas, Washington, and Pennsylvania. They also contributed significantly to our profits, followed by Washington, Michigan, and Virginia.

To ensure the store is profitable in the upcoming financial year, we must Lowe our discount rate to something lower than 30%.