Most warehouse audits I've seen focus on the wrong things first. Neat labels, clean floors, a binder full of SOPs nobody's opened in months — all of it can look great and still sit on top of a warehouse that's quietly bleeding money.
And the SOP binder is usually worse than just outdated. Somewhere along the way, the actual process changed — someone found a faster way to do something, or worked around a problem — and that change lived in their head, not in the document. Everyone just adapts and moves on. Then that person leaves, and suddenly nobody can explain why the process works the way it does, because the only place it was ever really "written down" walked out the door.
If I only had fifteen minutes to walk a warehouse, here's honestly what I'd check.
I'd skip the month-end accuracy report and ask what's mismatched right now, today. A clean number at month-end really just tells you how good someone is at patching things up before a deadline. Asking about today tells you whether the process actually holds up when nobody's paying special attention to it.
Then I'd go find one picker and just watch them complete one real order, start to finish — not a demo, an actual order in the middle of a shift. You learn more in five minutes of watching someone walk a pick path than you do in an hour of reading reports. How far they're walking, how often they double back, how many times they have to stop and ask someone where something actually is.
I'd also want to know how long stock sits between receiving and put-away. Not how fast it gets scanned in — how long it physically sits on the dock before it's properly stored. That gap, more than almost anything else, is where damage, shrinkage, and "we can't find it" problems quietly start.
And I'd ask a warehouse worker why something's done a certain way — not a supervisor. If the answer is "that's just how we've always done it," that's usually a process nobody's questioned in years, or worse, a workaround that only exists in that one person's head.
Last thing, I'd look at what's actually sitting near the exit versus what's actually fast-moving. Layouts get set once and almost never revisited. More often than you'd think, the stuff people grab constantly is buried in the back, and something nobody's touched in months is sitting right up front for reasons nobody remembers anymore.
None of this needs a clipboard or a formal audit template. It just needs fifteen minutes and being willing to ask "why" one more time than feels comfortable — because the answer might only exist in one person's head, and that's the real audit finding.
SyncGuard, a Shopify app I built that checks every order actually made it into QuickBooks Online. If the sync breaks or an order goes missing, it flags it so the books don't go out wrong. Read only, so it never touches store or accounting data.
One business problem. Three analytical routes. One data-driven story. ☕📊
I turned raw business data into actionable decisions—not just another Power BI dashboard.
For the Onyx Data October 2026 Challenge, I worked on the Sunrise Coffee Chain analytics project, analyzing store performance, profitability, customer loyalty, revenue mix, and trading patterns across 60 UK stores (2023–2024).
🔹 My Analytical Approach
1️⃣ Python — Data Preparation
Cleaned and prepared the source datasets to establish a reliable foundation for analysis.
2️⃣ SQL — Business Analysis
Investigated store-level profitability, cost pressure, customer loyalty, revenue contribution, and trading patterns.
3️⃣ Power BI — Interactive Dashboards
Built a 3-page interactive report featuring advanced DAX measures, KPI cards, YoY comparisons, profitability analysis, and business-focused visualizations.
📊 Key Findings
• £89.7M Revenue | £16.9M Net Profit
The business recorded an aggregate net profit margin of 18.8% across the analysis period.
• Store Location Matters
Transport-Hub stores achieved a 25.1% aggregate net profit margin, compared with 18.6% for High-Street stores.
• An Area Requiring Attention
South London Corner recorded a £50.5K net loss over 24 months.
• Product Revenue Contribution
Espresso contributed 45.7% of daily revenue, while food contributed 26.1%.
• Trading Patterns
Average daily revenue was approximately 24% lower on weekends and 33% lower on UK bank holidays than on regular trading days.
💡 My Biggest Takeaway
Revenue alone does not tell the whole story. Understanding profitability, cost pressure, product contribution, and trading patterns helps businesses identify where to improve performance and make better decisions.
I would investigate South London Corner first. Break the 24-month loss into store-month revenue, direct costs and allocated costs, then compare it with similar stores over matched trading periods. Reconcile at store-month grain before joining product or loyalty tables so a...