Dear Analyst #64: Architecting revenue data pipelines and switching to a career in analytics with Lauren Adabie of Netlify

Transforming Netlify’s data pipeline one SQL statement at a time. Lauren Adabie started her career analyzing data and answering questions about the data at Zynga. As a data analyst at Netlify, she’s doing more than just exploratory analysis. She’s also helping build out Netlify’s revenue data pipeline; something she’s never done before. We discuss how […]

Dear Analyst #63: Cleaning Bitcoin Tweet data with OpenRefine, a free and open source alternative to Power Query

Numerous studies claim that data scientists spend too much time cleaning and preparing data (although this article claims it is a bullshit measure). I agree with some points in that article in that you should get your hands dirty with cleaning data to understand what eventually goes into the analysis. You may already be cleaning […]

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