0-sean-scott

Dear Analyst #96: Treating data as code and the new frontier for DBAs with Sean Scott

What did the developer say to the DBA? It doesn’t matter, the answer is “no.” I’ve never worked with a database administrator (DBA) before but know they play an important part in the data lifecycle at a company. Sean Scott stumbled into the DBA world and has been in this field for 25+ years. He […]

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 […]