This project utilizes Power BI to integrate and analyze multi-source datasets for Just Drink Ltd, a wine and spirits retailer with $452.06M in total sales. The analysis highlights a strong 31.49% profit margin, driven largely by the Spirits category (64% of revenue) and the 750mL bottle size. By identifying seasonal peaks in Q2 and Q4 and pinpointing slow-moving inventory like Grand Marnier, the project provides actionable insights for inventory streamlining and vendor management. The resulting dashboard serves as a strategic tool to optimize store-level pricing and procurement cycles, ultimately aiming to maximize profitability through data-driven stock efficiency.

Skills & Tools Used:

Share this Project: