| Excel | Coffee Bean Sales Dashboard |
☕Coffee Bean Sales Analysis using Excel
I was motivated by a desire to explore global coffee sales. This projects ultized Excel for data munging and dynamic data visualization. The aim was to uncover insights into the performance of different coffee types (Arabica, Excelsa, Liverica, Robusta) and identify the top consumer countries.
🛠️Tools
- Excel for data munging & data visualization, ultilizing specific functions such as XLOOPUP, Index Match, Pivot Tables, and Pivot Charts.
💡Key Takeaways
- United States emerged as the largest purchaser of coffee beans globally.
- Consistent sales were observed for the United States and Ireland, while the United Kingdom exhibited lower sales, with some months recording no purchases.
- Noteworthy spikes in sales for Liverica and Arabica occurred in September 2021, August 2022, reaching $841 and 844 respectively.
The dashboard is completely dynamic and adjusts depending on timeline, roast type, package sizes, and loyalty card status via slicers.