Supply Chain & Inventory Analytics
The week's dominant thread was the argument that a dashboard is not a system. @_victorugwu opened it by resurfacing his own Sep-15 essay on how a beautiful dashboard 'can still solve absolutely nothing' — the operations team still spends 3 hours compiling reports — then built on it across four quote-chains, each adding a new operational framework [1]. His reorder-point framework is the clearest example. He walked through the formula — ROP = Average Daily Demand × Lead Time + Safety Stock — with a worked example: 50 units/day, 7-day lead time, 100 units safety stock gives a reorder point of 450. 'When inventory approaches 450 units, the business should already be preparing to reorder. Not when the inventory hits zero.' The goal is to move from 'Inventory Data → Calculation → Alert → Action' instead of 'Stockout → Panic → Emergency Purchase' [1]. He extended the same logic to inventory health. 'Having 10,000 units in stock doesn't mean your inventory is healthy.' A warehouse can look well-stocked while cash is trapped in slow-moving products and fast-moving SKUs are close to stockout. He reframed inventory as a decision system: slow-moving SKUs ask 'what should we stop buying?', stockouts ask 'what should we reorder?', overstock asks 'where is cash trapped?', and aging identifies what needs attention before products become obsolete. The shift he wants: 'Inventory data → Signal → Decision → Action' [2]. Supplier on-time delivery got the deepest treatment. A supplier delivering 95 out of 100 POs on time looks fine on a dashboard — 'Management sees 95% and moves on.' But breaking the 95% down by product, PO, month, and warehouse can reveal that the 5 late POs were all for critical items. He connected delay analysis to inventory risk, flagged late POs with a stock-risk alert, and laid out six procurement decisions that follow: review lead times, increase safety stock, escalate repeated delays, adjust reorder points, negotiate terms, or find an alternative supplier. 'A dashboard shows the number. A system connects the number to what the business should investigate next' [3], [4]. Logistics cost was the final piece. 'A logistics operation can deliver 10,000 orders and still lose money.' He tracks four metrics: cost per shipment, cost per kilometer, cost by customer, and cost by route. The route breakdown is where it becomes operational — Route A at ₦1,800 per shipment versus Route C at ₦4,100 — giving the team something to investigate on vehicle utilization, fuel, delivery density, and driver performance. The question he wants a dashboard to answer: 'Where are we spending too much money, and what should we change?' [3].
Reorder points & inventory health: Resurfaced his Sep-15 and Sep-16 essays arguing dashboards are not systems. Walked through ROP math (50 units/day × 7-day lead time + 100 safety stock = 450 reorder point) and reframed inventory as a decision system where slow-moving SKUs, stockouts, overstock, and aging each trigger a different action [1], [2].
Supplier OTD breakdown: Argued a 95% on-time delivery average hides critical-item delays. Built a six-step workflow from PO data through delay analysis, inventory-impact flagging, and supplier alerts to six concrete procurement decisions. 'A dashboard shows the number. A system connects the number to what the business should investigate next' [3], [4].
Logistics cost metrics: Laid out four cost metrics — cost per shipment, per kilometer, by customer, by route — with route-level cost gaps (₦1,800 vs ₦4,100 per shipment) as the trigger for operational investigation. The goal: answer 'where are we spending too much money, and what should we change?' [3].
Analytics Academy & Bootcamp
Cohort 3 of the Excel & AI for Supply Chain Analytics Bootcamp opened for registration at ₦50,000 / $50 with 20 slots. He framed it as the opposite of a formula-memorization course: 'Not just learn formulas. Not just watch someone explain VLOOKUP, XLOOKUP or PivotTables. But actually take supply chain data, analyze it and turn it into a dashboard.' Over 5 weeks, live and recorded, covering Excel for supply chain analysis, data cleaning, inventory and logistics analysis, KPI reporting, dashboard development, and AI for faster analysis [5], [6]. The promo drove heavy DM traffic. He posted that he answered 70+ DMs and still had more pending — 'You guys don't want me to watch my Naruto today 😭😂' — and flagged that he had never generated that kind of response before [7], [8]. He routed interested people to DM him 'SUPPLY CHAIN' so he could assess fit personally, and by Sep-20 he shared that the cohort's first meeting had wrapped with the team 'LOCKEDIN' [9], [10]. He also shouted out his Power BI students, saying 'These Power BI students got the best out of me' [11].
Consulting Work & Projects
He showcased an Executive Logistics Dashboard built for Southern Cross Freight & Logistics (SCFL), designed around three principles: start with the decisions not the charts, put the most important KPIs where they can't be missed (shipment volume, total weight, distance, average shipment weight), and add trends not just totals. 'Good dashboards don't just report the past. They help teams see what deserves attention next' [12], [13]. He retweeted his own Sep-14 positioning post — 'I don't just build dashboards. I build reporting and workflow systems' — citing a workflow where a 4-hour manual reporting process was cut to roughly 20 minutes. His tool stack: Excel, Google Sheets, VBA, Apps Script, Power BI, and AI. 'I'm not interested in using more tools just for the sake of using more tools' [14]. The week closed with a concrete service offer: the 14-Day Logistics Reporting & Operations System. For 3PL, logistics, and e-commerce businesses, delivering a working Excel/Google Sheets system, automated reporting workflow, management dashboard, exception reporting, documentation, and a 45-minute handover in 10–14 days. The pitch: 'Stop rebuilding reports manually. Start running your operations from a system.' DM 'OPS' to start [15].
Personal & Professional Journey
He introduced himself widely this week, quote-posting a networking prompt to declare: 'I'm Victor Chidera Ugwu. A BI & Supply Chain Analytics Consultant, based in Nigeria 🇳🇬. Looking to connect with founders, directors, managers & small business owners.' The post hit 795 views — his biggest reach of the week via retweet [16], [17]. He posted a Monday motivation note — 'It is Monday 🤕 Time to do some crazy stuffs' [18] — and joked about being the best data analysis teacher in Enugu, echoing a peer's identical claim about Ilorin [19]. He also bantered with @ObohX about being called 'Excel Final BOSS' [20].
Top conversations
10-post exchange · 22 views@_victorugwu quote-posted @TechnicalBben's thread on forming a 3-person sales squad to chase dollar-paying clients, then spent the week routing interested replies to DMs and asking people what niche they worked in — he matched responders to collaborators in related niches and told one they needed a laptop to join [21], [22]. [21]
3-post exchange · 7 viewsHe and @ObohX shared mutual frustration with Airtel Nigeria's internet service — @_victorugwu reported he couldn't even load a single site and tagged @AirtelNigeria asking them to fix it [23]. [23]
1-post exchange · 3 views@ObohX joked about blocking @_victorugwu for teasing him too much; @_victorugwu leaned into the banter, calling himself 'Excel Final BOSS' [20]. [20]
Retweets
255 viewsRetweeted @ObohX's Monday prayer post — 'ALLAH CHINEKE GOD ! New things this week, Amen' — a casual week-opening sentiment. [24]
77 viewsRetweeted @DaudaAbdullahiS advising analysts not to switch fields because the entry-level market is rough — instead, build 2-3 quality projects, apply to smaller companies, and learn to use AI for analysis without depending on it blindly. [25]
44 viewsRetweeted @_osisehh's thread asking data analysts whether they are using the right tool for the analysis or forcing the analysis to fit the tools they already know. [26]
15 viewsRetweeted @Inem_arch's showcase of a 4-page E-Commerce Profitability Analysis dashboard in Power BI covering revenue, discounts, returns, and delivery performance built entirely with DAX. [27]
3 viewsRetweeted @Smanmalik83 reminding data analysts to dig deeper and ensure data is cleaned before analysis — checking distributions and completeness, not assuming challenge datasets are pre-cleaned. [28]
Calls
- N/A14-Day Logistics Reporting & Operations SystemBusinesses should replace static dashboards with operational systems that connect inventory data to reorder alerts and procurement decisions — his 14-Day Logistics Reporting & Operations System is the consulting offer that delivers this. [15]
- N/AExcel & AI for Supply Chain Analytics Bootcamp Cohort 3Cohort 3 of the Excel & AI for Supply Chain Analytics Bootcamp is open for registration at ₦50,000 / $50 with 20 slots. [5]
