wine analytics case

This was a group project where I collaborated with a team to analyze brand profitability and performance of wine and spirits brands for Bibitor, LLC. The task was to create a user-friendly dashboard and perform data-driven analysis to optimize decision-making for inventory management and brand promotion. I was responsible for providing key insights for the most profitable brands by gross margin percentage and dollars, sales quantity, stock-out patterns and seasonality trends. I created multiple visualizations in Tableau displaying monthly sales quantities, gross margin percentages, and stock-out trends for the top six most profitable brands. Furthermore, I evaluated which brands should be promoted based on their margins, and I provided recommendations for minimizing stock-outs. This project enhanced my skills in data analysis, creating visualizations, problem-solving and providing key business insights.