Dashboards

Introduction

The Competitive Intelligence dashboards of the Clinical Research Navigator Clinical Trials module are intended to feed critical decision-making processes on therapeutic areas of interest where 100% accuracy and recall of information is required to make well-informed decisions. Dashboards are created by the Competitive Intelligence experts.

A dashboard represents knowledge-driven curated clinical trials data-subset of interest derived from large and heterogeneous clinical trials datasets for focused contextual and visual data exploration. Its interactive, intuitive, and visual analytics interface assists users in viewing summarized, simplified and commented data subset of interest. In addition, the interface allows users to switch from dashboard view to all clinical trials views.

Accessing a Dashboard 

Dashboard Information

• Executive Summary: The ‘Executive Summary’ tab provides the high-level contextual overview defining, describing, analyzing, answering information relevant to the dashboard. The documents as an attachment, if any under this tab can be downloaded for further reading. The inserted web page links re-direct users to the webpage. The executive summary is created by the Competitive Intelligence experts.

• Launch Date (US/EU): The ‘Launch Date’ chart provides the visual graphical overview about the set of drugs that are expected to be launched in the next five years or later. The drugs are listed against their mechanisms of action in the chronological order of their estimated launch year. Information on drug’s class of molecule (biologic/ small molecule/ vaccine etc.), development status of the drugs (launched, filed, failed, etc.) and any comments relevant to that specific drug are also presented in the chart via icons.

• Pipeline: The ‘Pipeline’ chart provides the visual graphical overview about the ongoing drugs innovations that are on the horizon for the dashboard. The drugs in the pipeline chart are listed against their mechanisms of action in the chronological order of discovery phases (preclinical, Phase 1) to the development phases (Phase 2, Phase 3) to the filed/launched development status. Information on drug’s class of molecule (antibody, cell therapy, gene therapy, nucleotide-biological oligonucleotide, other, protein-biological peptide, synthetic molecule, vaccine etc.), development status of the drugs (launched, filed, failed etc.) and any comments relevant to that specific drug are also presented in the chart via icons.

• Timeline: ‘Timeline’ chart is another visual graphical overview about the drugs on the horizons. The drugs along with their mechanisms of action are listed as per their Ranking level and Intervention threat level as assigned by Competitive Intelligence experts. The bar represents the clinical trials for the drugs aggregated in chronological order based on their start and completion date of the clinical trials.

• Sponsor: The ‘Sponsors tab’ lists the names of the sponsors (leads and collaborators) relevant to the dashboard. Any comment specified for the specific sponsor by Competitive Intelligence experts can also be read by clicking on the comment icon.

•  Conditions: The ‘Conditions’ tab lists the names of the conditions relevant to the dashboard. Any comment specified for the specific condition by Competitive Intelligence experts can also be read by clicking on the comment icon. 

Summary View

The facet/chart panel view is a summary view of the search results and contains a selection of interactive charts and facet panels.

• Interventions: The 'Interventions' panel lists all the drug names based on the trial records of dashboards. Corresponding to each intervention, a count of trials retrieved is displayed. Next to the trial count is provided a link to the intervention profile page. 

• Sponsors: The 'Sponsors' panel lists all the sponsors and collaborators along with relevant trial counts. The count under the ‘Lead’ column indicates the number of trials where the sponsor is a lead entity. The count under ‘Collaborator’ column indicates the number of trials where the organization/person is functioning as the collaborator. The Total column provides the sum of trials where the sponsor is the lead and/or the collaborator. Next to the sum of trials count is provided a link to the organization profile page.

• MOA: The ‘Mechanism of Action’ panel list the mechanisms of action based on the interventions listed in the intervention panel. Corresponding to each mechanism of action is provided count of trials that list the intervention/s having that specific mechanism of action.

• Country: The 'Country' panel displays a world map based on the number of trials conducted at various sites in each country. A clinical study may be conducted at multiple sites in one country and/or may be conducted in multiple countries. The ‘Details view’ link provides a tabular view of the clinical trial location information and ‘Map View’ link toggles it back to the map.

• Phase Chart:  This panel presents different phases of trials (in addition to trials where phase is not specified) in a bar chart format based on the trial records of dashboards. In the 'Phase Chart', the trials are grouped based on the start date of the trial and distributed over the past 10 years. Trials listed in more than one phase will be counted in both appropriate phases (e.g. a trial in Phase 1/2 will be counted twice, as a trial in Phase 1 and a trial in Phase 2).

All the above described panels have interactive filtering capability to further explore and refine the dashboard dataset by inclusion & /exclusion* of meta data from these panels. Clicking Left mouse button on one of the data value in a facet panel highlights the value in Green and returns a subset of the results containing selected data value. Clicking Right mouse button on one of the data value in a facet panel highlights the value in Red and returns a subset of the results excluding the selected data value. Multiple rows can also be selected/ de-selected by holding down the CTRL key while clicking on the data values within the facet. Boolean logic can be added to the interactive filtering capability by selecting AND or OR from the top right of the respective panel view. Selected data values for inclusion &/exclusion appears as breadcrumbs and can be individually removed from the breadcrumb panel. Multiple selections within a facet panel can be removed by clicking the filter icon which appears on the panel.

*The capability of excluding meta-data is currently available for the facet panels (Interventions, Sponsors and MOAs) only.

Table View

The table view is a detailed view of the dashboard trials data in a tabular format.

• Trials: It is possible to select, remove and reorder the columns by selecting the ‘Columns’ menu within the table view. In addition to the default display of 21 columns there are additional 51 columns available with the column relevant trial information from the column menu. Once the selection of the columns is done, click ‘Accept’ to refresh the view.  Columns can be sorted by clicking on the column titles in an ascending or descending order. Many multinational, multicenter trials are registered in more than one registry. Multiple trial records can be grouped and un-grouped using the collapse (-) and expand (+) trials option provided at the top right corner of the trials panel. The trials panel allows users to further refine the data-subset by exclusion of the selected trials from the panel. Select the trial/s to be excluded from the trial panel. The selected value/s gets highlighted in Orange. Then click on the filter icon provided at the right corner of the trial panel. This will exclude the trial from the search result. A second filter icon will appear on the trials panel in order to clear the excluded trials.

Refining Results in the Dashboard

 All fields or entity-specific searches within the dashboard will query only the subset of data comprising the dashboard.

• All Fields: The 'All Fields' search queries all sections of clinical trial records except for inclusion and exclusion criteria (eligibility criteria). The entity specific vocabularies are also searched for the extraction (from the title of the trial and entity specific field), normalization and synonym expansion.

• Condition: This entity-specific search field queries the 'Condition' and 'Title' fields of the trial record. The MeSH thesaurus (from the National Library of Medicine) is being used for normalization, synonym expansion and hierarchical structure of condition names. The application uses only the following MeSH descriptors: Diseases [C], Mental Disorders [F03] and Supplemental Concept Records [T047: Disease & Syndrome].

• Intervention: This entity-specific search field queries the 'Intervention' field and 'Title' field of the trial record. The CRN intervention vocabulary and ChemIDPlus vocabulary (from the National Library of Medicine) are being used for normalization and synonym expansion of drugs names.

• Sponsor: This entity-specific search field queries the 'Sponsor' and 'Collaborator' fields of the trial record. The CRN organization vocabulary is being used for normalization and synonym expansion of the sponsor and collaborator names.

• Mechanism of Action (MOA): This entity specific search field queries the drugs and their mechanisms of action relationship. 

• Include Synonyms: A synonym term could be a word/phrase that means similar to its preferred term. When 'Include synonyms' (the default) is selected the synonym expansion behavior from thesaurus gets activated. The system will process the search term against all its synonyms and display the preferred term in the application.  

Examples: Intervention DA-3901 is the Synonym of Exenatide. Search for ‘DA-3091’ retrieves 388 clinical trials as it was searched against all its synonyms, displaying the preferred term ‘Exenatide’.

The same logic applies when a sponsor is searched. The ‘Preferred Term’ is the parent company, and its synonyms its affiliates.

De-selection of the 'Include Synonyms' option will query only the search term and display its preferred term in the application. Thus when ‘include synonym’ is de-selected to search for intervention ‘DA-3091’ extracted only one trial where ‘DA-3091’ was mentioned as an intervention.

Entity specific searches for Condition, Intervention, Sponsor and Mechanism of Action fields include auto-suggest option via a drop-down list to assist users in making term selection.

Export to Excel

Results of a search can be exported to an Excel spreadsheet for offline analysis.

• The first worksheet in the export contains the search criteria that were used to generate the result set as well as the date and time the search was performed.

• The second worksheet displays the clinical trials with all available fields for each trial that is exported. The user can select/remove the columns (except Trial ID) using the Columns menu in the table view from the website in order to customize the Excel export.  Preview of the selected columns can be done under the trial tab as the Columns settings are applicable to both the table view and the exported spreadsheet. Columns that are not selected for display can still be viewed in the spreadsheet by performing an unhide function at the one before the last column.

• The third worksheet summarizes the number of trials by conditions, interventions, sponsors and country locations.

Appendix: List of ICONS