Select a dataset to work with

As an Oracle Clinical One Platform user, your data is available in Oracle Clinical One Analytics through predefined datasets of local subject area type. Choose one or more datasets to visualize related data.

We provide different datasets so you can track changes by a specific topic. Select the ones relevant to your work and add them to your workbook to start visualizing and analyzing the data.

Once you selected a dataset to work with, make sure you have the appropriate access. For more information, see About your access to Oracle Clinical One Analytics.

Want to see how to perform this task? Watch the video below.

1. Review the purpose of each dataset and select the one that's most relevant to your work.

   Dataset	Description
   Blinded Kits dataset	Use it to analyze and visualize data and the audit history of specific kits in the study, from management and dispensation, without viewing details that could potentially unblind users.
   Blinded Subject Events Dataset	Use it to analyze and visualize data and audit history of events associated to individual subjects, without viewing details that could potentially unblind users.
   Dh Metrics dataset	Use it to analyze when data was last refreshed in Oracle Clinical One Analytics and to monitor data reliability.
   Kits and Randomization Design Dataset	Use it to analyze and visualize data regarding the metadata of kit definition, dispensation schedule and randomization definition for the study.
   Queries Dataset	Use it to analyze and visualize details and audit history of query data.
   Study Codelist dataset	Use it to analyze and visualize data regarding codelists at both study and global level, as well as current code configurations and changes made over time.
   Study Design Dataset	Use it to analyze and visualize data regarding the metadata of visits, forms and items included in study versions and applied across study modes.
   Subject Dataset	Use it to analyze and visualize subject level details and the audit history of a subject's data.
   Subject Event SVFL dataset	Use this dataset to analyze and visualize Sign, Verify, Freeze and Lock (SVFL) actions applied to an event or visit, as well as their audit history.
   Subject Forms Dataset	Use it to analyze and visualize data and audit history of forms associated to individual subjects.
   Subject Form SVFL dataset	Use this dataset to analyze and visualize Sign, Verify, Freeze and Lock (SVFL) actions applied to a form, as well as their audit history.
   Subject Form Items Dataset	Use it to analyze and visualize item-level data and the audit history of data entered for a question in a form for individual subjects.
   Subject Item SVFL dataset	Use this dataset to analyze and visualize Sign, Verify, Freeze and Lock (SVFL) actions applied to a question, as well as their audit history.
   Unblinded Kits Dataset	Use it to analyze and visualize data and the audit history of specific kits in the study, from management and dispensation. This dataset includes information that could potentially unblind a user.
   Unblinded Subject Events Dataset	Use it to analyze and visualize data and audit history of events associated to individual subjects. This dataset includes information that could potentially unblind a user.

   Tip:

   Browse Dataset descriptions if more details are needed.
2. Create a workbook in any of the two options available:
   • From the top menu bar.
   • Starting from a dataset.
3. Add a dataset to your workbook:

   Tip:

   Even if you already added a dataset as part of the previous step, you can add as many datasets as you need and you can do it at any time while working on your workbook.

   Option	Steps
   From the Data Panel at the right of the screen	Make sure the Data tab () is selected in the Data Panel. Click on the plus icon () next to the search bar. Select Add Dataset.... In the Add Dataset dialog, navigate to the Subject Areas tab. Select a dataset to add and click Add to Workbook.
   From the Prepare pane:	Click Prepare in the top menu bar. Click the plus icon (+) to add a dataset. In the Add Dataset dialog, navigate to the Subject Areas tab. Select a dataset to add and click Add to Workbook.

With an open workbook, you are ready to visualize and analyze your data:

• Create and edit a data visualization
• Add multiple visualizations in a canvas.
• Create and apply filters.
• Organize visualizations in dashboards.
• Create stories.
• Export and share your work.