For groups of hotels, stores, clinics or companies

Every site on one page. Compared fairly.

You can't manage what you can't see. When each site reports its own way, the group view takes days and nobody trusts the ranking. We bring all of every site's data, from finance and operations to sales and marketing, into one set of numbers, with the same rules, fair comparisons and a group total that adds up.

Zohal ZahirYou'll work with Zohal Zahir, Microsoft certified in Power BI and Fabric.
Microsoft Partner5.0 client reviews30-day fix guarantee
Margin per room vs planAll sites · this month
Site 4
+8%
Site 1
+3%
Site 6
−1%
Site 2
−4%
Site 5
−9%
Group total$1.24MMatches the ledger

Sound familiar?

If you tick two or more, this page is for you.

  • Each site sends a different spreadsheet
  • Group financials take days to put together
  • A small site and a big site can't be compared fairly
  • A lender or investor asks, and it takes a week
  • Managers can see every other site's numbers
  • The same customer appears in every branch under a different name
Built forHotelsRetail storesClinicsChildcare centresFranchisesRestaurants and venuesGroups of companies

The hidden problem

Every branch you acquired writes names differently

Each branch kept its own system and its own habits. So one customer can appear three times, and nobody can tell if they are the same person. Totals double-count and the group view is wrong.

Branch AJonathan Smith · 12 King St · 0412 555 018
Branch BJ. Smith · 12 King Street · jon.smith@mail.com
Branch CSMITH, JON · 0412555018
Jonathan SmithOne customer · 3 records linked

This is a hard problem. We solve it with advanced data science techniques, known as entity resolution, so you get centralised visibility of every customer across every branch.

How we find out if they are the same person

  1. CleanTidy names, addresses and phone numbers into one format: "St" and "Street", spaces and capitals.
  2. CompareCheck name, address, phone, email and date of birth together, allowing for nicknames and typos.
  3. ScoreGive each pair a match score. Strong matches are linked automatically.
  4. ConfirmUnsure matches go to a person to check. Nothing is guessed.

The same method works for suppliers, products and the branches themselves, and it keeps working as new records arrive.

Case study

A hotel group: from dozens of workbooks to one platform

Before

Property workbooks that could not feed Power BI. Benchmarking, debt schedules and budgets spread across dozens of sheets. A week of work whenever a lender or investor asked a question.

After

Each property's files land automatically and are standardised. Size-adjusted benchmarking, profit by property and revenue line. Owner, investor and lender reporting on demand, proved back to the ledger, with each person seeing only what they should.

5 audiencesone set of numbers5 phaseseach one signed off
"Zohal did an excellent job on our Power BI project. She was professional, responsive, and demonstrated a strong understanding of Power BI, data visualization, and reporting requirements. … The final dashboards and reports were well-structured, clear, and very useful."Client, hotel portfolio group · ★★★★★ verified review

See all case studies →

What you get

One report for the whole group, and the right view for every person in it.

Site league tableEvery site side by side, per room, per square metre or per staff hour.
Group financials that add upP&L, balance sheet and budget vs actual for every site and the group, reconciled to your ledger.
BenchmarkingSites against each other, against budget and against the market, adjusted for size.
Operations, sales and marketingOccupancy, sales per staff hour, stock, labour, campaigns and customers, next to the financials.
Drill from group to lineGroup, to area, to site, to account, in two clicks.
Each manager sees their siteOwners see the group. Managers see only their own numbers.
Owner, investor and lender packsThe same numbers, shaped for each audience, on demand.
One master listSites, suppliers, customers and products matched across every system. New sites are matched once and appear everywhere.
Example multi-store financial report comparing stores, with sample dataExample multi-store report, sample data
Any data, every siteFinanceBenchmarkingOperationsSales and customersMarketingPayroll and labourStock and suppliersLender and investor reportingAny other system you use

You can't manage what you can't see

One central view: the foundation for reporting and AI

Matched, centralised data is what makes every report trustworthy, and it is what AI needs too. AI is only as good as the data under it.

  1. 4

    Ready for AI

    Copilot on your Power BI reports answers from the same checked numbers.

    You getPlain-word answers you can trust
  2. 3

    Reports for every audience

    Managers, owners, lenders: each sees the right view of the same numbers.

    You getLeague table, group financials, benchmarks, KPIs
  3. 2

    One central model

    Same accounts, same rules, governed and monitored on every refresh.

    You getOne source of truth, checked daily
  4. 1

    Matched master lists

    Every site, supplier, customer and product recognised across every system.

    You getNo double counts, no missing sites

How it is priced

From AUD 90 an hour. You see the estimate first.

Before any work starts, you get a written estimate of the hours for each stage. Bigger groups are built in phases, so you see the first sites working early and sign off each step. If something needs more time, we tell you and you approve it first.

FromAUD 90per hourWritten estimate before work starts · Built in phases you sign off · 30-day fix guarantee

What changes the hours

  • How many sites and companies you have
  • How messy the names and codes are across systems
  • How different each site's data is
  • How you want to compare them: per room, per square metre, per staff hour
  • How many audiences need their own view: managers, owners, lenders
  • Whether you need Microsoft Fabric underneath, or Power BI alone

A good first step is often two or three sites, then the rest once the rules are agreed.

How it works

  1. Free call

    How your sites report today.

  2. Agree the rules

    One chart of accounts, one way to compare.

  3. First sites live

    Two or three sites, checked against the ledger.

  4. Whole group

    All sites, security set, team trained.

Questions group owners ask

Our sites use different systems and spreadsheets. Can you still combine them?

Yes. Each site's files or system exports are mapped to the same accounts and rules as they come in, so the group view is built automatically, however each site sends its numbers.

How do you compare sites of different sizes fairly?

By comparing per unit as well as in total: per room, per square metre, per staff hour or per customer, whichever fits your business. A small site doing well is no longer hidden behind a big site's totals.

How do you know if two customers from different branches are the same person?

This is a hard problem, solved with advanced data science techniques known as entity resolution. We compare names, addresses, phones and emails, allowing for typos and nicknames, link strong matches automatically and send unsure ones to a person to confirm. The result is centralised visibility of every customer across every branch.

Can each manager see only their own site?

Yes. Row-level security means each manager sees their site, area managers see their area, and owners see the group, all from the same report. It is set up and tested before go-live.

Will the group total match our accounts?

Yes. The group total equals the sum of the sites, and it is reconciled to your ledger before handover.

Can we add new sites later?

Yes. A new site is added by mapping its data once. The reports, comparisons and security pick it up automatically.

How much does it cost?

From AUD 90 an hour. Before any work starts you get a written estimate of the hours for each stage. The hours depend on how many sites and entities you have, how different their data is, and how many audiences need their own view.

Do we need Microsoft Fabric?

Not always. A few sites with clean data can run on Power BI alone. Many sites, many files, or lender and investor reporting usually need Fabric underneath. We tell you which on the free call.

See every site clearly, every month.

A free 30-minute call. Tell us how many sites you have and how they report today. You get an honest view of what it takes.

Book a free call30 minutes. Reply within two business days