PowerBI-projects

FP20dataanalyticschallenge

Fp20dataanalyticschallenge

Overview: The challenge is to create a report that provides a sales analysis of the six leading mobile brands in the world across different levels: country, brand, distributor, and operator. Analysis:

1. Columbia amassed the country with the highest sales, followed by Ireland and Salvatore
2. About 70% of the revenue came from three brands which are Apple, Samsung and LG which suggests popularity with customers
3. Tottus and Oeschie seem to be the best distributors. This suggests that they have a strong relationship with customers as they have performed very well in every country and are very effective in selling the company's products
4. Tuentin is the top selling operator

Recommendations

1. It is important to keep an eye on the sales performance of the other three less solid brands. Are they performing poorly due to lack of customer interest or is there potential to increase sales with better marketing or product development. This will help diversify the revenue stream and reduce reliance on the top three brands
2. It is crucial to evaluate the performance of the other distributors to find out why they are not selling as compared to Tottus and Oeschie. it will be beneficial to provide support or training to improve their sales if it deems necessary.
3. It is important to understand what Tuenti is doing differently that is contributing to his or her success. It is also crucial to evaluate what others are doing to find out what they are struggling with and provide the necessary training or resources to help them improve. It will be extremely important to reduce reliance on just one sales rep incase he wants to leave

Clife Mart Supply Chain Analysis

Overview: Clife Mart is a rapidly expanding FMCG manufacturer based in Ogun, Nigeria. It is currently available in three Nigerian Cities: Lagos, Port Harcourt, and Ibadan. In the next two years, they hope to expand to other metros/Tier 1 cities. I was tasked as a data analyst to build a dashboard with some specified metrics after being briefed about the task during the stakeholders business review meeting.

Analysis:

1. Clife Mart failed to meet their target foreach of their customers

Recommendation:

Before implementing the plan to expand to other metros, the following steps can be taken: a) Improve inventory management b)Boost production efficiency c) Simplify order processing

Telecommunication Analysis

overview: I was tasked as a data analyst to create insight about a telecommunication company data before 5G and after 5G network

Analysis:

1. Active users declined after the launch of 5G network while the time periods after 5G also declined.
2. Abuja had the highest revenue before 5G and after 5G while Minna had the lowest revenue before 5G and after 5G
3. FEC had the highest market shares

Recommendations

1. Appropriate strategies should be put in place to tackle cities with low revenue
3. there should be finding as to why active users reduced when 5G was introduced, could be the users phone dont support 5G or 5G is not as good as 4G