• Dataset: Global Superstore Sales

• Dataset stores sales information of some products of a company worldwide
• Consists of 3 data tables:
  • Table 1: Orders: Fact order
  • Table 2: People: Information of Sales person
  • Table 3: Returns: Information of Returned orders

• Presenting business situation in international markets to Senior Manager.
• Highlight important indicators for Senior Manager to decide in which markets to develop and which products are suitable for each international market.

Here are the five steps of design thinking:

1, Our top 5 biggest markets are: APAC, LATAM, EU, US, EMEA.

2, Popular customers are "Consumer" and "Corporate" accounted for a total of : ~ 82%.

3, Standard class is common shipping method.

4, United state is the country with the largest number of orders.

5, Profit and Sales tend to reach Max at the end of the year (Q4) and Min at the beginning of the year (Q1).

6, Our popular customers according to Market are: APAC, LATAM, EU, US, EMEA and AVG, the size of the cart is: APAC > EU > US > LATAM > AFRICA, respectively.

7, Our popular customers by Region are : Central EU, EMEA, Africa, OCEANIA APAC, WEST US.

8, Office Supplies is the category mainly ordered by customers.

9, According to profit,

• Technology is the most profitable category.
• Consumer is the most profitable segment. → APAC is the market where we have the highest profit ~ 0.44M and Central EU is the Market region with the highest profit.

10, According to Return of Sales (ROS)

• Technology and Office supplies bring the highest ROS
• As for Segment, it's the same about ROS
• Canada is the market that brings the highest ROS

Market expansion strategy and key products

1, If we have large capital, we can focus on developing APAC, US, EU, LATAM regions, more specifically Market regions: Central + North EU, APAC, West + East US, North LATAM.

• Note: the APAC market needs the most focus.
• The main category is: Technology + office supplies.
• Main sub-category are: Binders, Storage, Art, Paper, Chairs, Phones and Accessories.
• Segment to be targeted is: Consumer + Corporate.

2, If we have limited capital, we need to pay attention to the ROS index, now there are 2 markets that need to spend a little capital but bring high profits: Canada and Africa.

• Note: the Canadian market needs the most focus.
• Main products are: Technology + office supplies.
• Main sub-category are: Art, Binders, Storge.
• Segment to be targeted is: Consumer + Corporate + Home office.