nehemiah304/FMCG-Brewery-Sales-Analytics-SQL-

This analysis was conducted on an international FMCG brewery sales dataset (1,047 transaction records) covering Anglophone (Ghana, Nigeria) and Francophone (Benin, Senegal, Togo) West African markets across 2017–2019, spanning brands, regions, sales reps, and profitability. # FMCG Brewery Sales Analysis (SQL) This analysis was conducted on an international FMCG brewery sales dataset (1,047 transaction records) covering Anglophone (Ghana, Nigeria) and Francophone (Benin, Senegal, Togo) West African markets across 2017–2019, spanning brands, regions, sales reps, and profitability. ## 🔍 Overview This project performs exploratory and business-driven analysis on FMCG brewery sales data using SQL. 21 SQL queries were developed to answer key business questions related to overall profitability, territory and country performance, seasonal trends, brand consumption, regional preferences, and sales rep performance. The goal is to uncover actionable insights that support market strategy, promotional planning, and resource allocation decisions across the brewery's West African operations — prepared for the Territory Manager as evidence for 2020 strategic decisions. ## 📌 Objectives - Explore and understand the structure of the FMCG sales dataset using SQL - Analyse profitability trends across years, months, and territories - Identify top-performing and underperforming brands by country and region - Evaluate regional consumption patterns to support promo and distribution decisions - Assess sales rep performance for high-value brands - Generate data-driven insights to support strategic decision-making across Anglophone and Francophone markets ## ❓ Business Questions - Total profit worth of the breweries (Anglophone + Francophone), 2017–2019 - Total profit: Anglophone vs Francophone territory - Country with the highest profit in 2019 - Year with the highest profit - Month with the least profit generated (2017–2019 combined) - Minimum profit recorded in December 2018 - Monthly profit share (%) for 2019 - Brand generating the highest profit in Senegal - Profit trend over the months (chronological, all years) - Top 3 brands consumed in Francophone countries (2018–2019) - Top 2 consumer brands in Ghana - Beers consumed in the past 3 years in Nigeria …