How can retail businesses connect fragmented business data?
Fragmentation is usually a history of sensible decisions. Accounting went into one system, stock into another, customer conversations into an inbox, and quoting into a spreadsheet. Each was right at the time. What was never decided is which system holds the authoritative version of a customer, a product or a job.
( The Detail )
The constraint underneath
Without that decision, connecting data means settling dozens of small disputes: two spellings of a supplier, three codes for one product, a customer who exists twice. The technical join is the straightforward part. The real work is agreeing on identifiers and on who is allowed to change them.
How this plays out here
Physical retail carries stock risk across locations, so the operational questions are about what is where, what is not selling, and what was marked down too late. Counting, transfers and shrinkage complicate every stock figure the systems report, and the errors compound between counts.
Staffing is casual and rotating, so process knowledge leaves regularly. Rules about discounts, returns and holds are often carried by long-serving staff rather than written down, which makes consistency across shifts and stores harder than the underlying systems would suggest.
How to approach it
Begin with the decision rather than the tool. Name the recurring judgement this affects, the information it depends on, and the person accountable for acting on the result. That framing keeps the first build small enough to inspect and useful enough to matter.
Keep a human review point in the loop until the quality and the failure modes are understood. A system that shows its working - what it drew on, where it is uncertain, and what it deliberately left alone - is one a business can keep running after the initial build.
( Next Step )
Start small enough to review, but on a workflow important enough to show whether a better system is worth building.