The short answer. An executive KPI dashboard is one of the easiest apps to justify building yourself. It is a short list of metrics, each with an agreed definition, a target and a named owner, plus the trend and a visible refresh time. Your BI tool stays where it is for analysis. The leadership page is small, specific to your company, and used by a handful of people. The catch is that it becomes the page a board pack is drawn from, so it needs sign-in, a frozen record of each period and an owner. Tray Helix gives you those.
What the leadership meeting looks like today
Sales brings a revenue number from the CRM. Finance brings a different one from the ERP. Marketing brings pipeline from a third dashboard, counted a third way. The first twenty minutes of the meeting go on working out which number is right.
When the numbers do agree, they often arrive with no target next to them, so nobody can tell whether 2.7 times pipeline cover is good. And when a figure fails to refresh, the dashboard shows last week’s value as if it were current. That is the figure that ends up in the board pack.
Each of these comes down to a decision: which numbers matter, how each is defined, who owns it, and what it should be.
Keep BI for analysis
BI tools are good at what they were built for: exploring data, slicing it, and building the functional dashboards each team lives in. A sales team can carry forty numbers on its own dashboard because it looks at them every day. Keep that.
An executive dashboard is a different object. It carries ten to fifteen numbers, each tied to something the leadership team can change, and links to the functional dashboards for everything else. The work is mostly agreement: definitions, targets, owners and a cadence. That is why it fits a small app you own. Three things point the same way.
The metrics and the rules around them are yours
An executive dashboard has four parts: a short list of metrics with agreed definitions, a target and an owner on every one, trend rather than a single point in time, and a visible refresh state.
Every one of those is a company decision. Which twelve metrics, how revenue is counted, what the target is this quarter, who defends each number. An app you build can enforce them as rules: a hard cap of fifteen metrics, because the pressure is always to add, target and owner as required fields, and a metric past its refresh cadence shown as stale rather than as current.
The workflow matters as much as the numbers
The dashboard earns its place in the week before the meeting. Each owner writes a line next to their metric: what moved, why, and what they are doing about it. That line turns an agenda item into a decision.
At period end, the dashboard freezes. Data underneath gets corrected and backfilled, and without a snapshot the September figure changes after September was reported. With one, later corrections show as a difference, not a rewrite.
Commentary, required owners, a metric cap and period-end snapshots are workflow, specific to how your leadership team runs. That is the part an app you build can fit exactly.
The data is already in systems you own
Revenue sits in the CRM and the ERP. Retention and usage sit in the product database or the warehouse. Most companies with a leadership dashboard problem already move this data into a warehouse.
An app you build reads from those sources directly. If your metrics are already modeled in the warehouse, the dashboard reads the modeled tables, and the definitions stay where your data team keeps them.
What it takes to run your own
A first version with a short list, targets, owners and trend lines can come together in days. What makes leadership trust it is everything around it.
It shows company performance before the board sees it. So it needs four things from day one:
- Sign-in. Leaders and owners log in with their company account. A shared link to unreported results is a disclosure risk.
- Scoped access. Owners edit the commentary on their own metrics. Only the dashboard’s owner changes the list, the targets or the definitions.
- A record. Each period’s snapshot is frozen and kept, so a reported figure can always be traced back.
- An owner. One named person answers when a source stops refreshing and keeps the list at its cap.
Where Tray Helix fits
Tray Helix is where an app built with an AI assistant gets deployed, run and governed. A business operations or finance lead builds the dashboard in Claude Code, Codex or Cursor. One command deploys it to a managed runtime and returns a URL.
Every deployed app sits behind sign-in, with your SSO on Helix Enterprise Edition, and access is granted per project. The app never holds a raw credential: it names the systems it reads from, and Tray resolves the authentication on the server side. The app gets a built-in database for snapshots and commentary, Helix logs every run, and every app has a named owner in the registry.
There are no per-user fees. You can start on the Tray AI Orchestration Platform for $50 a month with Tray Helix Builder Edition, plus usage. Helix does not choose your twelve metrics, though. That argument belongs to the leadership team.
When you should not build
- Your metrics are not agreed yet. Building the page first turns a definitions argument into a software argument. Agree the list and the definitions, then build.
- Your BI tool already does it well. If your current leadership view has owners, targets, a visible refresh state and period-end snapshots, there is nothing to add.
- The data is not reliable. A dashboard over unreliable data makes the unreliability more visible, which is useful only if someone will fix the sources.
- Nobody will own it. A leadership page that drifts out of date gets ignored, then quoted.
How to start
Start with the list, not the build. Get leadership to agree ten to fifteen metrics, a definition, a target and an owner for each. That conversation is most of the value, and the Helix guide to building a metric definitions catalogue gives the definitions a home.
The prompts to build the dashboard, and what it takes to run it, are in the Helix guide to building an executive KPI dashboard. Why CPQ is the best app to build yourself works through the same build-or-buy question for quoting.
Watch it built: How to build an executive KPI dashboard, from six prompts to a live app.