An overview of the Grocery Inventory Insights dashboard displaying key performance metrics and trendsÂ
💡 What I Did Using Power BI and DAX, I cleaned and transformed the data, then built an interactive dashboard that gives a full picture of the store’s sales and inventory performance. 📊 Key Insights & Features Yearly Revenue Breakdown: Used DAX formulas to isolate and compare sales for each year. Loss Identification: Tracked unsold or expired products to reveal revenue losses. Top-Selling Products: Ranked products by total sales amount. Inventory Movement: Visualized product in/out trends and expiration data. Profit Analysis: Helped the owner see where they made or lost money. Dynamic KPIs: Created trend-based KPIs to monitor performance over time. 🛠Tools Used: Power BI (Data Cleaning, Modeling, and Visualization), DAX (Calculated Measures & Logic), Excel (for initial data formatting)Â