Governed
Every KPI runs on approved SQL. Analysts control what executes, how it is calculated, and who can see it.
Business KPIs
Analysts define the metrics once using approved SQL. Business leaders see live KPI cards, ask follow-up questions in plain language, and get trusted answers. No SQL access required, no raw database exposure, no analyst requests.
Designed for CEOs, COOs, PMs, finance, and operations teams who need trusted data without database access.
How it works
The SQL stays with engineering. The answers reach everyone.
An analyst writes the SQL query in the workspace, adds business context and thresholds, and publishes it to the KPI catalog. The logic is versioned and approved before anyone sees it.
The CEO or COO opens DataPilot and sees the KPI Overview: current values, trend direction, and any active alerts. Fresh data, no spreadsheet, no SQL.
The leader asks a follow-up question in plain language. DataPilot answers using the approved KPI catalog as its source. No analyst request, no wait, no guessing.
Why different from a dashboard
Business KPIs in DataPilot are not static charts. They are live, queryable, and grounded in logic your team approved.
Every KPI runs on approved SQL. Analysts control what executes, how it is calculated, and who can see it.
Business users can ask follow-up questions in plain language and get answers tied to the same approved catalog logic.
KPI cards refresh on a schedule you define. No stale exports, no manually updated spreadsheets.
Every data access has a log entry. Your team always knows what ran, when, and what was returned.
Who uses Business KPIs
Analysts and engineers
Use the Query Workspace to write and test SQL, add business context, set thresholds, and publish KPIs to the catalog. You decide what is available, what logic runs, and where execution happens.
See the query workspaceExecutives and business teams
Open DataPilot to your KPI overview every morning. Ask follow-up questions in plain language. Get trusted answers without touching SQL or waiting for an analyst to respond.
See the executive experienceStart free or talk to us about your rollout needs.