joshuaochuko4-cyber/fmcg-sql-analysis

SQL analysis of FMCG sales data across West Africa using T-SQL # fmcg-sql-analysis SQL analysis of FMCG sales data across West Africa using T-SQL # FMCG Sales SQL Analysis ## Overview A comprehensive SQL analysis project on Fast-Moving Consumer Goods (FMCG) sales data across West Africa, covering multiple countries, brands, regions, and sales representatives across 2018 and 2019. ## Dataset - **Database:** FMCG_DB - **Table:** FMCG - **Coverage:** West African countries (Anglophone & Francophone) - **Period:** 2018 – 2019 - **Key Columns:** COUNTRIES, YEARS, MONTHS, BRANDS, REGION, QUANTITY, PROFIT, SALES_REP ## Tools Used - Microsoft SQL Server (T-SQL) - CTEs, Window Functions, Aggregate Functions ## Business Questions Answered ### 🌍 Territory & Profit Analysis - Compared total profit between Anglophone and Francophone territories over the last 3 years using CTEs and dynamic year filtering - Calculated each territory's percentage share of total profit using window functions (SUM OVER()) ### 📅 Time-Based Analysis - Identified the highest profit year across all records - Found the lowest performing month by total profit - Calculated minimum profit recorded in December 2018 - Analyzed monthly profit distribution for 2019 with percentage contribution per month ### 🏆 Country & Brand Performance - Identified the highest profit country in 2019 - Found the top performing brand in Senegal by total profit - Ranked brands by quantity sold in Ghana (Top 2) - Analyzed Nigeria brand performance by year — quantity and profit breakdown - Identified top 3 brands by quantity in Francophone countries (2018–2019) ### 🇳🇬 Nigeria Deep Dive - Year-by-year quantity analysis for Nigeria - Total quantity sold in Nigeria across all years - Top brand in Nigeria's South region by quantity - Budweiser regional performance across Nigeria - Budweiser performance by region in Nigeria for 2019 specifically - All brands ranked by quantity in Nigeria for 2019 ### 👤 Sales Rep Analysis - Identified top performing sales rep in Senegal for Budweiser by prof …