The Question
A Malaysian kedai runcit in a neighbourhood of Kajang runs seven days a week, from seven in the morning to ten at night. The shop is run single-handed. The till records every sale — around fifty sales a day across groceries, dairy, snacks, vegetables, and bakery — and none of those records are ever read, because the only way to read them is to stop serving customers and open a dashboard on a phone screen.
For years, the owner had been running on instinct. Which days are busy. Which categories move the shelves. Whether the stamp card actually changed how people spent. Whether to push DuitNow or stick with cash and card. Each of those decisions, on its own, was small. Stacked across three months, they added up to whether the shop runs the owner, or the owner runs the shop.
They brought the question to Pau Analytics: in three months of till data, where is the money actually coming from — and what should we be doing about it?
What the Data Showed
We took three months of the shop's till data — 4,285 sales across 90 days, from the first of January to the thirty-first of March — and we looked at it the way the shop would look at it if the shop had time. Not one axis. Several at once. Which days. Which categories. Which customers. Which payment rails.
The pattern came back sharper than anyone expected.
Monthly totals looked flat — January RM 124,000, February RM 109,000, March RM 124,000 — and every hour of the shop's day looked roughly like every other. But zoom in one level, and the flat month fell apart. The single best day in the quarter brought in nearly seven thousand ringgit. The single quietest day, inside the same calendar week, brought in under one thousand. The shop's real rhythm ran at the week and the day, not at the month.
Then came the finding the owner needed to hear. Friday, Saturday and Sunday carry the shop. Three days out of seven — 43% of the week — earn 49% of the quarter's revenue. On a per-day basis, weekend days run twenty-seven percent higher than weekdays. The pattern held in every one of the thirteen weeks we looked at, steady as clockwork.
Under that headline, two more findings followed. The stamp card was earning its keep — members spent RM 12.60 more per basket than walk-ins, worth about twenty-six thousand ringgit of extra revenue in the quarter alone. Dairy carried the revenue share; Bakery quietly lagged on every measure. Credit card processing was costing roughly two thousand ringgit a year in fees that DuitNow QR could have avoided.
What Changed
The report gave the owner three things they didn't have before.
A weekly operating rhythm in place of a seven-day-flat routine. Friday to Sunday became the shop's one prime period: supplier deliveries timed for Thursday evenings, bundle promotions running only across those three days, cash deposits moved to Monday morning. Monday to Thursday became the other period: stock rotation, shelf cleaning, slow-day tasks. The shop was no longer running every day the same.
A three-tier reorder rule that replaced gut-feel stocking. Beverages and Dairy were flagged as push — the categories earning the most per basket. Vegetables and Fruits held as the reliable middle. Bakery was flagged for tightening — smallest basket in the shop, seven-nine percent of revenue from fifteen percent of sales. Supplier terms on Bakery went under review; low-moving ranges shrank.
A three-number Sunday morning check, instead of a twenty-four-chart dashboard the owner was never going to open. One: daily revenue floor at RM 2,800 — two days below, and something is wrong. Two: member average basket at RM 85 — below that, the stamp card is losing its grip. Three: credit card share ceiling at 25% — above that, the DuitNow push is fading. Five minutes on a Sunday, three alarms, each against one week of data.
The Result
Today, the shop runs on two calendars. Friday through Sunday is the prime operating window — stocked early, promoted with a family-pack bundle only on those three days, staffed deliberately where a hand is available. Monday through Thursday is the planning window — the slow days are now scheduled work, not under-used hours.
At the till, a laminated sign sits next to the payment terminal: "DuitNow ada. Bayar free charge." When a basket goes above RM 50 and a customer reaches for a credit card, the owner now asks, "Card ke DuitNow? Lagi cepat." Nine times out of ten, the customer switches. Credit card share is already drifting down from thirty percent toward the twenty-five percent ceiling.
The stamp card stayed. A tier-two benefit is being designed — RM 5 off on baskets above RM 100 — to widen the member-versus-walk-in gap further. Every Sunday morning, the owner opens the till system once, not to read twenty-four charts, but to check three numbers. That is the dashboard the shop actually uses now.
"I was running the shop the same way every day, Monday to Sunday. The numbers told me that was leaving money on the Thursday table. Now the weekend is the week — and the week is when I plan."