Mobile Phone Sales in Ukraine (2016-2021)
Completion Date:
Project Overview
The ongoing geopolitical tensions in Ukraine since 2014, along with the war between eastern Ukraine and Russia, have had significant impacts on several industries. Among them, the mobile telephony industry has also been affected due to a shortage of chips and potential price increases for phones. Nowadays, mobile phones are the primary tools for social communication and play a crucial role in strengthening human relationships. They are used to make contacts, create bonds, and maintain social relations.
Therefore, we have decided to evaluate the sales growth of mobile phones in Ukraine. The project dashboard will focus on mobile phone sales from 2016 to 2021, analyzing the sales and popularity of phones over the years (sales YoY%, popularity YoY%). This project aims to provide valuable insights into sales by city, product, and operating system, helping decision-makers make informed decisions for their industry.
Role:
Problem Statement
In 2016, smartphone sales growth slowed down, with 1.46 billion phones sold, including 1.24 billion under Android, representing a growth of 1.6% compared to 10% in 2015 (Source ZDNet). However, in 2019, smartphone manufacturers were able to sell a total of 1.37 billion devices worldwide, marking the first annual growth in the smartphone market since 2017, according to data collected by Counterpoint. The market saw good sales in Asia-Pacific, the Middle East, Africa, and Latin America. Nevertheless, sales are still far from the record of 1.55 billion devices in 2017.
In 2020, smartphone production declined by 11% due to the COVID-19 pandemic. In 2021, the market grew by 7%, with 1.35 billion smartphones shipped compared to 1.26 billion in 2020. However, annual sales are still below pre-pandemic levels due to a global shortage of components.
Samsung remains the top smartphone shipper in 2021, with a 20% market share globally and 274.5 million phones sold. Apple comes in second, with 230.1 million
phones, and Xiaomi comes third with 191.2 million units shipped. Oppo and Vivo
follow in fourth and fifth places, with 145.1 million and 129.9 million smartphones sold, respectively.
In Ukraine, many mobile phone companies are facing significant problems due to the geopolitical tension and war. Sales for one company have decreased by 21% year-over-year, and popularity was down 18% year-over-year for the same period. However, last year\\\\\\\'s sales increased by 263%, and popularity increased by 56% year-over-year. To help companies make informed decisions, a Sales Dashboard has been developed, focusing on measuring sales and % popularity broken down by business unit.
Executive Summary
The ongoing geopolitical tensions in Ukraine since 2014, along with the war between eastern Ukraine and Russia, have had significant impacts on several industries. Among them, the mobile telephony industry has also been affected due to a shortage of chips and potential price increases for phones. Nowadays, mobile phones are the primary tools for social communication and play a crucial role in strengthening human relationships. They are used to make contacts, create bonds, and maintain social relations.
Therefore, we have decided to evaluate the sales growth of mobile phones in Ukraine. The project dashboard will focus on mobile phone sales from 2016 to 2021, analyzing the sales and popularity of phones over the years (sales YoY%, popularity YoY%). This project aims to provide valuable insights into sales by city, product, and operating system, helping decision-makers make informed decisions for their industry.
Data Dictionary
Key Takeaways
Next Steps
NEGATIVE INSIGHT
Huge drop of sales YOY% from 362% in 2016 to -21% in 2017.
Deployment
https://app.powerbi.com/view?r=eyJrIjoiN2RhMzg1NDQtYTRiMi00Y2FlLTgxNjEtNTQ3NzI4NzE4OTNhIiwidCI6ImYxYWQ2ODFmLTZmNjItNDNhOS04MjQxLTA3MDMxNjBlMTM0OCIsImMiOjN9
