Session 3 — Data science workflows in JavaScript

Workshop Session 3:

- Access and explore data in a database
- Query, tidy, and transform data in SQL
- Perform and visualize results of PCA in JavaScript
- Collaborate with a teammate in your notebook

Instructor: Allison Horst (Data Scientist Advocate at Observable)

In this hands-on course, we will walk through three real-world case studies from data import to communication, each highlighting a different set of tools available to use in a data science workflow. By the end of the workshop, you'll be ready to mix-and-match tools to best suit your skill set and the specific needs of your data work - whether working solo or with your team.

00:00 - Welcome and introduction
05:21 - Meet the data
09:18 - Combine data into a database
15:40 - Data wrangling in SQL cells
32:52 - Break
37:55 - Exploratory data visualization
1:28:35 - Break
1:32:55 - Make a PCA biplot in Observable Plot
1:49:01 - Multiplayer editing in Observable Notebooks
1:52:07 - Course wrap-up