0-google-sheets

Dear Analyst #95: Nobody ever got fired for choosing Google Sheets

The motivation for this post/episode is a selfish one (scroll to the very bottom or skip to the end of the podcast to see why). As I thought about the framing of this post during my normal “thinking” moments (commuting, on the toilet, during useless meetings), I realized I’m going to take a different approach […]

0-helen-mary

Dear Analyst #94: Helen Mary Barrameda on having a “portfolio career” prior to being a data analyst, winning the NASA Space Apps challenge, and wfh tips

A common theme I’ve noticed from talking with many data analysts and data engineers is that they didn’t come from a “data” background. Helen Mary Barrameda someone who exemplifies this theme. She is based in the Philippines and started her career as a freelance writer in 2004 writing lifestyle pieces. She used her earnings from […]

0-sean-kelly

Dear Analyst #93: How to bring data literacy to schools and teaching Python with Sean Tibor and Kelly Schuster-Paredes

This episode is quite different from other episodes for a few reasons. One, it’s the first time I’ve had two guests on the show at the same time. Second, it’s the first time I’ve had educators on the show. Third, the guests have a podcast about Python so they taught me a thing or two […]

0-victor-rodrigues

Dear Analyst #92: Generating insights from vehicle telemetry data and crafting a data strategy with Victor Rodrigues

Data can come from different places, and one area I don’t hear about too often is from vehicles. Victor Rodrigues is from Brazil and transitioned into a career in data six years ago. Before that, he was working in various IT including network and infrastructure administration. He eventually relocated to Dublin working as a cloud […]

0-elena-dyachkova

Dear Analyst #91: Growing Peloton’s product analytics team and growth funnel experimentation at Superhuman with Elena Dyachkova

I first heard Elena speak on another podcast and was shocked to hear an analyst talk about one of the biggest companies to emerge during the pandemic: Peloton. Someone from the inside, as it were, is talking about topics that Peloton would likely want to keep confidential. Due to PR and the restrictions that come […]

0-tyler-vu

Dear Analyst #90: Biostatistics, public health, and the #1 strategy to land a job in data with Tyler Vu

You go to a family gathering and everyone is fawning over you cousin who has a cushy stats job at Harvard. Knowing your cousin, you think to yourself: if my cousin can do it, so can I. Next thing you know, you are a research fellow at Harvard University. Tyler Vu was studying applied math […]

0-david-jayatillake

Dear Analyst #89: Leading high performing data teams and deciphering the data stack with David Jayatillake

Most episodes I have the privilege of speaking with analysts who are in the trenches using tools and doing analyses. In this episode, we look at the role of data from a manager/director of data’s perspective. David Jayatillake is currently the Chief Product & Strategy Officer at Avora, an augmented analytics solution that helps companies […]

0-santiago-viquez

Dear Analyst #88: How to learn data science and machine learning from scratch with Santiago Viquez

Companies are generating more big data these days, so dumping the data into a CSV for analysis just doesn’t cut it anymore. Sure you could use Power Query or Power BI, but more analysts are turning to Python and platforms built for big data processing. The next step is to use machine learning to help […]

402709 01: Stadium employees remove letters from one of the Enron Field signs March 21, 2002 in Houston, TX. The Houston Astros paid $2.1 million to get back the naming rights to their stadium from collasped energy trader Enron. (Photo by James Nielsen/Getty Images)

Dear Analyst #87: What we can learn about Enron’s downfall from their internal spreadsheet errors

Everyone is probably familiar with the 600,000 emails released by Enron after their scandal right at the turn of the century. A lot of different analyses was done on those emails, but there’s one interesting analysis that I didn’t see until recently: the emails with spreadsheets as attachments. Felienne Hermans, a computer scientist at Delft […]

Dear Analyst #86: One Important Excel Feature to Know to Do Your Best Data Analysis

Nothing like a click-baity headline to get your spreadsheet emotion all riled up amirite? Earlier in my data analysis career, I thought knowing advanced Excel formulas and writing macros made you a good analyst. If you’ve been following this podcast/newsletter, you’ve probably discovered that there is no one magic Excel feature that automatically makes you […]