Case Study: Inventory Analysis in Power BI

that was a demanding but very informative course i learned a lot!

In this case study, I conducted an in-depth ABC analysis of inventory data for WarmeHands, focusing on 2021 sales performance. The objective was to identify product categories that contribute the most to revenue and make data-driven recommendations for inventory optimization.🔍 Key Insights: Class A items accounted for the majority of revenue (~$0.32M), with a strong average inventory turnover of 1.59, indicating high demand and efficient stock movement.Class B items, though moderate in revenue, showed a competitive turnover rate of 1.38, suggesting untapped potential if stocked strategically.Class C items had lower turnover and contributed the least to revenue, making them less favorable for continued stocking.📈 Data Visualizations & Techniques Used: Created dynamic Power BI dashboards with KPI cards, bar charts, and Pareto distribution curves.Used filters and tooltips to isolate insights by ABC class.Performed calculations for revenue contribution, cumulative percentages, and inventory turnover differentials.💡 Recommendations: Maintain or increase stock levels for A-class items due to their consistent high turnover and revenue.Consider increasing stock for B-class items, which are slightly behind in performance but offer good turnover with less inventory.Reassess or phase out underperforming C-class items to optimize warehouse space and cash flow.