A few years back, a distributor we know decided to figure out, once and for all, which of their customers were actually profitable. Not revenue — profit, after freight and handling and the returns nobody likes to talk about. It took an afternoon with a spreadsheet, a lot of squinting, and one genuinely surprising discovery: a longtime account they’d always considered a cornerstone of the business was, on paper, barely breaking even.
That one afternoon didn’t overhaul anything. Nobody got fired, nothing got torn down and rebuilt. But it changed how that owner looked at the business going forward — and a year later, when they finally connected their systems into something that could answer that question automatically, it wasn’t a leap of faith. It was the natural next step after a question they’d already learned mattered.
That’s usually how this goes. Not with a five-year plan unveiled at an all-hands meeting, but with one good decision, made because it was useful, that quietly opens the door to the next one.
Where to Start (Hint: It’s Not With a Dashboard)
Here’s a pattern worth knowing about before you begin: a lot of businesses start their data journey by picking a shiny new dashboard tool first, hoping the insight will follow. It’s an understandable impulse — dashboards are the part you can actually see. But connecting a pretty new tool to the same scattered, inconsistent data the business already had just gives you a better-looking version of the same confusion.
The nicer way to think about it: start with the questions that actually run your business, not a tool. Margin by customer, which locations are having a good month, which accounts have gone quiet, how healthy your inventory really is, where cash is tied up in receivables — those questions are the starting point. And here’s the part that surprises most people: with the right approach, you don’t have to pick just one and wait months for the rest. A properly built foundation can answer several of them at once, in a matter of weeks, not quarters.
What a Real Build Actually Looks Like
We ran this exact experiment ourselves, out loud, so we wouldn’t just be guessing. We built out a fictional distribution company — a full operational stack, a believable mess of an ERP, a CRM, receivables — and then built the complete thing: a governed data warehouse, a set of real dashboards, and a chat layer you could ask plain-English questions of. Margin erosion by product and customer. Inventory health and write-off risk. Supplier performance. Sales territory trends. Cash flow and aging receivables. Five serious operational questions, answered together, not one at a time.
Start to finish: thirteen days. Not because we cut corners, but because the newest generation of data tooling, handled by people who know how to sequence the work, genuinely moves that fast without sacrificing governance or accuracy. The model even surfaced over a dozen patterns in the data nobody had explicitly gone looking for — the kind of thing that only shows up once the foundation is solid enough to ask it questions.
That’s the real shape of this. Not a business owner spending nights and weekends teaching themselves ETL. A systematic build, done properly, by people who’ve done it before — compressed into weeks because the process itself is disciplined, not because anything got rushed.
What Your Part in This Actually Is
None of that means your role is to sit back and wait for a finished product to land on your desk. The businesses that get the most out of a build like this are the ones who show up for it — who know their own operation well enough to say “that number looks off” or “we actually care more about this question than that one.” The technical build moves fast. The business judgment that points it in the right direction is still yours to bring, and it matters as much as anything a data team does on their end.
A few things are still worth understanding about how the pieces fit together, because they shape what you should expect and what you should ask for.
Know What You’ve Got
Before any build starts, someone needs a clear picture of which systems hold which data, and how long each one actually keeps it. This tends to turn up a pleasant surprise or two — and occasionally an unpleasant one, like a retention setting quietly deleting history nobody knew was disappearing. Better to find that at the start than to discover it’s gone.
Let the Plumbing Get Done Right
The unglamorous middle step — cleaning and standardizing data so it plays nicely across systems — does the real heavy lifting, even though nothing about it looks impressive from the outside. This is where a “customer” in the CRM quietly becomes the same thing as an “account” in the ERP, instead of staying two strangers who happen to share a name. You don’t need to do this work yourself. You do need to trust that whoever’s doing it is doing it carefully — this is the step that makes everything built on top of it trustworthy or not.
Expect a Proper Home for the Data, Not a Patchwork
A central, well-organized warehouse, built around the questions that actually matter to your business — not a generic template. This is where the institutional memory from earlier in this series starts to accumulate, and where retention gets decided on purpose instead of by accident.
Insist on Seeing It Work, Early and Often
A good build doesn’t disappear for months and reappear with a finished product. It shows you real answers to real questions along the way — the moment “we’re working on our data” turns into “I can just look this up now.” If weeks are going by without anything to look at, that’s worth asking about.
Where Your Commitment Matters Most
Once the system exists, two things determine whether it keeps paying off — and both of them are squarely on your side of the table.
Agree on Who Owns What
A BI initiative without a specific person accountable for its progress becomes everyone’s second priority and therefore no one’s first. This doesn’t require a new hire — Article 5 made the case that it shouldn’t be one person’s job alone — but it does require someone with the authority and the mandate to keep the sequence moving.
Grow the Team Alongside the Tools
This is the one that matters most, and it’s entirely yours to carry. A technically perfect warehouse that nobody in your organization knows how to question is an expensive filing cabinet. The businesses that keep getting more value out of a system like this over time are the ones that treat it as something their whole team learns to use — asking it questions, pushing back on what it says, getting more fluent with it month over month. That commitment, more than any technical choice, is what determines whether this becomes a real capability or an underused tool.
A Few Bumps Worth Knowing About
A handful of familiar bumps trip up a lot of well-meaning first attempts. Worth naming plainly, so you can wave to them as you pass.
Trying to build it yourself, piecemeal, on the side. There’s a difference between a comprehensive build and a DIY one. Stitching together your own dashboards one weekend at a time, or assigned to an intern, with no one sequencing the work properly, is how good intentions quietly stall. A systematic build that answers several real questions together, handled by people who do this for a living, isn’t “doing too much” — it’s just doing it right.
Rushing past the cleanup. Dashboards are the fun part, so it’s natural to want to get there fast. But a dashboard built on data that hasn’t been sorted out yet just gives you a confident-looking wrong answer — dressed up nicely, still wrong.
Nobody’s clearly in charge of it. A data project without a specific person keeping an eye on it tends to become everyone’s second priority — which quietly makes it no one’s first. There’s no need to bring someone new on board; it just needs to be someone’s job to keep the thing moving.
Treating it like a project instead of a habit. A project has a finish line. A habit compounds. The businesses that keep getting better at this are the ones who never quite declared themselves “done.”
Where This All Adds Up
Back in the first article of this series, we talked about a gap between businesses that can see themselves clearly and those that can’t — and how that gap tends to grow, not shrink, over time. Five years from now, that slow compounding adds up to two pretty different pictures.
| The Business That Started Early | The Business That Waited |
|---|---|
| Years of clean, connected history — ready to put to work as AI keeps getting better | Data scattered across systems and retention windows, some of it already gone for good |
| People across every team who are comfortable asking questions of live data | A couple of people who know how to pull a report, and a lot of guessing in between |
| Decisions made in days, backed by evidence that keeps itself current | Decisions made on a lag, backed by whatever got assembled most recently |
| Supplier conversations grounded in a track record everyone can see | Supplier conversations grounded in general impression and how things have always gone |
| A comfortable, steady way to bring in new AI capability as it matures | Either no AI in the mix yet, or AI nobody’s quite sure they can trust |
Neither of those five-year stories is unusual or dramatic. They’re just what happens, gently, when a string of small decisions — made or put off, quarter after quarter — adds up. The businesses in that first column didn’t necessarily start with more money or a cleverer plan. They started with one good question, and then they asked another.
The Point of All Six Articles
This series opened with a simple observation: the businesses that can see themselves clearly are pulling ahead of the ones that can’t, a little more every quarter. Five articles later, that observation hasn’t changed — but hopefully what to do about it feels a lot less abstract than it did at the start.
Your data is already telling you something, whether anyone’s listening yet or not. Your team is either growing more comfortable working alongside AI, or drifting, without anyone quite deciding it should. Your supplier conversations are either backed by evidence or by memory. None of that is a hypothetical future — it’s just today, quietly adding up.
None of it calls for a five-year plan, a data science team, or turning the business upside down to get there. It calls for one good decision — choosing to build this properly, with people who know how, and showing up to the process with the judgment only you have about your own business. That’s the decision. Everything else is sequencing.
Five years from now, the businesses that feel like they’re operating on a different level won’t be the ones who waited for the perfect plan, or the ones who tried to piece it together alone. They’ll be the ones who decided to build it right — and then stayed in the room while it got built.