Benchling Insights is a new solution for life science R&D companies to make faster, more informed decisions from their data. Insights is seamlessly integrated with all Benchling applications, and enables users to query, visualize, and collaborate around high quality, structured data that resides on the platform.

Benchling Insights includes:

  • Collaborative dashboards and reports to share key scientific, operational, and administrative metrics
  • Visualizations through a variety of formats including table, bar, line, and scatter charts
  • Built-in SQL query editor for advanced analytics that address questions unique to your scientific workflows

Benchling Insights Video Series:

Introduction to SQL

This video introduces basic SQL concepts. You will learn SELECT clause, FROM clause, AS clause and column calculation. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/yyzw3lI1vwQ

Writing queries using WHERE and JOIN

This video introduces WHERE and JOIN clauses of SQL. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/vpkgKq45VoE

CTEs, ORDER BY, LIMIT, and OFFSET

This video introduces the concept of the CTE, as well as the ORDER BY, LIMIT, and OFFSET clauses. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/UfSZPcAe2zA

Using Aggregate Functions

This video introduces aggregate functions and GROUP BY clause of SQL. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/B_eJMePlNZQ

Partitions and JSON Manipulation

This video introduces the PARTITION BY clause to which the window function is applied and JSON processing functions. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/xR7MG_gicxE

Window Functions

This video introduces window functions, which allow for a calculation across a set of table rows that are somehow related to the current row. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

https://youtu.be/2MVradQgMOM

See more at https://www.benchling.com/insights/

Did this answer your question?