Tag Archives: knowledge project

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 #41: How to do a VLOOKUP to the “left” without INDEX/MATCH with TikTok data

Since TikTok is in the news right now about who is going to buy them, I thought using some fake-ish TikTok acquisition data would be relevant for this episode. A classic Excel/Google Sheets challenge: how to do a VLOOKUP to the “left” e.g. your lookup column is not the first column in your lookup table. […]