Documentation Index

Fetch the complete documentation index at: https://help.cirrusassessment.com/llms.txt

Use this file to discover all available pages before exploring further.

Data

Prev Next

Connect external reporting and analytics tools to a read-only copy of your Cirrus data. Use this article when you want to build custom dashboards, combine Cirrus data with other systems, or run analytics in Power BI, Excel, or another PostgreSQL-compatible tool.

What Data gives you

The Data component exposes your Cirrus data through a PostgreSQL-compatible analytical dataset. Any reporting tool that speaks PostgreSQL can query it.

Common use cases:

  • Build a custom dashboard tailored to your organisation.
  • Run reports that combine Cirrus data with data from another system.
  • Track usage trends across assessments, candidates, and time periods.
  • Audit historical activity at any depth supported by your reporting tool.

Access is read-only. The dataset is intended for analytical reporting, not real-time operational monitoring.

Supported reporting tools

Any tool that connects to a PostgreSQL database can use this component. The tools most commonly used by Cirrus customers are:

  • Microsoft Power BI
  • Microsoft Excel
  • Tableau, Looker, Metabase, and other PostgreSQL-compatible BI platforms

The exact set of features available to you depends on your reporting tool and how it handles PostgreSQL connections.

Access and configuration

Data is managed through Admin > Data in Cirrus.

Enabling Data on your tenant

Depending on your subscription tier, Data may need to be enabled by the Cirrus Service Desk before it appears in the Admin area. Raise a request through the Service Desk if you do not see it.

Administrators can view and manage:

  • Connection string for the PostgreSQL endpoint your tool connects to.
  • Database credentials the username and password your tool uses.
  • Allowed IPv4 CIDR block the network range from which connections are accepted. Restrict this to your organisation's outbound IP range.
  • Schema name the schema you query against inside the database.

Data refresh

The dataset is refreshed periodically through an automated pipeline. It is not a live mirror of the operational platform, so figures may lag by minutes to hours depending on the metric.

If you need real-time figures inside Cirrus rather than analytical reporting in an external tool, see Insights.

Related articles