Coffee Vending Machine Sales

Click here to view project

In a recent project, I compiled and analyzed five months of sales data using Excel to uncover key insights. I discovered that 90% of sales were made by credit card and proposed cashless sales strategies with incentives, such as discounts and loyalty points, to address the decline in cash transactions. By investigating sales patterns in May and June, I developed targeted marketing strategies for July and August, including replicating successful promotions to maintain customer interest and mitigate seasonal fluctuations. Utilizing Pivot Tables, Column Charts, and Line Charts, I visualized sales distributions by coffee type, transaction type, and monthly sales, creating an informative dashboard.

Coffee Sales.xlsx

Download XLSX • 177KB