Mobile Phone Sales Analysis -FP20 Analytics Challenge 5

Project Goal:

This role is for a Sales analyst to develop our client's Mobile phone sales analysis report. The client has provided us with relevant mobile phone sales data stored in an Excel file. This is an Exploratory Data Analysis (EDA), so your goal is to explore the business patterns in the data and summarize your discoveries into meaningful sales insights.

Project Questions:

1. From 2018-2021, which country and distributor had the best sales performance?
2. What was the seasonal sales trend in each country and distributor?
3. What was the seasonal inventory cost trend in each country and distributor?
4. What was the seasonal net profit trend in each country and distributor?
5. Each year, which brand is the best seller in each country and distributor?
6. Who is each country's most successful sales rep and distributor?
7. Which country had the lowest/highest inventory cost from 2018-2021?
8. Which country had the lowest/highest net profit from 2018-2021?
9. Can we predict the 2023 sales trend based on historical data?
10. Can we make any recommendations to optimize net sales based on some best sales performance countries?

Project Insights:

1. Mobile phone sales grew in 2021, after a hard hit by covid pandemic. The market is expected to grow slowly; however, it will come to pre pandemic level after 2025.
2. South America region country Colombia is the leading country in sales in 2021.
3. Apple is the leading brands between 2018-2021, but LG had covered most the share in 2021, leaving behind Apple in the second position.
4. There are total six distributors in the four region (South America, North America, Europe and Africa). Tottus is the leading distributor through out the year.
5. Tuenti is the best sales representative from 2018-2021.
6. The last thing about this data about the sales trend. The sales started increasing from Q1 2022 and it is expected to grow in the same phase till 2023.