Dear Analyst

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

The post Dear Analyst #107: Using Twitch to teach people about analytics and launching a food tech startup with Matthew Brandt appeared first on .

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

The post Dear Analyst #106: Democratizing data knowledge and community building in Africa with Gift Ojeabulu appeared first on .

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

The post How to do a VLOOKUP with multiple conditions or criteria (3 methods) appeared first on .

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

The post Dear Analyst #104: Creating a single source of truth by cleaning marketing analytics data with Austin Dowd appeared first on .

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

The post Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers) appeared first on .

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

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

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

The post Dear Analyst #101: How to invest in modern data startups with David Yakobovitch appeared first on .