This article describes the Oracle Health Sciences Analyze Account Metrics workbook for Select. We've included the following sections:
- Workbook synopsis
- Dashboards and sheets
This Account Metrics report workbook, which is intended for Oracle Health Sciences Select customers, includes dashboard views of studies, sites, and users as well as detailed cross-tab sheets of each.
Dashboards and sheets
Account Metrics - Studies
This studies dashboard allows users to view trends in studies that have been added to Select over time. The top portion of the dashboard includes trending and running total line graphs indicating the number of studies added per month. At the bottom of the dashboard, a horizontal bar chart shows the number of studies added per user-selected dimension (country, sponsor, or phase).
Account Metrics - Study Detail
The study detail worksheet allows users to filter details by study status, study creation date, protocol name, sponsor, study phase, and/or compound. Report users also have the ability to drill directly to site data from the hyperlinked value listed in the "Total Sites Nominated" column.
Account Metrics - Sites
The sites dashboard allows users to view trends in sites that have completed feasibility, finalized CDAs, and achieved final acceptance in Select over time. Top level KPIs show total number of study sites that have completed feasibility, total number of study sites that have finalized CDAs, and total number of study sites that have reached final acceptance bucket state. A running total line graph indicates total over time and a month-by-month line graph indicates distinct number per month.
At the bottom of the dashboard, a trend vertical bar graph shows the trend in sites added per month based on the parameter a user has selected (feasibility, finalized CDA, or final acceptance). Users can display data by running total or count by month.
Account Metrics - Site Detail
The sites detail worksheet allows users to filter details by study, country, and bucket state (e.g., do not invite, invited, short list, etc.).
Account Metrics - Users
The users dashboard allows report users to view top level KPIs for total users added, users added this month, and users added last month. The lower section of the dashboard is a trend bar chart of users added per month. Report users can toggle this view between running total and count by month.
Account Metrics - User Detail
The users detail worksheet allows report users to filter details by date range for user account creation and last login. Report users can also specify if they want to include users who have never logged in.
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.