This project analyzes sales, product performance, profitability and supply chain performance of Coca-Cola Enterprise Ltd using historical data from 2018–2025. The objective is to evaluate business performance, identify key drivers of revenue and profit, detect operational risks and generate data-driven insights to support strategic decision-making.
The analysis covers sales trends, product and regional performance, pricing, discount impact, marketing effectiveness and supply chain efficiency using SQL for data cleaning, exploration, and business analysis. The outcome provides actionable recommendations to improve revenue growth, profitability, and operational performance.
Tool Used: SQL for Queries and Excel for Visualization
Brand
Category
Packaging
Pack Size
Unit sold
Gross Revenue
Discount
Net Revenue
COGS
Profit Margin Percentage
Channel
Region