Articles

Client Reporting Portals: How to Give Each Customer Their Own Dashboard

Plenty of firms report to their own clients. Accounting firms share financials, logistics providers share shipment performance, managed service providers share ticket and uptime numbers, and suppliers share delivery and quality data with their customers. For most of them, that reporting is still a PDF or a spreadsheet attached to an email.

A client reporting portal replaces that with a site where each client signs in and sees their own numbers, current and in your branding. It is a better experience and it can be a real differentiator. It is also easy to get wrong, and the mistakes are the kind that end relationships.

What clients expect

They expect to see only their own data, with no possibility of seeing anyone else's. They expect numbers that are current, not a month old. They expect a simple sign-in, a clean look and the ability to download what they need. And they expect it to work every time they open it.

The hard parts

Data isolation. This is the one that cannot fail. Client A must never see client B's figures, in a chart, an export, an email, a shared link or a filter dropdown. Our guide to row-level security in BI covers where isolation tends to leak.

Branding. Clients like a portal that looks like it belongs to you, or in some cases to them. Logo, colors and address should be configurable per client.

Identity. Clients' people join and leave. You need a way to add and remove users, ideally with single sign-on for larger clients, and a clear owner on each side.

Consistent definitions. If every client gets a slightly different calculation of the same metric, support becomes a nightmare. Define the numbers once and apply them to everyone.

Performance. A portal used by dozens of clients at the start of every month has to stay fast.

Support. When a client says a number looks wrong, you need to be able to see what they see and to trace where it came from.

Your options

Keep emailing files. It works until it does not, and it does not scale. Embed dashboards from a BI tool into your own site, which can work well but needs careful attention to licensing and to how isolation is done. Build a custom portal, which gives control and carries all the maintenance. Or use a managed platform where a partner builds the reports, hosts the portal and runs it. The trade-offs are the same ones we describe in managed BI versus self-service BI.

A checklist for evaluating any option

Ask how isolation is enforced: separate data per client, or one shared dataset filtered by who is looking. Then test it yourself by signing in as a user from one client and trying to reach another's data through every route, including exports and links. Ask what the audit log records. Ask how branding is set per client and how new clients are onboarded. Ask what happens to scheduled emails and shared links. And ask what it costs when you go from five clients to fifty.

Roll it out gradually

Start with two or three friendly clients and build a template set of reports that most clients share. Watch how they use it and what they ask for. Write down an onboarding routine for each new client, including how their data is connected and how their users are set up. Measure whether people actually sign in, because a portal nobody opens is just a more expensive PDF.

Where Horizon fits

Horizon gives each client their own branded site and limits every person to the data they are allowed to see, with the limits applied on the server to every chart, export, email and API call. It is built and run by our team, which suits firms that want a portal without running one. It is not a tool for clients to build their own reports.

If you are also weighing tools, our piece on Tableau alternatives covers the self-service side.


If you want to give clients their own dashboards and want the isolation and rollout plan reviewed first, reach out.

Have a question about this topic? We work with businesses worldwide.

Get in Touch