Global Superstore

Global Superstores is a global online retailer with a broad range of products and aiming to be a one-stop-shop for its customers. With clientele hailing from 147 different countries and over 10,000 products. This largely comprises three main categories: Office supplies, Furniture and Technology.

1. What are the three countries that generated the highest total profit for Global superstore in 2014? For each of the three countries, find the three products with the highest total profit. What are the product names and total profit for each product?

2. Identify the three sub-categories with the highest average shipping cost in the United States.

3. Assess Nigeria’s profitability for 2014. How does it compare to other African countries? What factors might be responsible for Nigeria’s poor performance?