What is Analysis?
The Analysis tool provides a way for customers to generate customized data tables within Benchling. An Analysis allows users to view, work with, and analyze experimental result data, organized into Analysis Tables and Analysis Views.
Analysis tables and data are not associated with Benchling schemas, and do not continue to update with data from outside the Analysis after an Analysis is created. For example, if an Analysis Table is created from all the results of a particular registered entity, that table will not update if new results are recorded.
Launching Analysis
To begin using the Analysis tool, navigate to the Insights application within your Benchling environment. Analyses will appear in the left-hand navigation pane alongside Insights dashboards. To create a new Analysis, please see the instructions in the Creating an analysis article.
Analysis Glossary
Analysis
The top-level organization of the Analysis Tool is a collection of one or more Analysis Tables. An Analysis, and the data located within it, derives its permissions from the Project it is associated with. For detailed instructions on creating an Analysis, please refer to the Creating an analysis article.
Analysis Table
The top-level table of data within an Analysis is called an Analysis Table. An Analysis Table can only be modified from within an Analysis; it does not continue to update as data is created or updated within the rest of Benchling. Users can create copies of Analysis Tables called views, which can then be filtered and transformed. For more information, please refer to the Introduction to Analysis Tables article.
Analysis View
A copy of an Analysis Table that can be modified using filters, transformations, and charting
Data Analysis Features in the Analysis Tool
Charting:
Analysis Views can be created with the following View types:
- Table
- Bar Chart
- Line Chart
- Pie Chart
- Scatter Plot
- Heatmap
Filters
Filters can be applied to columns in Analysis Tables and Analysis Views. Parameters for the filters can be defined through Filter Conditions. For more information about filters, please see Using transformations and filters in Analysis.
Transformations
Transformations can be performed on Analysis Views. Transformation options include:
- Add computed column
- Add window function column(s)
- Aggregate table
- Bin data
- Convert column formats
- Find and replace text
- Hide columns
- Pivot table
- Rename columns
- Reorder columns
- Sort columns
- Unpivot table
Joins
Analysis Views and Analysis Tables can be combined via the following Joins. For more information, please refer to the Introduction to Analysis Tables article.
- Left Join
- Inner Join
- Right Join
- Full Join
- Append
Importing Analysis Data
Data can be imported into Analysis in several different ways. For detailed instructions on each method, please see the Introduction to Analysis Tables article.
- Analysis Tables can be created directly from Insights dashboards, pulling in query results to further explore data
- Tables can be created from Registry schemas and their associated Results data
- Registry and Results data can be added directly to an Analysis from a notebook entry’s Registration and Results tables by clicking the lightbulb Analysis icon
- Data external to Benchling can be imported directly into Analysis through CSV file uploads
Exporting Analysis Data
Export to CSV
Analysis Tables and Analysis Views can be exported to CSV format by clicking ‘...’ icon and selecting ‘Download as CSV’
Export to Results Table
Analysis Tables can be exported into Results by clicking the ‘...’ icon and selecting ‘Save table to Results’. Choose the appropriate Results schema, designate the table columns to the corresponding schema fields, and click ‘Save to Results’
Export via the Public API
Please see docs.benchling.com for Analysis API guidance and documentation.