Tools/ Advanced analytics
Advanced analytics

Connect BI straight to Postgres

A direct Postgres connection for your analytics team. Power BI or plain SQL — the numbers in the boardroom are the numbers in the platform, without an export in between.

The problem

Two numbers, one boardroom

The report that reaches senior leadership is usually a copy of a copy, and it disagrees with the platform by the time it is presented.

Exports become the source

A spreadsheet gets pulled once and quietly becomes what the organisation believes.

Analysts are locked out

Your BI team has the skills and the tools, but not a connection to the risk data.

Refresh means asking somebody

Every update to the board pack starts with a request to the risk team.

How it works

Give the analysts the real tables

A direct Postgres connection, so Power BI or plain SQL reads the live data instead of a snapshot of it.

  1. 01

    Connect to Postgres

    Any tool that speaks SQL — Power BI, a notebook, or a psql session.

  2. 02

    Query the live tables

    Compliance, findings and insurance values as they stand right now.

  3. 03

    Let the board pack refresh itself

    The numbers in the report and the numbers in the platform stop diverging.

tools / advanced-analytics DIRECT POSTGRES
=> SELECT site, compliance_pct, open_findings
   FROM analytics.board_status ORDER BY compliance_pct;
 taipei-dc     | 64 | 9
 lyon-plant    | 78 | 5
 aalborg-plant | 94 | 1
24 rows — the same live tables Power BI connects to
Features

What you get with advanced analytics

POWER BI

Boardroom numbers, live

Compliance, findings and insurance values flow into the reports your organisation already runs on — refreshed from the source.

SECURITY

Scoped at the database

Analytics access is enforced with row-level security in Postgres itself — the connection only ever sees its own organization.

SQL

Any tool that speaks SQL

Power BI, notebooks or a plain psql session — if it connects to Postgres, it connects to your risk data.

FAQ

Frequently asked questions

Which tools can connect?

Anything that speaks SQL. Power BI is the common one, but a notebook or a plain psql session works the same way.

How is the data kept separate?

Analytics access is enforced with row-level security in Postgres itself, so a connection only ever sees its own organization's data.

Give your analysts the real tables

Talk to us about a direct analytics connection for your team.