Archive / Podcast

RSS feed for this section

Dear Analyst #62: Using data storytelling to close billions of dollars worth of deals at LinkedIn with Janie Ho

This episode is all about data storytelling at a “traditional” enterprise company like LinkedIn and also at a major news publication. Janie Ho is a former global account analyst at LinkedIn in NYC where she facilitated data-driven presentations to close revenue deals for LinkedIn’s top global strategic accounts. Currently, she is a senior editor in […]

Dear Analyst #61: Empowering businesses and individuals with data literacy skills with Oz du Soleil

Oz is one of the best creators of Excel content I know with his Excel on Fire YouTube channel. Unlike traditional “how-to” videos, his videos blend education with entertainment making the learning process feel like binging your favorite Netflix show. Oz and I met on Google+ way back in the day and in person at […]

Dear Analyst #60: Going from a corporate accountant to building an Excel training academy with John Michaloudis

It’s a story we’ve all heard before. You’re working a full-time job, and you have more fun doing your side hustle than your 9 to 5. This is what happened to John Michaloudis. He was a financial controller at General Electric but found his passion sharing Excel tips and tricks on an internal GE newsletter […]

Dear Analyst #59: Enterprise data tools and the rise of data engineering with Priyanka Somrah, VC analyst at Work-Bench

The NY Enterprise Tech meetup was one of my favorite events to attend in-person prior to the pandemic. While the meetup is now all virtual, the speakers they bring in continue to be top-notch–particularly in the data space. The host of the meetup is Work-Bench, a VC focused on enterprise software companies. Priyanka Somrah is […]

Dear Analyst #58: Canva’s data warehouse initiative to increase reliability and tooling for analysts with Krishna Naidu

Data warehouses have come a long way since the days of Oracle and Microstrategy. A data warehouse should be able to grow and expand with the business it supports. At Canva, the data amount of data coming into the data warehouse has exploded in the last few years given the platform’s surging usage. In this […]

Dear Analyst #57: Automating weekly reports, working with stakeholders, and data definitions with Nadja Jury of Education Perfect

One of the best feelings is knowing you’ve streamlined and automated a report such that your colleague doesn’t have to spend hours creating the report every week. Whether you automate the report through a bunch of Excel formulas or setting up some sort of data pipeline, analysts are always thinking about driving internal efficiencies. This […]

Dear Analyst #56: Self-serve dashboards, Excel, and data accuracy with BI Analyst John Napoleon-Kuofie of Farfetch

In this episode, I had the pleasure of speaking with John Napoleon-Kuofie, a senior business intelligence analyst at Farfetch. In this conversation, we talked about how John’s career led him to Farfetch, a traffic dashboard he’s built for his stakeholders at Farfetch, and how Excel was his gateway into SQL and the wonderful world of […]

Dear Analyst #55: Using Google Translate to quickly translate text with Le Grand Débat National data

This is a super simple formula in Google Sheets, and I don’t want to understate its utility. You can literally translate text from any language into another language. This formula came out on Google Sheets in early 2019 I believe. You basically don’t have to copy and paste into Google Translate anymore to get the […]

Dear Analyst #54: 5 lessons learned in 2020 and 5 skills for data analysts to learn in 2021

With the last episode for 2020, I wanted to take a look back and pull out some of the main themes and topics from the podcast. As people rushed to pick up new data skills to adapt to our changing environment this year, I think the precedent has been set for how one can learn […]

Dear Analyst #53: Making your Google Sheets do more for you with Google Apps Script and how to become more data-driven

When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more, I found that Google Apps Script offers similar functionality to extend what […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!