The Superstore Analysis
Jayapura 14
Business Overview
| Year | Percentage |
|---|---|
| 2014 - 2015 | 24,37% |
| 2015 - 2016 | 32,74% |
| 2016 - 2017 | 14,24% |
Based on our analysis, we have identified a substantial decrease in profit percentage from 2016 to 2017, amounting to only 14.24%. This decline is below the average percentage increase from 2014 to 2017 and can be attributed to the imbalance between discount applications and total sales. As a result, we have presented the analysis results on this website to provide comprehensive information about Giant Superstore.
Problem Statement
Why did the profit increase only 14.24% from 2016 to 2017? → Identifying the variables with a strong influence on the 14.24% profit increase.
Dashboard Superstore 2017
$0
Sales
$0
Profit
0
Ordered
0
Customer
0
State
Total Sales By Category and Segment
×
Insight
Insight
Total Sales by Category and Segment
The category with the largest sales based on the three segments is Furniture Category, specifically in the Consumer Segment with a total of 27.3M. And the category with the lowest sales is Category Office Supplies, precisely in the Home Office Segment amounting to 5.5M. Consumer Segment is the largest market among the three categories because its total sales are in the first place which is the highest sales
Sales & Profit by sub-category
×
Insight
Insight
Sales & Profit by Sub-Category
Based on the chart, it can be seen that several sub-categories show varying performance, including the 'Paper' and 'Accessories' sub-categories showing very high profits, 70.5M and 47.8M respectively, indicating that this product is selling and profitable. Meanwhile, the 'Tables' sub-category had negative profits despite sales, indicating high operational costs or a less effective sales strategy. While the sub-categories 'Chairs' and 'Phones' showed significant sales with good profits, indicating the potential to focus on increasing sales.
Our recommendation is to focus sales strategies on sub-categories with high profits such as 'Paper' and 'Accessories', and evaluate sub-categories with negative profits to increase profitability.
Category by Profit
×
Insight
Insight
Category by profit
The chart shows the total percentage of 100% Profit divided by each category. The superstore has only three categories: office supplies, furniture and technology. The data shows that the furniture category has the lowest total profit, namely 14.15%, and office supplies have the highest total profit, 56.64%.
Our recommendation is to maximize discount strategies to encourage an increase in furniture income and also implement cross-selling on favorite products outside of furniture.
Discount and Quantity
×
Insight
Insight
Discount and Quantity
The highest quantity was in November and December 2017, amounting 1460 to 1479. The lowest quantity, on the other hand, was found in February 2017 with a total of 317. The highest discount occurred in December 2017, totaling 667, while the lowest discounts were in February 2017, with a total of 175.
Both discount and quantity fluctuation throughout the year. The discount ranged from 175 to 667, while the quantity ranged from 317 to 1479. There were instances where the discount value and quantity were not aligned. For example, in July, the quantity was relatively high at 739, but the discount was low at 278.
ABS and AOV In Segment
×
Insight
Insight
ABS & AOV in Segment
This data clearly indicates that the Home Office segment outperforms the Consumer and Corporate segments. With an ABS of 6.87 and the highest AOV of 87.2K, the Home Office segment demonstrates that each transaction in this segment tends to have a high value, despite the relatively low number of items purchased.
On the other hand, the Consumer Segment and the Corporate segment exhibit ABS values of 6.4 and 6.89 respectively, with AOV values of 66.9K and 64.5K. This shows a more balanced approach in the Consumer Segment and a higher number of items purchased in the Corporate segment, but with a lower value per transaction compared to the Home Office segment.
In conclusion, although the Corporate segment has the highest ABS, it is more profitable to focus on increasing the transaction value in the Corporate and Consumer segments to approach the Home Office AOV value.
Heat Map Sales By City
×
Insight
Insight
Heatmap Sales by City
According to the "Sales by City" heatmap, the highest concentration of sales is in key regions such as California, Texas, and the East. This indicates a very strong market in these areas, with significant sales activity in cities such as Los Angeles, Houston, New York, and Philadelphia.
Our recommendations include maximizing potential in high-sales cities while developing city-specific strategies for areas with low sales to increase overall profits.
State by Lowest sales
| State | Total Sales |
|---|
City by Lowest Profit
| City | State | Total Sales | Total Profit |
|---|