Dear Analyst

Dear Analyst


Latest Episodes

Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca Gino
October 23, 2023

One of the more popular courses you could take at my college to fulfill the finance major requirements was Behavioral Finance. The main "textbook" was Inefficient Markets and we learned about how ther

Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up with Zach Wilner
October 09, 2023

Data analytics and business analytics are still relatively new areas of study (in terms of academics). The subject borders business and computer science. When I went to school, the only data analytics

Dear Analyst #119: Developing the holy “grail” model at Lyft, user journeys, and hidden analytics with Sean Taylor
September 18, 2023

Future Dear Analyst episodes will get more sporadic since, well, life gets in the way. Unfortunately curiosity (in most cases) doesn't pay the bills. Nevertheless, when I come across an idea or person

Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data science with Akos Lada
July 03, 2023

No, this isn't an episode about how Facebook's algorithm and feed works. The data science function is popping up in companies small and large given the amount of data swimming around. No other company

Dear Analyst #117: New 2023 Google Sheets functions for data manipulation that already exist in Excel
May 23, 2023

The Google Workspace team announced a slew of Google Sheets functions a few months ago (February 2023). These functions look familiar and that's because Microsoft Excel released most of them two years

Dear Analyst Episode #116: Will Microsoft’s AI Copilot for Excel replace the need for analysts?
March 27, 2023

This news is a bit old but I figured it's juicy enough to talk about its future implications on Excel and artificial intelligence in general. Mid-March 2023, Microsoft announced Copilot, it's artifici

Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets
February 27, 2023

Counting the number of colored cells or formatted cells in Google Sheets or Excel seems like it should be a basic operation. Unfortunately after much Googling, it doesn't seem as easy as it looks. I c

Dear Analyst Episode #114: How a small real estate investment company uses modern data and cloud tools to make data-driven decisions
January 17, 2023

When you think of data pipelines, data warehouses, and ETL tools, you may be thinking about some large enterprise that is collecting and processing data from IoT devices or from a mobile app. These co

Dear Analyst #113: Top 5 data analytics predictions for 2023
December 27, 2022

It's that time of the year again where data professionals look at their data predictions from 2022 and decide what they were wrong about and think: "this must be the year for XYZ." Aside from the fact

Dear Analyst #112: Greatest lessons learned from building solutions and processes for humans (re-broadcast of Secret Ops)
December 19, 2022

This is a re-broadcast of an episode of the Secret Ops podcast hosted by my friend Ariana Cofone. Ariana is an operations consultant and her podcast is all about business operations. While I've never