Franchise
How does profitability compare across franchisees?
Franchise networks create a natural comparison -- franchisee against franchisee, region against region -- but franchisor and franchisee systems rarely share data cleanly, so the comparison usually has to be assembled by hand, unit by unit. FactSmith puts comparable units side by side, within whatever permission boundary each franchisee is entitled to see.
Why this matters
Without a consistent comparison, both underperforming units and strong performers stay invisible until an annual review.
What data is needed
Unit-level sales and, where available, cost or margin facts, consistently defined across franchisees. This is the sector where data ownership is the real constraint -- franchisor and franchisee need to agree who can see what before this becomes answerable at all.
The evaluation copy runs against PostgreSQL. SQL Server is on the adapter path for a customer warehouse; that path is not what the package proves end to end today.
How the analysis works
Franchisee units are ranked on a consistent basis, with row- and column-level permissions applied first, so a franchisee only ever sees what they are entitled to and a group-level user sees the full comparison.
What can go wrong
Comparing units of very different size or age without normalising distorts the ranking. Unresolved data-ownership disputes between franchisor and franchisee can mean the underlying data is not accessible at all -- worth confirming in discovery before assuming this question is answerable today.
Example
A franchise group asks which units rank lowest on margin this quarter within a region. Group office sees the full ranked list; a franchisee logged in sees only their own unit's numbers.
How FactSmith approaches it
Ask is what is available now. Easy Data -- turning messy sources into that dimensional foundation -- is in early development.
FactSmith calls this the Fact Layer: a data integration (ETL) step, a knowledge base, and a business ontology, working together underneath the answer. On screen it stays simple -- ask a question, get a trusted answer -- with the layer-by-layer detail available to anyone who wants to see how the answer was built.
Permissions are enforced beneath the AI, not by it -- see Trust and security.
Related questions
For franchise networks · How it works · Store profitability (retail)