From the international breweries data recorded for a duration of three years, I am directed to do the following analyses to aid better decision making in order to maximize profit and reduce loss to the lowest minimum.
Session A
PROFIT ANALYSIS
- 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?
Session B
BRAND ANALYSIS
- 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 the most oil reached country in West Africa.
- 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
- Bear 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)
Session C COUNTRIES ANALYSIS
- 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
DATASET https://drive.google.com/file/d/11riatqD-uRa98TsCk2xqOBnlr3rzxsS_/view?usp=sharing