2-empty-cells

Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast)

Have you ever faced a spreadsheet where one column contains values for each “section” of the spreadsheet but you want to fill those values down through the rest of the column? This is a common problem when you get a data dump from a database or perhaps a copy/paste from a PivotTable. You have values […]

0-sarfraz-nawaz

Dear Analyst #109: Data strategy and optimizing the vaccine supply chain at Johnson & Johnson with Sarfraz Nawaz

Johnson & Johnson is one of the largest corporations in the world and they produce everything from medical devices to baby powder. They were also on the front lines of developing a vaccine during the pandemic. Internally, J&J is also at the forefront of digital transformation. Sarfraz Nawaz studied computer science and built data analytics […]

0-matthew-brandt

Dear Analyst #107: Using Twitch to teach people about analytics and launching a food tech startup with Matthew Brandt

Matthew Brandt didn’t know analytics was a potential career option until he started managing websites with Google Analytics. Matthew is Canadian, spent most of his life in Switzerland, and went to high school in Japan. He attended the EHL hospitality school at Lausanne, and was part of the 70% who left the hospitality field after […]

0-gift

Dear Analyst #106: Democratizing data knowledge and community building in Africa with Gift Ojeabulu

Gift Ojeabulu is a data science professional, community organizer, and data practitioner from Nigeria. He studied biochemistry at university but eventually switched to computer science. He first started in web and Android development before moving to the data science field. By attending developers conferences in Lagos, he started learning more about data science and started […]

0-vlookup-multiple-conditions

How to do a VLOOKUP with multiple conditions or criteria (3 methods)

Once you learn the VLOOKUP formula, your world opens up in terms of being able to analyze and manipulate data. There are hundreds if not thousands of tutorials on how to use the VLOOKUP formula since it’s such a powerful formula for finding the data you need in a long list. Comparable formulas include the […]

0-austin-dowd

Dear Analyst #104: Creating a single source of truth by cleaning marketing analytics data with Austin Dowd

I’m always fascinated by how different people on the podcast find their way into data, and this episode is no exception. Austin Dowd has always enjoyed photography. He was associated with the American Marketing Association and was always curious in the metrics for his photos. After pestering the analytics person in the AMA in terms […]

12-copy-paste-pivot-table-slicer

Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)

I used to create a monthly 30-slide report and each slide had a different table or chart that I copied and pasted from Excel. As a naive analyst, I literally filtered my list of data using regular dropdown filters on each column to get the numbers I needed. I would filter, sum or average the […]

0-mel-restori

Dear Analyst #102: Building a culture of experimentation on a data analytics team with Mel Restori, former Director of Analytics at Trove

Experimentation is a valuable activity in a variety of functions. A product team should be constantly experimenting with features to see which variant leads to the most engagement, sales, or some target metric. But what about on a data analytics team? Mel Restori is the former Director of Analytics & Analytics Engineering at Trove, a […]

0-David-Yakobovitch

Dear Analyst #101: How to invest in modern data startups with David Yakobovitch

Outside of Excel, you’ve seen and heard multiple data platforms on this newsletter and podcast. Everything from commercial data platforms to open-source platforms driven by communities. In this episode, you’ll hear the other side of the data platform ecosystem. David Yakobovitch is a general partner at DataPower Ventures, a venture capital firm that invests in […]