OpenClinica Insight

OpenClinica Insight makes it easy to ask questions of your clinical and operational data and visualize answers via interactive reports and dashboards. Here's a brief introduction:

OpenClinica Insight - What could you do with intelligent reporting from OpenClinica, LLC on Vimeo.


Insight is designed to be intuitive and self-documenting. Here are a few pointers to get you started...

Do I have Insight?

OpenClinica Insight is available for OpenClinica 3 Enterprise and OpenClinica 4. It is an add-on module, so you may have it if your organization has purchased it. It lives at a separate URL and requires a separate login from your main OpenClinica environment. Contact your OpenClinica administrator to get access to your Insight domain or click here.

How do I get started?

Insight includes some out-of-the-box reports and visual tools for creating reports and dashboards that allow you to explore your data without a lot of hassle. Here are a few key concepts to help you out:

Reports in Insight are called Questions. A Question can be built using the question builder, or written in SQL. The point and click question builder provides tools for filtering, aggregation, grouping, and more. If you need to do complex things such as joins across multiple tables, use SQL. Either way, you can hit 'Refresh' to see the results as you build. You can also decide if you'd like to see the results as a table, chart, map, etc. When done, save the Question so others can use it and you can come back to it later.

Dashboards are pages that display the results of several questions at once. Dashboards can be set up with filters so you can look at different slices of your data easily. You can drill down into a graph or table for more details on the results. 

Pulses and Alerts will send you and colleagues the results of a Question, on a schedule or when triggered by a change in the data.

Last but not least, the Data Reference makes it easy to explore your data by providing descriptions of tables and columns. Some of these descriptions are part of Insight itself, while others are generated from your study metadata. These descriptions can be customized and added to as needed by your Insight administrator.

The user interface runs on software called Metabase. Access the Metabase user guide for details on how to create questions, set up alerts, and more.

Where do my data come from?

The foundation of OpenClinica Insight is a data warehouse that is generated from your OpenClinica transactional database. Built with PostgreSQL and Python, it provides:

  • Each OpenClinica study as a schema
  • Each CRF/Item Group as a table, with items as columns
  • All non-removed data, plus audit logs for all data
  • Transactional data re-modelled for optimal reporting via a constellation data model
  • Snapshot updates of data (refresh rate is hourly and can be tuned higher / lower if desired)

What else can Insight help me do?

You can share and embed your questions and dashboards, or integrate Insight with your existing backend toolchains and reporting platforms. Sharing and embedding options are accessible through the user interface. Contact us if you'd like to access the data warehouse backend directly or use the Metabase API.

Take a deeper dive into Insight by reviewing the slides - see how you can track enrollment, monitor adverse events, and identify missing forms. The slides also describe Insight's data model, architecture, and advanced features of the question builder. A one-hour long webinar recording is also available.


Approved for publication by Cal Collins (ccollins), Chief Executive Officer. Signed on 2019-02-11 11:11AM

Not valid unless obtained from the OpenClinica document management system on the day of use.