Help Center
Go back to application
Help Center
Go back to application
Getting Started
Navigating Talosix PlatformContacting our Customer Service
Study Management
HomeAI Patient IDCommentsQuery ManagementAdverse EventsProtocol DeviationConcomitant MedicationData Export
Data Management
Patient Management
Delegation of Authority
Analytics
Analytics Navigation Guide
Hands-On Analytics Guide
Create a ChartUse Chart BuilderCreate a DashboardEdit Dashboard PropertiesCreate DatasetsSQL LabShare Dashboard to Your Partners (Sponsors)
Account Settings
Access User SettingsChange Your Password Change Phone Number
Account Security
Admin Tools
Create New StudyManage SiteAssign Forms to Cohorts/TreatmentsManage FormsMigrate Study Settings and FormsManage Physician SurveyView and Manage Users
Study Settings
Data Import
eCRF Wizard

Create Datasets

Datasets are carefully organized collections of data from your database. They provide a standardized way to define metrics, allowing charts and visualizations to present information consistently. Datasets are essential because every chart is created from a dataset.

Getting Started

What is a dataset? 

A dataset is a structured collection of related data that serves as the foundation for creating visualizations, dashboards, and reports. They provide the raw material that you can transform, filter, and visualize to gain valuable insights into your data. Within a dataset, you'll find rows and columns of data, with each row representing a unique entry or observation, and each column representing a different attribute or characteristic of that entry. For instance, in a dataset containing information about patients, columns could include "Name," "Age," "Gender," and so forth. Once a dataset is created, it can be reused across multiple visualizations, dashboards, and reports, promoting consistency and reducing redundant effort.

Dataset Types

In Talosix Analysis Suite, there are two types of datasets, depending on the data sources: 

  • Physical datasets: Physical datasets represent tables stored within your study database. We've done the heavy lifting by creating a physical dataset for every table in your Analysis Suite. So, relax – no need to worry about connections to the database. Just pick one from the list and dive into creating your chart!
  • Virtual datasets:Virtual datasets are dynamically generated through SQL queries executed in SQL Lab against a database. In essence, a virtual dataset serves as a logical representation of data, integrating and combining information from various tables within your databases. It acts as an abstraction layer, providing a unified view of data without replicating or moving the data from its original sources.

Create a dataset

Physical Datasets

We've done the heavy lifting by creating a physical dataset for every table in your Analysis Suite. So, relax – no need to worry about connections to the database. Just pick one from the list and dive into creating your chart!

Virtual Datasets

Virtual datasets provide a convenient way to combine and analyze data from multiple sources in one place. With virtual datasets, you don't need to manually gather and merge data from different tables or databases. Instead, you can set up a virtual dataset to automatically pull in the relevant information you need from various sources.

One of the key benefits of virtual datasets is their ability to query live data sources. This means you can get up-to-date information and perform real-time or near-real-time analysis without having to wait for data refreshes. This flexibility is particularly useful when you need to explore data quickly or generate ad hoc reports on the fly.

Set up a virtual dataset

Setting up a virtual dataset is straightforward. Below are step-by-step instructions to help you navigate through the process:

  1. Navigate to SQL Lab:
    • Go to Analysis and select SQL Lab.
    • Alternatively, if you're on the Datasets page, click the "+ Dataset" button, then choose "Create dataset from SQL query." This will also take you to the SQL Lab page.
  2. Run Your SQL Query:
  3. Save Your Dataset: Once the results are displayed, and you're satisfied with it, click the arrow on "Save" button. From the dropdown menu, select "Save dataset" to create your virtual dataset from the query.
    • If you want to create a new dataset, select "Save as new" and enter a name for your dataset.
    • If you wish to overwrite an existing dataset, select "Overwrite existing" and carefully choose the dataset name from the dropdown. Please double-check your selection, as this action cannot be undone.

      Finally, click the button to save the dataset.
  4. Explore Your Data: The Chart screen will automatically open, allowing you to start exploring your data from the newly created dataset.

 

Edit a virtual dataset

To edit a virtual dataset:

  1. Navigate to the Datasets Page: Go to the Datasets page.
  2. Locate the Dataset to Edit: On the listing table, find the dataset you want to edit. Hover over the dataset's row. Click the edit button (the pencil icon) in the actions column.
  3. Edit Your SQL Query: Make the desired changes to your SQL query in the SQL textarea.
  4. Save Your Changes: Click the "Save" button to apply your edits.

Note: Please be aware that the changes you make will affect all charts using the dataset, including charts owned by other people.

 

 

 

Powered by Product Fruits