From scattered numbers to a clear view of the operations of each coffee shop, every day.
How a hospitality business stopped reviewing Excel spreadsheets and receipts to understand what was really happening in its establishment.

15 hours
per month recovered by the team
1 day
for the detection of deviations
+15%
better fit of staff on site

Type of company
Coffee shop business:
8 locations
Lots of daily traffic
Tight margins
Quick decisions
Existing systems: POS
Personnel control
Excel spreadsheet for “seeing how we’re doing”
The business was working, but the owner didn't have a clear idea of everything that was happening simultaneously in his business .
The Problem
The data exists, but it's scattered:
Sales at the POS
Tickets in the system
Staff and shifts in Excel
Costs “in the head”
Every week:
Review tickets
Export data
Adjust Excel
Trying to understand what happened
Nothing seems serious.
But the business gets lost in small details .
What was built

A simple, custom-made dashboard was created, adapted to the day-to-day operations of the café, which connects existing data and displays it clearly.
The system allows you to see the business effortlessly , without analyzing it for hours.
What the dashboard shows
Map showing all store locations
Daily sales and sales by time slot
Average ticket
Best and worst selling products
Sales/staff ratio
Comparison with previous days or weeks
Everything in one place .
Without Excel.
Without waiting for reports.
How it is used in practice
The owner comes in the morning
See if the previous day was good or bad.
Quickly detects where to adjust:
Schedules
Staff
Offer
Make small but consistent decisions
.png)

What was NOT built
The POS terminal was not changed
A complex system was not implemented
Staff were not forced to do anything different
A “corporate dashboard” was not created
It connected to what already existed
and only what was necessary was shown.
The Results
Operational impact
Elimination of time spent preparing reports
Daily business overview
Rapid detection of problem days or periods
Decisions based on simple data, not intuition
Business Impact
Better staffing adjustment
Less waste
Greater margin control
Less stress for the owner




