Oluwafeyikemi09/GlowMart-Nigeria-Ltd-Sales-vs-Inventory-Analytics-Dashboard-Power-Bi

Power BI dashboard analyzing sales performance, inventory allocation, and customer insights to resolve a real-world business conflict. # 📊 GlowMart Nigeria Ltd: Sales vs Inventory Analytics Dashboard | Power BI A Business Intelligence solution developed using **Power BI**, **DAX**, and **data storytelling** to resolve the Sales vs Inventory allocation conflict at GlowMart Nigeria Ltd. --- # 📊 Dashboard Preview ## Executive Performance Dashboard --- ## Sales vs Inventory Conflict Resolution --- ## Customer & Product Intelligence --- ## Strategic Recommendations & Executive Summary --- # 📄 Dashboard Report Download the complete project report below: **[github.com]** --- # Business Problem GlowMart Nigeria Ltd experienced a conflict between the Sales and Inventory departments. The Sales team argued that high-demand cities were losing sales because inventory was not stocked according to customer demand, while the Inventory team maintained that stock was allocated based on the forecasts provided by Sales. Management requested a Business Intelligence solution capable of identifying the root cause of the conflict and providing data-driven recommendations for future inventory allocation. --- # Project Objectives This project aims to: * Build a Star Schema data model. * Analyze sales performance across cities, brands, products, and customers. * Resolve the Sales vs Inventory conflict using data. * Recommend an improved inventory allocation strategy. * Support better business decision-making through interactive dashboards. --- # Dataset Overview The analysis covers: * **15,000 Sales Transactions** * **500 Customers** * **90 Products** * **4 Brands** * **5 Cities** * **Analysis Period:** 2022–2024 --- # Tools & Technologies * Power BI Desktop * Power Query * DAX * Data Modeling (Star Schema) * Data Visualization * Business Intelligence * Data Storytelling --- # Dashboard Pages ### 1. Executive Performanc …