From the international breweries data recorded for a duration of three years, you are directed to do the following analyses to aid better decision making in order to maximize profit and reduce loss to the lowest minimum.
- Within the space of the last three years, what was the profit worth of the breweries, inclusive of the anglophone and the francophone territories?
- Compare the total profit between these two territories in order for the territory manager, Mr. Stone made a strategic decision that will aid profit maximization in 2020.
- Country that generated the highest profit in 2019
- Help him find the year with the highest profit.
- Which month in the three years was the least profit generated?
- What was the minimum profit in the month of December 2018?
- Compare the profit in percentage for each of the month in 2019
- Which particular brand generated the highest profit in Senegal at the end of January?
- Within the last two years, the brand manager wants to know the top three brands consumed in the francophone countries
- Find out the top two choice of consumer brands in Ghana
- Find out the details of beers consumed in the past three years in Nigeria.
- Favorites malt brand in Anglophone region between 2018 and 2019
- Which brands sold the highest in 2019 in Nigeria?
- Favorites brand in South_South region in Nigeria
- Beer consumption in Nigeria
- Level of consumption of Budweiser in the regions in Nigeria
- Level of consumption of Budweiser in the regions in Nigeria in 2019 (Decision on Promo)
- Country with the highest consumption of beer.
- Highest sales personnel of Budweiser in Senegal
- Country with the highest profit of the fourth quarter in 2019