elluminate Analytics provides interactive visualizations of study data, enabling authorized users to conduct robust in-study and cross-trial reporting and analysis.

The following Analytics apps are available: 

• Clinical Data Analytics (CDA): Enables cross-domain and cross-study data exploration. CDA facilitates trend and outlier identification, offering traditional line listings, descriptive statistics, and visual patient profiles. Data is sourced from the Reporting data mart and always reflects the latest data integrated into elluminate. URL-level grouping is available by compound, therapeutic area, or program.

  Note: Oncology studies include additional oncology-specific sheets.

• Clinical Trials Operational Analytics (CTOA): Provides an overview of operational data, including enrollment, query and audit metrics, adverse event rates, and protocol deviations. URL-level grouping is available by compound, therapeutic area, or program.
• Operational Oversight (OO): Offers a dashboard view of operational data designed for broad operational data consumption. Pre-defined visualizations, based on Operational Data Repository tables, can be used directly or as templates for customized sheets.
• Sample Management Analytics (SMA): Automates and streamlines trial sample tracking. Standard sheets provide automated data reconciliation, sample journey visualizations, and statistical and overview reports for real-time sample tracking.
• Clinical Data Analytics Study Snapshot: Contains the same sheets as the CDA app, but is limited to study snapshots, a point-in-time capture of all study data.
  Note: Study snapshots do not include current data.
• Custom Analytics: Hosts custom apps created using custom data models. No standard sheets are provided; all sheets must be created within each custom app. 

If CDA and CTOA applications are configured for URL-level grouping, the application name reflects the grouped applications. 

Key Features

• URL-Level Grouping: CDA and CTOA apps can be grouped by compound, therapeutic area, or program at the URL level.
• Data Source: Most visualizations use data from the Reporting data mart.
• Standard Visualizations: A library of standard sheets is available in CDA, CTOA, OO, and SMA apps.
• Customization: Create customized sheets by duplicating an out-of-the-box sheet or creating sheets from scratch.
• Filtering: Use filters (or selections) to limit results to areas of interest. Selections persist across sheets, allowing filtering across domains and visualizations.
• Bookmarks: Save frequently used selections as bookmarks for easy access.
• Issue Tracking: Create and manage issues directly from Analytics sheets.
• Review Registration: Register a review of a sheet.

Note: Be sure the browser is one supported by elluminate Analytics. See details on supported browsers under FAQs.

Tip: Maximize spreadsheet workflow! Open two sheets in separate browser tabs; the filter settings remain consistent between them, allowing for quick comparisons using the same criteria across different data sets. However, to apply different filters to each sheet independently, open each sheet in a different browser (e.g., Chrome and Edge).

Access Analytics

From the elluminate Platform Menu, select Analytics under Data Review.

The Analytics landing page opens.

Analytics Landing Page

The Analytics landing page displays available apps.

CDA and CTOA apps can be grouped by compound, therapeutic area, or program; the app name reflects this grouping at the URL level.

Note: Studies must have complete compound, therapeutic area, and program fields in their configuration to be included in a group.

To view all apps, scroll down.

Each app card displays the app name, version, deployment date and time, the last data model reload time, and icons that provide access to:

• The Home Page sheet
• The Overview page
• An app description (hover over the 'i' icon)
• The Favorites feature (add the app to favorites; view only favorite apps by clicking the Favorites icon in the master header). 

Clicking the app card or the Home icon opens the Home Page sheet; clicking the Overview icon opens the Overview page:

• Home Page: Displays summary information for all the studies in the app, or for selected studies. The default view shows data for all included studies.

  Note: Key Performance Indicators are consistent across all CDA apps.

• Overview page: Displays available sheets, bookmarks, and stories. Click a sheet to open it. Users can also create new sheets from this page.

Navigate Analytics Sheets

The following example shows the CDA Home Page. All Analytics apps share the same functionality.

Top Toolbar

Functionality, from left to right:

• Analytics app drop-down:
  
  • Home > Overview: Provides an overview and access to Sheets, Bookmarks, and Stories.
  • Analyze > Sheet: Displays the sheet view. This is the default view.
  • Narrate > Storytelling: Provides access to Stories.
• Name of app: Opens app details.
• More (ellipsis) icon: Opens a drop-down menu. The available options depend on the current view. In the Sheet view, options include showing details, downloading the sheet as a PDF, duplicating or embedding the sheet, enabling touch screen mode, and accessing Qlik Help.
• Ask Insight Advisor: Allows users to ask questions about the data.

Second Toolbar

Functionality, from left to right:

• Assets: Opens a panel for browsing Sheets and Bookmarks, with grid view, list view, and a built-in search bar.
  • Sheets: Provides access to sheets.
  • Bookmarks: Provides access to bookmarks.
• Insight Advisor: Opens Insight Advisor.
• Selection Icons:
  
  • Smart Search: Searches the data.
  • Step Back: Reverts to the previous selection.
  • Step Forward: Redoes a previously undone selection.
  • Clear All Selections: Removes all selections.
  • Selections Bar: Displays all applied selections and filters.
• Selections Tool: Opens the Selections Tool. The Selections Tool provides an overview of all dimensions and fields in an app and a detailed view of selected data, enabling users to explore associations within unused dimensions.
• Duplicate: Duplicates the current sheet. Requires the Analytics Edit privilege.

Browse Sheets from the Assets Panel

The Assets panel provides access to Sheets and Bookmarks while remaining on the current sheet.

1. Click Assets on the second toolbar.
2. Select the Sheets tab.

The Sheets tab displays available sheets. Use the toolbar to:

• Search for a sheet.
• Switch between Grid view and List view.
• Pin or unpin the panel.
• Expand the panel.

Sheets are organized into sections, such as My own, Public, and Community. Scroll to view additional sheets.

Click the More icon or right-click a sheet to open a context menu. Available options vary depending on the sheet status.

Sheet Header with Toolbar

Functionality, from left to right:

• Name: Displays the sheet name.
• Toolbar options:
  • Left / Right arrows: Navigate to the previous or next sheet.
  • Create Issue: Opens the Create Issue window.
  • Issues: Opens the global Issues listing.
  • Register Review: Opens the Register Review window.
  • Reviews: Opens the Analytic Sheet Review Log Report in a new tab.
  • Copy Link: Copies the current sheet link, including applied filters, to the clipboard.

  • Share: Opens the default email client with the current sheet link, including applied filters. A confirmation prompt may appear. If prompted, click OK. If the email client does not open automatically, pop-up blockers may need to be disabled for this site.

    Note: Only users with the appropriate privileges can access shared sheet links.

  • Help Center: Opens the elluminate Help Center.

Sheet Filters

Filters are ordered from left to right, progressing from general to specific.

Click a filter to make selections. Selections persist across sheets and display in the Selections Bar.

Hover / Right-Click Options

Hover over a visualization to display the Full Screen and More icons, or right-click the visualization to access additional options. The available options vary depending on the visualization type.

Common options include:

• Full Screen: Expands the visualization to full screen.
• Exploration menu: Opens the visual to explore the data.
• View data: Opens the underlying table.
• Share: Provides an option to embed the visualization.
• Storytelling snapshots: Provides options to take a snapshot or open the snapshot library.
• Download as: Provides options to download the visualization as an image, PDF, or Excel file.

Note: On touch-enabled devices, visualization options may display differently when Touch screen mode is enabled.

Access the Graphical Patient Profile in Data Central

For Data Central-configured studies, click the Unique Subject Identifier in a data listing to open the Graphical Patient Profile in Data Central.

Return to the Home Page in Sample Management Analytics

Click the Home button on any SMA sheet to return to the Home page.

Navigate the Overview Page

The Overview page provides access to Sheets, Bookmarks, and Stories. The Sheets tab opens by default.

Access the Overview Page

To open the Overview page:

1. Click the Analytics app drop-down.
2. Select Home > Overview.

Sheets Tab

The Sheets tab displays available analytic sheets organized into sections such as Public, Community, Published by me, and My own. Scroll to view additional sheets.

Sheets display in Grid view by default.

Use the toolbar to:

• Search for a sheet.
• Create a new sheet.
• Switch between Grid view and List view.

Click the More icon or right-click a sheet to open a context menu. Available options vary depending on the sheet status.

Bookmarks Tab

The Bookmarks tab displays saved bookmarks. Use the available options to search for and manage bookmarks.

Click the More icon or right-click a bookmark to open a context menu. Available options vary depending on the bookmark status.

Stories Tab

The Stories tab displays available stories. Use the available options to search for, create, and manage stories.

Click the More icon or right-click a story to open a context menu. Available options vary depending on the story status.

Analytic Sheet Visibility

CDA, CTOA, SMA, and OO support two sheet visibility options that help organizations customize Analytics.

• Hide Out-of-the-Box Sheets: Hide specific or all standard sheets so only selected standard sheets, custom sheets, or community-created sheets display.
• Restrict Sheet Access by User Group: Control sheet visibility through elluminate user groups so users see only the sheets assigned to their role. Users who are not assigned to a restricted group continue to see all sheets by default. The Home Page and Application Information sheets remain visible to all users.

Support-Managed Configuration: Both sheet visibility options require configuration by eClinical Solutions Support. Contact Support to request these changes.