Use cases
What we found when we looked, and what we built after. Written to be understood without a technical background.
a company that keeps stock on hand against demand it has to predict
Out of the best sellers. Overstocked on the rest.
They were short of their best sellers and overstocked on everything slow, at the same time. Both came from the same missing number.
a business whose largest customers are groups rather than single companies
Every number checked out. The report was still wrong.
Their largest customer never appeared on any list of largest customers. Nothing was broken and no data was missing. It had been divided across its own branches.
a company that buys goods in specially for each customer order
Nobody was missing information. They were missing it in one place.
A customer asks where their order is. It sounds like one lookup. It never was, because the honest answer depended on a second order that the customer never placed.
a company whose product files live on a shared drive
Nobody wanted to be the one who deleted the wrong file
A shared drive of product files had drifted out of order for years. Cleaning it was never the hard part. Approving the cleaning was the part nobody would do.
a wholesale distributor with a large catalogue of physical products
When the customer can only send a photo
Customers asked for products by photographing them. The catalogue could only be searched by words, and the difference between two similar items often has no word attached to it.