Post by Samuel Adanu

HOW I RESOLVED A REAL BOARDROOM CONFLICT IN GLOwMART NIGERIA LIMITED WITH DATA-BACKED EVIDENCE 𝐓𝐡𝐞 𝐒𝐜𝐞𝐧𝐚𝐫𝐢𝐨: GlowMart Nigeria Limited — a beauty & personal care FMCG company with 500 customers, 90 products, 4 brands, and 15,000 transactions across 5 cities between 2022 and 2024. 𝐓𝐡𝐞 𝐂𝐨𝐧𝐟𝐥𝐢𝐜𝐭: The Sales Manager said: "Inventory is not stocking the right products in the right cities." The Inventory Manager said: "I stock based on equal allocation across all cities. Show me the data." The MD commissioned a BI dashboard to settle it. 𝐓𝐡𝐞 𝐃𝐚𝐭𝐚𝐬𝐞𝐭: 4 tables connected in a Star Schema — Sales (fact), Customers, Products, and Date — built in Power BI Desktop with 15 DAX measures. 𝐓𝐡𝐞 𝐓𝐚𝐬𝐤: Build a 2-page executive dashboard resolving the conflict with data-backed evidence and deliver actionable recommendations. 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: 1. Port Harcourt and Abuja exceeded the equal allocation benchmark. Lagos and Ibadan fell short. 2. Brand A led revenue in all 5 cities, contributing 30.69% (₦200.3M) of total revenue. 3. Lagos recorded the steepest 2023 revenue decline despite customers spending at par with other cities. 4. Port Harcourt had the highest discount amount (₦15.7M), raising margin concerns. 5. Revenue declined -1% in 2023 before recovering +2% in 2024 — both below the 5% growth benchmark. 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐚𝐭𝐢𝐨𝐧𝐬 𝐭𝐨 𝐭𝐡𝐞 𝐌𝐃: 1. Replace equal allocation with a demand-weighted stock distribution model. 2. Guarantee Brand A availability everywhere while developing Brand D as a second revenue pillar. 3. Launch an urgent Lagos stock recovery plan targeting Brand A specifically. 4. Cap Port Harcourt discounting to protect the 28% Gross Profit margin. 5. Set a formal 5% YoY revenue growth target for 2025. The data settled the argument. Port Harcourt and Kano are not overstocked — they are high-demand cities being underserved by a flawed equal allocation policy. 𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝: Power BI Desktop | DAX | Star Schema Data Modelling SkillAhead Academy & Etuk Anietie please review and comment. #PowerBI #DataAnalytics #BusinessIntelligence #FMCGAnalytics #NigeriaData #SkillAheadChallenge #JKBChallenge #SamuelAdanu