Dear Analyst
Latest Episodes
Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca Gino
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
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
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
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
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?
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
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
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
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)
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