Coca-Cola Beverages Sales Dashboard

Project objective: The primary objective is to analyze the beverages sales performance of coca cola across different brands, retailers, regions and time periods.

Aim: To provide data driven insights for decisions making in sales strategy, marketing and supply chain management.

Goals:

• Identify top-performing & underperforming products: Evaluate which brands contribute the most to revenue.
• Analyze retailer contribution: Assess which retailers drive the highest sales volume
• Understand sales fluctuations across different months.

Methodology:  To evaluate the beverages sales performance of coca cola, the dataset was downloaded as xlsx file, I utilized power query for data cleaning and DAX formula in Power BI for calculated measures and dashboard report. 

Report: Based on the coca cola sales performance, I was able to evaluate

1. Top selling and low selling brands: Coca cola are the highest selling brand with 2.016M sales, while Fanta has the lowest sales of 1.032M.   Dasani Water and Diet Coke have moderate sales performance.
   
2. Best-Performing & Worst-Performing Retailers: SodaPop is the best retailer with 4.4M in sales, while DreamCo has the lowest sales (0.4M). This suggests some retailers are more effective in selling Coca-Cola products than others.
   
3. Monthly Sales Trends: December has the highest sales (1.045M) followed closely by July (1.041M). June has the lowest sales (903.8K) among the displayed months.  December sales may likely be due to holidays celebration (Christmas and New year) where beverages are in high demand. July also experiences summer peak sales as people buy more cold drinks during hot weather while some region may experience cooler weather in June reducing demand for cold beverages.

Recommendations:

1. They should be campaign or advert in the month of June and August to drive more revenue.
2. Work with DreamCo and underperforming retailers to improve stocking, promotion and distributions.
3. They company should also plan aggressive campaign for December and July to maximize more profits.