al3x-id/Beer_Sales_Analysis

This project analyzes beer sales data across Nigeria using Excel for data cleaning, analysis and visualization # Bewery Retailer Sales Analysis and Visualization - Excel Project ## Project Overview This project analyzes beer sales data across various Nigerian zones, states and cities. it explores the performance of different beer brands, retailers and regions to uncover sales patterns and profitability insights using Excel. ## Objectives - To build a data-driven Excel dashboard that enables stakeholders to: - Monitor sales and profits across different regions and brands - Identify high-performing locations and products - Find the variance in sales across the years - Recommend strategic buisness on decisions bases on sales insights ## Skills Demonstrated - Data Cleaning and Transformation - Pivot Tables & Pivot Charts - Conditonal Formatting - Custom Calculations - Interactive Dashboard Design - KPI Creation - Trend Analysis - Business Insight Communication **Source**: Internal sales records(simulated) **Size**: Covers daily sales across 6 geopolitical zones and multiple retailers **Key Columns**: Retailer, Retailer ID, Invoice Date, Zone, State, City, Beer Brand, Cost Per Unit, Price Per Unit, Units Sold. ## Raw Dataset ### ETL Process (Extract, Transform and Load) This process involved obtaining the data, cleaning the data and transformed it for analysis. The cleaning involves the formatting of key columns such as dates and currency. Calculated metrics such as Sales, Profit and Profit Margin were derived using Excel formulas to drive decision decision-making. ## Modelling, Analysis and Visualization ### KPI - **Total Sales**: ₦3,429,348,650 – This is the total revenue generated across all retailers and beer brands during the selected time range (2022 and 2023). - **Total Unit Sold**: 2,019,201 – The total number of beer units sold over the two years. - **Total Profit**: ₦371,990,050 – Represents the total number of invoices or sales transactions recorded. - **Total Number of Transactions**: 4,824 – Overall profit earned from beer sales across retailers and brands. - …