Dear Analyst

— Hosted by Al Chen

About the show

Discussing workplace tools, spreadsheets, data analysis, and everything in between.
1. See all previous podcast episodes on the KeyCuts blog
2. Listen to episodes on Apple podcasts
3. Subscribe to the Dear Analyst LinkedIn Newsletter below:

Meet your host

Al Chen

Solutions Architect @ Coda | Data analytics podcaster/blogger

Latest broadcast

Dear Analyst

Dear Analyst #66: How to update and add new data to a PivotTable with ramen ratings data

Popular clips

232

Excel keyboard shortcuts are fun to learn! Dear Analyst

00:42

134

Blending of eng and data skills required at Canva Dear Analyst

00:34

100

Using "ski passes" to define a new business metric Dear Analyst

01:03

93

Using Excel as a development platform instead of for data… Dear Analyst

00:58

84

Work-bench flips the VC model on its head by talking to… Dear Analyst

00:22

64

Sharing Excel tips on an internal General Electric… Dear Analyst

00:59

62

OpenRefine is the best free alternative to Microsoft Power… Dear Analyst

00:29

43

Finding passion in analytics from a waste water treatment… Dear Analyst

00:44

33

Eliminating inequities and biases in data in the sports… Dear Analyst

01:14

Past broadcasts

Sat, Mar 27, 03:18 PM EDT Episode #65: Building data systems and transitioning from marketing to data with Caiti Donovan, VP of Data & Insights at Sports Innovation Lab

Caiti Donovan is the VP of Data & Insights at Sports Innovation Lab, a sports market research…

Sun, Mar 21, 03:51 PM EDT Episode #64: Architecting revenue data pipelines, iterating with business stakeholders, and switching to a career in analytics with Lauren Adabie, data analyst at Netlify

A data pipeline can be riddle with issues and can become slow over time as more data is transformed from various sources. Lauren Adabie, a data analyst at…

Stay updated

Subscribe to get notified when Dear Analyst goes live.