SALES DATA ANALYSIS (INTERNATIONAL BREWERIES)

SQL

This data set contains 3 years of sales data from 2017-to 2019 from both the francophone and anglophone territories. The first thing I did was to CREATE the database before extraction and analysis. Profit analysis, Brand analysis, and Country Analysis.

In Profit analysis, the total profit in the last 3 years across both territories was 105,587,420 million

The profit generated by the Francophone territory was extracted using the query below

The profit of the Anglophone territory was extracted likewise as

Comparing the profit generated from the 2 territories, it is very evident that the Francophone territory generated the most profit over t6he 3 years.

In carrying out brand analysis, queries were written to extract the data of the brands mostly consumed in the Francophone territory from 2018-to 2019.

Also, the rate of beer consumption in Nigeria was extracted from the database.

The country analysis showed that Senegal was the country that consumed the most beer.

To see all query codes, click here