-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathGlobalSuperStore
39 lines (31 loc) · 2.77 KB
/
GlobalSuperStore
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
# R_EDA_GlobalSuperStore
EDA is Exploratory and Explanatory Data Analysis. I'm using Global Super Store from Kaggle.com . Superstores industry comprises of companies that operateby having large size spaces which store and supply large amounts of goods.
The superstore industry is comprised of extensive stores that sell a typical product line of grocery items and merchandise products, such as food, games, pharmaceuticals, apparel, toys, furniture, technology, and appliances.
The Analysis of such industry is of great importance as it gives insights for sales and profits of various products. My analysis is based on a superstore dataset in the world that ordered between 2015 and 2018.
**Goals** :
1. Region that accounts for greater number of orders
2. Frequency distribution of quantity ordered
3. Profitable category and sub-category
4. Percentage sales by category
5. Product type that was ordered greater times
6. Category and sub-category that incurred the losses
With this analysis the superstore can identify various aspects of the shopping patterns.
**Insights**:
1. From orders by Region : Center region has maximum order and canada has minimum order.
2. From Sales by Category: Technology has maximum contribution in selling activity
3. Treemap : Phone has highest sales under technology category and the lowest sales is labels under office supplies. from the color gradient, copiers and has highest profit and tables has lowest profit.
4. from pie chart, total sales by market : APAC has the highest sales followed by EU and the lowest is Canada.
5. By Bar chart, sales vs quantity : Standard class has more dominant in shipping mode. and the lowest is same day.
6. From sales vs discount : Discount mostly attract in standard class shipping mode
7. Provit vs sub-category and region : Copiers and phones mainly has heighest profit in central and north asia. Sales haven been made from the central region by category.
9. Shipping cost and profit are related, shipping cost and quantity are related.
**Advices**:
1. Technology, furniture, and office supplies that sell in central and north asia. must give a discount with different ratio followed with price of the goods.
2. Discount can give more attract in standard class shipp. mode, and another class shipp type can give discount with more consideration. Maybe quantity can combine with discount for good attention and evaluation.
3. Maybe in specific quantity can give free shipping cost or discount shipping cost based on quantity
4. For Tables, bookcases, and chairs under the furniture category must have more complex attention
If you have any suggestions or feedback, please don't hesitate to contact to me in direct message on LinkedIn and Email :
kurniaanwarraif@gmail.com and https://www.linkedin.com/in/kurnia-anwar-ra-if/
#R
#EDA
#GlobalSuperStore