Dear Analyst-logo

Dear Analyst

Technology Podcasts

A show made for analysts: data, data analysis, and software.

A show made for analysts: data, data analysis, and software.

Location:

United States

Description:

A show made for analysts: data, data analysis, and software.

Twitter:

@keycuts

Language:

English


Episodes

Dear Analyst #79: How to finally AutoFit column widths in Excel for the Mac (and PC)

10/11/2021
When you’re creating some dashboard or report, one of the most common formatting operations you’ll find yourself doing is expanding the column width to fit the text or numbers in a cell. You might also be expanding the row height to fit the size of the text, but I think it’s less common than expanding […] The post Dear Analyst #79: How to finally AutoFit column widths in Excel for the Mac (and PC) appeared first on .

Duration:00:20:54

Dear Analyst #78: 3 mental models from the show Billions

10/4/2021
Following up from episode #77 about mental models, I wanted to take things one step further and tie mental models to one of my favorite shows. If you came here hoping for the latest Excel trick or keyboard shortcut, apologies in advance. If there’s one theme you should take away from these posts, it’s being […] The post Dear Analyst #78: 3 mental models from the show Billions appeared first on .

Duration:00:34:43

Dear Analyst #77: The top 3 mental models I never think about and live by (I think)

9/20/2021
The promise of mental models is that it helps you bridge the gap between what’s in your mind and what happens in real life. They are interesting thought exercises in how you think. But that’s where it ends for me. How often do you approach a big decision in life and decide to pull from […] The post Dear Analyst #77: The top 3 mental models I never think about and live by (I think) appeared first on .

Duration:00:37:21

Dear Analyst #76: Productivity hack for creating a Google Calendar event by sending yourself an email

9/7/2021
Taking a slight detour off of the data analysis/spreadsheet path and getting into the world of productivity hacks with this episode. A productivity hack can mean different things, and in this case it’s a hack to improve your workflow at, you guessed it, work. This hack gives you the ability to create a Google Calendar […] The post Dear Analyst #76: Productivity hack for creating a Google Calendar event by sending yourself an email appeared first on .

Duration:00:20:16

Dear Analyst #75: How to extract first, last, and multiple middle names into 3 separate columns

8/16/2021
In episode 52, I talked about how to extract text from a cell. You might use this formula to extract a certain value from a cell when your database or CSV export contains a bunch of miscellaneous prefix data. This formula relies on finding a certain character in the cell and then using the MID […] The post Dear Analyst #75: How to extract first, last, and multiple middle names into 3 separate columns appeared first on .

Duration:00:16:36

Dear Analyst #74: Quick hack to count the number of words in a cell with LEN and SUBSTITUTE

7/19/2021
While this little Excel/Google Sheets trick is a pretty straightforward hack, it led me to think about how we use our tools, how we stretch the capabilities of our tools, and think outside the box to come to arrive at a solution. Seems like a lot for a formula trick on counting the number of […] The post Dear Analyst #74: Quick hack to count the number of words in a cell with LEN and SUBSTITUTE appeared first on .

Duration:00:34:33

Dear Analyst #73: From a career in the U.S. Navy to data analytics YouTuber with Luke Barousse

6/22/2021
The path to a career in data analytics can be full of twists and turns. Along the way, you pick up tools like Excel, Python, Tableau, and R. What about learning how to use YouTube and growing an audience of 50,000+ from publishing videos about data analytics? I’m always fascinated by people who are able […] The post Dear Analyst #73: From a career in the U.S. Navy to data analytics YouTuber with Luke Barousse appeared first on .

Duration:00:42:23

Dear Analyst #72: A simple trick to be faster in Excel on the Mac (like you are on the PC)

6/14/2021
The impetus for this episode is a new Google Sheet (and Excel) tip I just shared on Instagram and TikTok (I never thought I’d join these platforms to start posting tips but alas, this is how people learn these days). After I learned how to be productive the PC version of Excel, I opened my […] The post Dear Analyst #72: A simple trick to be faster in Excel on the Mac (like you are on the PC) appeared first on .

Duration:00:23:03

Dear Analyst #71: Benn Stancil, Co-Founder and Chief Analytics Officer at Mode Analytics on all things analytics

5/24/2021
Learning the tips and tricks for doing data analysis in Excel is great and all, but stepping back to see the bigger picture leads to better questions (and answers) you can ask as an analyst. Benn Stancil is one of the founders at Mode Analytics, a data visualization platform you may have used before. Benn […] The post Dear Analyst #71: Benn Stancil, Co-Founder and Chief Analytics Officer at Mode Analytics on all things analytics appeared first on .

Duration:00:36:23

Dear Analyst #70: New advanced PivotTable class and a PivotTable calculated field trick for percentages

5/18/2021
I’ve been planning a few advanced Excel classes with Skillshare and excited to launch my first one today called Advanced PivotTable Techniques for Analyzing and Presenting Data Faster. I use PivotTables on and off depending on the task at hand. In preparation for this class, I had the opportunity to research and learn some advanced […] The post Dear Analyst #70: New advanced PivotTable class and a PivotTable calculated field trick for percentages appeared first on .

Duration:00:11:22

Dear Analyst #69: Import data from another Google Sheet and filter the results to show just what you need

5/10/2021
You may be filtering and sorting a big dataset in a Google Sheet and want to see that dataset in another Google Sheet without having to copying and pasting the data each time the “source” data is updated. To solve this problem, you need to somehow import the data from the “source” worksheet to your […] The post Dear Analyst #69: Import data from another Google Sheet and filter the results to show just what you need appeared first on .

Duration:00:30:34

Dear Analyst #68: Generate unique IDs for your dataset for building summary reports in Google Sheets

5/4/2021
If your dataset doesn’t have a unique identifier (e.g. customer ID, location ID, etc.), sometimes you have to make one up. The reason you need this unique ID is to summarize your dataset into a nice report to be shared with a client or internal stakeholders. Usually your dataset will have some kind of unique […] The post Dear Analyst #68: Generate unique IDs for your dataset for building summary reports in Google Sheets appeared first on .

Duration:00:30:37

Dear Analyst #67: Automating tedious tasks with scripts and solving problems software can’t fix

4/19/2021
This episode is actually a recap of a talk I gave at a meetup. After reflecting a bit about the subject matter, I wanted to discuss some other topics that are more important than writing VBA scripts or doing stuff in Excel. At the meetup, I discussed a VBA script and Google App Script I […] The post Dear Analyst #67: Automating tedious tasks with scripts and solving problems software can’t fix appeared first on .

Duration:00:36:32

Dear Analyst #66: How to update and add new data to a PivotTable with ramen ratings data

4/12/2021
PivotTables have been on my mind lately (you’ll see why in a couple weeks). An issue you may face with PivotTables is how to change the source data for a PivotTable you’ve meticulously set up. You have some new data being added to your source data, and you have to change the PivotTable source data […] The post Dear Analyst #66: How to update and add new data to a PivotTable with ramen ratings data appeared first on .

Duration:00:24:43

Dear Analyst #65: Eliminating biases in sports data and doing a data science bootcamp with Caiti Donovan

3/29/2021
When you think of sports and data, you may think about all the data collect on player performance and game stats. There’s another world of sports data that is usually overlooked: the fans. In this episode, I speak with Caiti Donovan, the VP of Data & Insights at Sports Innovation Lab, a sports market research firm. […] The post Dear Analyst #65: Eliminating biases in sports data and doing a data science bootcamp with Caiti Donovan appeared first on .

Duration:00:48:26

Dear Analyst #64: Architecting revenue data pipelines and switching to a career in analytics with Lauren Adabie of Netlify

3/22/2021
Transforming Netlify’s data pipeline one SQL statement at a time. Lauren Adabie started her career analyzing data and answering questions about the data at Zynga. As a data analyst at Netlify, she’s doing more than just exploratory analysis. She’s also helping build out Netlify’s revenue data pipeline; something she’s never done before. We discuss how […] The post Dear Analyst #64: Architecting revenue data pipelines and switching to a career in analytics with Lauren Adabie of Netlify...

Duration:00:39:40

Dear Analyst #63: Cleaning Bitcoin Tweet data with OpenRefine, a free and open source alternative to Power Query

3/15/2021
Numerous studies claim that data scientists spend too much time cleaning and preparing data (although this article claims it is a bullshit measure). I agree with some points in that article in that you should get your hands dirty with cleaning data to understand what eventually goes into the analysis. You may already be cleaning […] The post Dear Analyst #63: Cleaning Bitcoin Tweet data with OpenRefine, a free and open source alternative to Power Query appeared first on .

Duration:00:25:15

Dear Analyst #62: Using data storytelling to close billions of dollars worth of deals at LinkedIn with Janie Ho

3/1/2021
This episode is all about data storytelling at a “traditional” enterprise company like LinkedIn and also at a major news publication. Janie Ho is a former global account analyst at LinkedIn in NYC where she facilitated data-driven presentations to close revenue deals for LinkedIn’s top global strategic accounts. Currently, she is a senior editor in […] The post Dear Analyst #62: Using data storytelling to close billions of dollars worth of deals at LinkedIn with Janie Ho appeared first on...

Duration:00:32:30

Dear Analyst #61: Empowering businesses and individuals with data literacy skills with Oz du Soleil

2/22/2021
Oz is one of the best creators of Excel content I know with his Excel on Fire YouTube channel. Unlike traditional “how-to” videos, his videos blend education with entertainment making the learning process feel like binging your favorite Netflix show. Oz and I met on Google+ way back in the day and in person at […] The post Dear Analyst #61: Empowering businesses and individuals with data literacy skills with Oz du Soleil appeared first on .

Duration:00:40:06

Dear Analyst #60: Going from a corporate accountant to building an Excel training academy with John Michaloudis

2/15/2021
It’s a story we’ve all heard before. You’re working a full-time job, and you have more fun doing your side hustle than your 9 to 5. This is what happened to John Michaloudis. He was a financial controller at General Electric but found his passion sharing Excel tips and tricks on an internal GE newsletter […] The post Dear Analyst #60: Going from a corporate accountant to building an Excel training academy with John Michaloudis appeared first on .

Duration:00:29:15