COCA-COLA SALES REPORT
Embedded Files
I analysed Coca‑Cola’s sales dataset to understand brand performance, retailer contribution, and quarterly trends across 2022 and 2023. My goal was to transform the raw data into a clear, insight‑driven dashboard that highlights growth patterns, profitability, and key drivers behind sales performance.
I analysed Coca‑Cola’s sales dataset to understand brand performance, retailer contribution, and quarterly trends across 2022 and 2023. My goal was to transform the raw data into a clear, insight‑driven dashboard that highlights growth patterns, profitability, and key drivers behind sales performance.
I prepared and transformed the dataset so it could support accurate analysis and interactive reporting.
I cleaned the data, corrected inconsistencies, and standardised brand and retailer names.
I created calculated measures including total revenue, operating profit, profit margin, year‑on‑year growth, and brand contribution percentages.
I structured the data model to allow filtering by brand, retailer, and time period.
I selected visual formats that best represented comparisons, trends, and performance metrics.
This ensured the dataset was reliable and ready for meaningful analysis.
I designed the dashboard to be intuitive, visually clear, and aligned with professional BI standards.
• I used a clean layout with KPIs at the top showing total sales, units sold, average price, and profit margin.
• I added slicers for brand, retailer, and year to make the dashboard fully interactive.
• I applied consistent colour‑coding for each brand to make comparisons easy.
• I used line charts for quarterly trends, bar charts for brand and retailer performance, and pie charts for contribution analysis.
• I included a dedicated section for Coca‑Cola’s brand‑level performance to highlight its significant growth.
The dashboard provides a complete view of sales performance and allows users to explore insights from multiple angles.
What the Dashboard Shows
What the Dashboard Shows
The dashboard answers key business questions and the insights are:
The dashboard answers key business questions and the insights are:
Which brands generate the highest sales and profit?
Which brands generate the highest sales and profit?
Coca‑Cola is the top performer with $2.77 million in total sales and the strongest profit contribution. Dasani Water and Diet Coke follow as the next highest‑selling brands. Coca‑Cola’s high volume and strong margins make it the most profitable brand overall.
Coca‑Cola is the top performer with $2.77 million in total sales and the strongest profit contribution. Dasani Water and Diet Coke follow as the next highest‑selling brands. Coca‑Cola’s high volume and strong margins make it the most profitable brand overall.
How do sales differ across retailers?
How do sales differ across retailers?
West Soda and BevCo dominate retailer performance, contributing nearly $6 million combined. Amazon shows a major increase in 2023, surpassing $1 million, indicating rising online demand. Target has the lowest overall contribution but still shows great improvement in 2023.
West Soda and BevCo dominate retailer performance, contributing nearly $6 million combined. Amazon shows a major increase in 2023, surpassing $1 million, indicating rising online demand. Target has the lowest overall contribution but still shows great improvement in 2023.
How did performance change from 2022 to 2023?
How did performance change from 2022 to 2023?
Sales increased sharply across all brands and retailers. Coca‑Cola alone grew by 355%, and every major retailer saw higher sales. Total revenue, units sold, and profit margins all improved, suggesting stronger demand, better marketing, or improved distribution.
Sales increased sharply across all brands and retailers. Coca‑Cola alone grew by 355%, and every major retailer saw higher sales. Total revenue, units sold, and profit margins all improved, suggesting stronger demand, better marketing, or improved distribution.
Which quarters show the strongest growth?
Which quarters show the strongest growth?
2023 shows steady quarter‑by‑quarter growth, with Q3 being the peak at around $2.8 million. Q1 shows the biggest jump from the previous year, and Q4 dips slightly, likely due to seasonality or reduced promotional activity.
2023 shows steady quarter‑by‑quarter growth, with Q3 being the peak at around $2.8 million. Q1 shows the biggest jump from the previous year, and Q4 dips slightly, likely due to seasonality or reduced promotional activity.
What is each brand’s contribution to total revenue?
What is each brand’s contribution to total revenue?
Coca‑Cola contributes the largest share of total revenue, followed by Dasani Water and Diet Coke. Other brands contribute smaller but growing portions, especially in 2023. This breakdown highlights which products drive the business and where growth opportunities exist.
Coca‑Cola contributes the largest share of total revenue, followed by Dasani Water and Diet Coke. Other brands contribute smaller but growing portions, especially in 2023. This breakdown highlights which products drive the business and where growth opportunities exist.
These insights make the dashboard a strong decision‑support tool for understanding performance, identifying growth opportunities, and evaluating retailer effectiveness.
These insights make the dashboard a strong decision‑support tool for understanding performance, identifying growth opportunities, and evaluating retailer effectiveness.
My Findings
• 2023 saw a major boost in sales across all brands, suggesting stronger marketing, seasonal demand, or improved distribution.
• West Soda and BevCo dominate retailer performance, indicating strong partnerships or wider market reach.
• Coca‑Cola’s 355% growth highlights it as the standout brand in the portfolio.
• Quarterly trends show consistent growth through Q3, with a slight dip in Q4.
• Amazon and Target show significant improvement, especially in 2023, pointing to growing online and retail demand.
Summary
Summary
This project demonstrates my ability to work end‑to‑end with real sales data: cleaning it, transforming it, analysing it, and presenting insights through a clear, interactive dashboard. By integrating brand, retailer, and quarterly performance, I created a dashboard that highlights key growth drivers and supports data‑driven decision‑making. The findings show strong overall performance, major year‑on‑year growth, and clear opportunities for strategic focus across brands and retailers.
This project demonstrates my ability to work end‑to‑end with real sales data: cleaning it, transforming it, analysing it, and presenting insights through a clear, interactive dashboard. By integrating brand, retailer, and quarterly performance, I created a dashboard that highlights key growth drivers and supports data‑driven decision‑making. The findings show strong overall performance, major year‑on‑year growth, and clear opportunities for strategic focus across brands and retailers.
Page updated
Google Sites
Report abuse