This sales analysis done using public Amazon sales dataset and gdp dataset from Kaggle.
Provided are the countries with the highest revenue, number of countries, number of sales, and revenue per customer. Things to note
-
All in western europe
-
United Kingdom dominates: % of overall customers, % of revenue, % of sales.
-
Revenue per customer (how much a customer every year) introduces some outliers.
-
Country-level data (literacy rates, access to electricity, GDP per capita) aggregated to the sales data.
-
Ran a regression tree and revealed that there are three segments of countries
-
High revenue countries had much higher revenue, larger markets, revenue per customer, customers, and sales.
- However, not associated with higher GDP. High revenue market had lower GDP than medium revenue market.
- Low revenue includes some developing countries.
Correlation w/ GDP per Capita
Scatterplot shows no significant correlation w/ GDP per capita. Plays an important role but not the only factor. Need to consider market size and other variables.
- High price goods account for less than 4% of total revenue and if the margins are thin for those, the company should specialize in mid-low priced goods.
- Largest growth in revenue in high revenue countries happen in the first qurter
- Further investigattion required for Sweden & Australia market
- Theses countries have high GDP per capita. People have the money to spend.
- Higher Revenue per Customer than Germany, UK, Ireland combined.
- Massive growth between 2010 and 2011. In Australia, number of ustomers increased 350% and the revenue increase 135 times over.
Credits: This presentation template was created by Slidesgo, and includes icons by Flaticon, and infographics & images by Freepik