Dear Analyst

Dear Analyst #126: How to data storytelling and create amazing data visualizations with Amanda Makulec

With an undergraduate degree in zoology and a master’s in public health, you wouldn’t expect...

• 0
• 0
• 9 días

Dear Analyst #125: How to identify Taylor Swift’s most underrated songs using data with Andrew Firriolo

Sometimes pop culture and data analysis meet and the result is something interesting,...

• 0
• 0
• 30 días

Dear Analyst #124: Navigating people, politics and analytics solutions at large companies with Alex Kolokolov

We sometimes forget that a large organization is composed of groups and divisions. Within these...

• 0
• 0
• 3 meses

Dear Analyst #123: Telling data stories about rugby and the NBA with Ben Wylie

When you think of data journalism, you might think of The New York Times’ nifty data...

• 0
• 0
• 3 meses

Dear Analyst #122: Designing an online version of Excel to help Uber China compete with DiDi on driver incentives...

There are only so many ways to make Excel “fun.” If you’ve been following this blog/podcast,...

• 0
• 0
• 5 meses

Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and...

One of the more popular courses you could take at my college to fulfill the finance major...

• 0
• 0
• 6 meses

Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up...

Data analytics and business analytics are still relatively new areas of study (in terms of...

• 0
• 0
• 6 meses

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

Future Dear Analyst episodes will get more sporadic since, well, life gets in the way....

• 0
• 0
• 7 meses

Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data...

No, this isn’t an episode about how Facebook’s algorithm and feed works. The data science...

• 0
• 0
• 10 meses

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...

• 0
• 0
• 11 meses

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...

• 0
• 0
• 1 año

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...

• 0
• 0
• 1 año

Dear Analyst Episode #114: How a small real estate investment company uses modern data and cloud tools to make...

When you think of data pipelines, data warehouses, and ETL tools, you may be thinking about some...

• 0
• 0
• 1 año

Dear Analyst #113: Top 5 data analytics trends for 2023

It’s that time of the year again where data professionals look at their data predictions from...

• 0
• 0
• 1 año

Dear Analyst #112: Greatest lessons learned from building solutions and processes for humans (re-broadcast of Secret...

This is a re-broadcast of an episode of the Secret Ops podcast hosted by my friend Ariana Cofone....

• 0
• 0
• 1 año

Dear Analyst #111: Master data management at AutoTrader and working with data in a merger with Korhonda Randolph

One topic that hasn’t been covered on Dear Analyst is master data management (MDM). I’m surprised...

• 0
• 0
• 1 año

Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power...

Have you ever faced a spreadsheet where one column contains values for each “section” of the...

• 0
• 0
• 1 año

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...

• 0
• 0
• 1 año

Dear Analyst #108: Skills needed for a successful data analytics career (Glich podcast re-broadcast)

This episode is a re-broadcast of a podcast I did with Bassem Dghaidi, a senior software engineer...

• 0
• 0
• 1 año

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...

• 0
• 0
• 1 año