Dear Analyst #69: Import data from another Google Sheet and filter the results to show just what you need

You may be filtering and sorting a big dataset in a Google Sheet and want to see that dataset in another Google Sheet without having to copying and pasting the data each time the “source” data is updated. To solve this problem, you need to somehow import the data from the “source” worksheet to your […]

Dear Analyst #68: Generate unique IDs for your dataset for building summary reports in Google Sheets

If your dataset doesn’t have a unique identifier (e.g. customer ID, location ID, etc.), sometimes you have to make one up. The reason you need this unique ID is to summarize your dataset into a nice report to be shared with a client or internal stakeholders. Usually your dataset will have some kind of unique […]

Dear Analyst #67: Automating tedious tasks with scripts and solving problems software can’t fix

This episode is actually a recap of a talk I gave at a meetup. After reflecting a bit about the subject matter, I wanted to discuss some other topics that are more important than writing VBA scripts or doing stuff in Excel. At the meetup, I discussed a VBA script and Google App Script I […]

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

PivotTables have been on my mind lately (you’ll see why in a couple weeks). An issue you may face with PivotTables is how to change the source data for a PivotTable you’ve meticulously set up. You have some new data being added to your source data, and you have to change the PivotTable source data […]

Dear Analyst #65: Eliminating biases in sports data and doing a data science bootcamp with Caiti Donovan

When you think of sports and data, you may think about all the data collect on player performance and game stats. There’s another world of sports data that is usually overlooked: the fans. In this episode, I speak with Caiti Donovan, the VP of Data & Insights at Sports Innovation Lab, a sports market research firm. […]

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