The data set is in a csv formate I first created a table using the query belowe before loading the data set.
The manager of an international breweries need to make better decision making in order to maximize profit and reduce loss to the lowest minimum. He has asked me to perform various analysis to aid him in his decision making using data from the past three years.
- Within the space of the last three years, what was the profit worth of the breweries, inclusive of the anglophone and the francophone territories?
- Result
The breweries made a total of 105587420 profit with in 3 years
- Compare the total profit between these two territories in order for the territory manager, Mr. Stone to make a strategic decision that will aid profit maximization in 2020.
To group the data into Anglophone and Francophone I wrote a CTE.
- Result
Within three years Anglophone made a total of 42389260 profit and Francophone made a profit of 63198160
- What country generated the highest profit in 2019
- Result
Ghana made a total of 7144070 profit in 2019 making them the highest profit generating country
- Help him find the year with the highest profit.
- Result
The highest profit was made in 2017 with a profit of 38503320
- Which month in the three years was the least profit generated?
- Result
- April made the least profit
- What was the minimum profit in the month of December 2018?
- Result
The mininum profit in the month of December was 3902160
- Compare the profit for each of the months in 2019
- Result
August made a total of 2982800 followed by July which made 2945340 profit.
- Which particular brand generated the highest profit in Senegal?
- Result
Castle lite generated the highest profit in Senegal.
- Within the last two years, the brand manager wants to know the top three brands consumed in the francophone countries
- Result
- Budweiser, grand malt and trophy were the top 3 brand
- Find out the top two choice of consumer brands in Ghana
- Result
- hero and beta malt were the top choices made in Ghana.
- Find out the details of beers consumed in the past three years in the most oil reached country in West Africa.
- Nigeria the the most oil producting country in west Africa
- Result
- Budweiser is the most consumed beer in Nigeria followed by eagle lager and hero
- Favorites malt brand in Anglophone region between 2018 and 2019
- Result
- grand malt is the most consumed malt in Anglophone between 2018 and 2019.
- Which brands sold the highest in 2019 in Nigeria?
- Result
- Hero sold a total of 9622 in Nigeria in the year 2019 making the the most consumeed brand.
- Favorites brand in South_South region in Nigeria
- Result
- eagle lager is the most consumed brand in south south region in Nigeria.
- Bear consumption in Nigeria
- Result
- Level of consumption of Budweiser in the regions in Nigeria
- Result
- 129260 quantity of beer was consumed in Nigerai
- Level of consumption of Budweiser in the regions in Nigeria in 2019 (Decision on Promo)
- Result
- West 4620 followed by north central 4498
- Country with the highest consumption of beer.
- Result
- Senegal consumed a total of 103901 beer followed by Nigeria 103578.
- Highest sales personnel of Budweiser in Senegal
- Result
- Country with the highest profit of the fourth quarter in 2019
- Result
