Create a Dashboard

This guide walks you through creating a dashboard to compare the output data from a plate reader at two different timepoints, which has been ingested into Ganymede. This dashboard utilizes the same data processed in the Build a Flow guide. By the end of this tutorial, you will have transformed raw data to a dashboard that looks like this:

 

To do this we'll proceed through the following steps:

• Sign into Ganymede
• Set up virtual datasets
• Build charts from those virtual datasets
• Add those charts to a dashboard

Step 1: Sign into Ganymede

Using Google Chrome, sign into Ganymede. The

Sign In

button should be available once authentication is configured for your tenant, which is generally going to be a web address accessible via any web browser with the URL https://<your_tenant>.ganymede.bio.

You may need to enable pop-ups for Ganymede or disable any ad-blocking software for the ganymede.bio domain.

Step 2: Create virtual dataset for this visualization

In order to create our dashboard we will need to create two datasets:

• Quickstart_Absorbance_Change_Absolute_Differences dataset - a table containing absorbance measurements from two different plates
• Quickstart_Absorbance_Change_Run_Parameters dataset - a table containing temperature and timepoint metadata associated with each plate

Step 2a: Select the Dashboard page

Click the dashboard button

in the sidebar.

Step 2b: Load plate reader data for charting

Hover over SQL in the top menu bar and click on SQL Lab. This will open a SQL editor that lets you preview tables and run SQL queries:

 

Enter the following SQL query in the editor and click

RUN

to execute it.

-- Quickstart_Absorbance_Change_Run_Parameters table
SELECT field, run_diff, left(field, 1) as row, cast(right(field, length(field)-1) as int64) as column
FROM Quickstart_Absorbance_Change_data
UNPIVOT (value for run IN (run1, run2))
WHERE field not in ('Time [s]', 'Temp. [°C]', 'Cycle Nr.')
ORDER BY row, column

After running the query, the SQL editor should return the results:

Save the results as a virtual dataset by clicking on the

button next to the

SAVE

button. Save the dataset as Quickstart_Absorbance_Change_Absolute_Differences.

Step 2c: Load plate reader metadata for charting

Return to the SQL Editor and run the following query, then save the output as a virtual dataset named Quickstart_Absorbance_Change_Run_Parameters.

-- Quickstart_Absorbance_Change_Absolute_Differences table
SELECT field, value, trim(run, 'run') as run_number
FROM Quickstart_Absorbance_Change_Excel_Read_results 
UNPIVOT (value for run IN (run1, run2))
WHERE field in ('Time [s]', 'Temp. [°C]', 'Cycle Nr.')

Step 3: Create run parameters pivot table

Navigate to the Datasets tab in the top bar and search for "Quickstart" to find the virtual datasets you created.

 

Click on the Quickstart_Absorbance_Change_Run_Parameters table. This will bring you to the chart assembly page:

 

Click on the View All Charts within the Data tab in the middle section (highlighted in red above), and select the Pivot Table chart type.

 

Assemble the pivot table by dragging fields from the virtual table into the Query section. Name the chart "Run Parameters" as shown below.

 

Click

SAVE

to save the chart and add it to a new dashboard named "Absorbance Analytics."

 

Step 4: Create plate reader heat map

Navigate back to the Datasets tab in the top bar and select the "Quickstart_Absorbance_Change_Absolute_Differences" virtual dataset you created earlier.

 

Click on View All Charts and select "Heatmap" as the visualization type.

 

Assemble the heat map as shown below, and name the chart "Plate Absorbance Change."

 

Click

SAVE

to save the chart and add the chart to the "Absorbance Analytics" dashboard created in Step 3.

Step 5: Orienting the dashboard

Click on the Dashboards button in the top bar and select the Absorbance Analytics dashboard.

 

Arrange the dashboard by clicking on the

EDIT DASHBOARD

button in the top right hand corner of the screen. In the edit mode, tables and graphs can be resized and moved to different rows.

When you're satisfied with the arrangement, click SAVE. You've just built your first dashboard in Ganymede!

If you run into any challenges with the Quickstart, check out the tips and tricks section of the Dashboards page or contact Ganymede Support.