Coca-Cola USA Retailer Dashboard

📍 I'm thrilled to present my recently completed Excel project for data analysis, an interactive Coca-Cola USA Retailer Dashboard.

Project Objective:

The objective of this data analysis project is to analyse sales data for beverage brands within Coca-Cola USA and provide insights into sales performance by retailer.

The project aims to examine sales trends by beverage brand and retailer, as well as to assess sales and operating profit margin by quarter across all regions for the years 2022 and 2023.

Implementation Highlights:

🔺 Data Integration and Cleaning

🔺 Dashboard Design and Visualization by using excel

🔺 Key insights extraction and recommendations generation

🗂️ Dashboard Highlights:

Sales by Beverage Brands (2022 vs 2023):

• Detailed comparison of sales across different Coca Cola beverage brands.

• Insightful variance analysis to identify growth trends and performance shifts.

2. Sales by Retailers:

• Breakdown of sales performance across various retail partners.

• Highlighting top-performing retailers and potential areas for improvement.

3. Quarterly Sales and Operating Profit Margin:

• Interactive chart showcasing quarterly sales figures.

• Visualization of operating profit margins to understand profitability trends.

📊 KPIs Analysed:

• Total Sales

• Units Sold

• Average Price

• Total Operating Profit