Dear Analyst
119 episodes - English - Latest episode: about 1 month ago - ★★★★ - 5 ratingsA show made for analysts: data, data analysis, and software.
Homepage Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Episodes
Dear Analyst #128: What is citizen development and how to build solutions with spreadsheets?
May 28, 2024 05:11 - 28.5 MBThis is a replay of an episode from the Citizen Development Live podcast with Neil Miller. Citizen development is a relatively new term I learned about a year ago or so. To me, it’s using no-code tools at scale within a large enterprise. It’s a term that covers the population of people who are not […] The post Dear Analyst #128: What is citizen development and how to build solutions with spreadsheets? appeared first on .
Dear Analyst #127: Spreadsheets vs. Jira: Which one is better for your team?
May 13, 2024 16:41 - 36 minutes - 30.4 MBI wasn’t sure if this topic should be it’s own episode but it’s been on my mind ever since I came back from Atlassian Team ’24 (Atlassian’s annual conference). At the conference, I had the opportunity to meet with a few people who are just as interested in spreadsheets as I am. We talked specifically […] The post Dear Analyst #127: Spreadsheets vs. Jira: Which one is better for your team? appeared first on .
Dear Analyst #126: How to data storytelling and create amazing data visualizations with Amanda Makulec
April 15, 2024 06:05 - 44 minutes - 38.2 MBWith an undergraduate degree in zoology and a master’s in public health, you wouldn’t expect Amanda Makulec to lead a successful career in data analytics and data visualization. As we’ve seen with multiple guests on the podcast, the path to a career in data analytics is windy and unexpected. It was the intersection of public […] The post Dear Analyst #126: How to data storytelling and create amazing data visualizations with Amanda Makulec appeared first on .
Dear Analyst #125: How to identify Taylor Swift’s most underrated songs using data with Andrew Firriolo
March 25, 2024 05:34 - 37 minutes - 31.1 MBSometimes pop culture and data analysis meet and the result is something interesting, thought-provoking, and of course controversial. How can one use data to prove definitely which Taylor Swift songs are the most underrated? Isn’t this a question for your heart to answer? Andrew Firriolo sought to answer this question over the last few months […] The post Dear Analyst #125: How to identify Taylor Swift’s most underrated songs using data with Andrew Firriolo appeared first on .
Dear Analyst #124: Navigating people, politics and analytics solutions at large companies with Alex Kolokolov
February 05, 2024 06:16 - 38 minutes - 31.7 MBWe sometimes forget that a large organization is composed of groups and divisions. Within these groups, there are teams and individuals looking to advance their careers. Sometimes at the expense of others. When your advancement depends on the success of your project, the benefits of that project to your company may be suspect and the […] The post Dear Analyst #124: Navigating people, politics and analytics solutions at large companies with Alex Kolokolov appeared first on .
Dear Analyst #123: Telling data stories about rugby and the NBA with Ben Wylie
January 15, 2024 06:55 - 37 minutes - 32.6 MBWhen you think of data journalism, you might think of The New York Times’ nifty data visualizations and the Times’ embrace of data literacy for all their journalists. Outside of The New York Times, I haven’t met anyone who does data journalism and data storytelling full-time until I spoke with Ben Wylie. Ben is the […] The post Dear Analyst #123: Telling data stories about rugby and the NBA with Ben Wylie appeared first on .
Dear Analyst #122: Designing an online version of Excel to help Uber China compete with DiDi on driver incentives with Matt Basta
December 04, 2023 19:28 - 43 minutes - 36.6 MBThere are only so many ways to make Excel “fun.” If you’ve been following this blog/podcast, stories about the financial modeling competition and spreadsheet errors that lead to catastrophic financial loss are stories that make a 1980s tool somewhat interesting to read and listen to. There are numerous tutorials and TikTok influencers who teach Excel […] The post Dear Analyst #122: Designing an online version of Excel to help Uber China compete with DiDi on driver incentives with Matt Basta...
Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca Gino
October 23, 2023 05:28 - 27 minutes - 24.7 MBOne 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 there are qualitative ways to value a security beyond what the efficient market hypothesis purports. During the financial crisis of 2008, psychology professor […] The post Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca ...
Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up with Zach Wilner
October 09, 2023 05:47 - 31 minutes - 28.4 MBData 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 classes available were special electives offered through our school’s continuing education department. In this episode, I spoke with Zach Wilner who currently leads […] The post Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up wi...
Dear Analyst #119: Developing the holy “grail” model at Lyft, user journeys, and hidden analytics with Sean Taylor
September 18, 2023 18:32 - 32 minutes - 25.7 MBFuture 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 that I think is worth sharing/learning more about, I’ll try my best to post. In this episode, I interview the Chief Scientist […] The post Dear Analyst #119: Developing the holy “grail” model at Lyft, user journeys, and hidden analytics with Sean Taylor appeared first on .
Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data science with Akos Lada
July 03, 2023 05:41 - 30 minutes - 24.7 MBNo, 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 understand the power and influence that data science can have on the customer experience than Facebook (Meta, to be exact). Akos […] The post Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data science with Akos Lada appeared first...
Dear Analyst #117: New 2023 Google Sheets functions for data manipulation that already exist in Excel
May 23, 2023 05:09 - 33 minutes - 28.8 MBThe 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 ago. I never had a chance to play around with the new functions in Excel since I don’t have the latest Office 365 […] The post Dear Analyst #117: New 2023 Google Sheets functions for data manipulation that already exist in Excel appeared first on .
Dear Analyst Episode #116: Will Microsoft’s AI Copilot for Excel replace the need for analysts?
March 27, 2023 15:48 - 23 minutes - 26.3 MBThis 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 artificial intelligence bet that will supposedly change the way we work. The video discusses how Copilot integrates with Office 365 and all your Microsoft […] The post Dear Analyst Episode #116: Will Microsoft’s AI Copilot for Excel replace the need for analysts? appeared first on .
Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets
February 27, 2023 17:59 - 34 minutes - 38.3 MBCounting 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 came across this Mr. Excel forum thread where someone asks how to count the number of rows where there is […] The post Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets appeared first on .
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 06:58 - 32 minutes - 24.5 MBWhen 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 companies are using tools from AWS and Google Cloud to build these complex workflows to get data to where it needs […] The post Dear Analyst Episode #114: How a small real estate investment company uses modern data and cloud tools to make data-driven decisions appeared first on .
Dear Analyst #113: Top 5 data analytics predictions for 2023
December 27, 2022 06:16 - 31 minutes - 33.2 MBIt’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 that these type of predictions are 100% subjective and nearly impossible to verify, it’s always fun to play […] The post Dear Analyst #113: Top 5 data analytics predictions for 2023 appeared first on .
Dear Analyst #112: Greatest lessons learned from building solutions and processes for humans (re-broadcast of Secret Ops)
December 19, 2022 06:40 - 35 minutes - 32.3 MBThis 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 officially held a “business operations” role, I’ve worked in roles that are related to the operations world. In this conversation, we […] The post Dear Analyst #112: Greatest lessons learned from building solutions and processes for humans (re-broadcast of Secret Ops) appeared first on .
Dear Analyst #111: Master data management at AutoTrader and working with data in a merger with Korhonda Randolph
December 12, 2022 06:05 - 27 minutes - 18.8 MBOne topic that hasn’t been covered on Dear Analyst is master data management (MDM). I’m surprised it took this long before someone brought it up. I’ve never heard of the term before and it looks like it’s a core strategy for many large corporations for manager their data. Korhonda Randolph studied systems engineering at the […] The post Dear Analyst #111: Master data management at AutoTrader and working with data in a merger with Korhonda Randolph appeared first on .
Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast)
November 21, 2022 05:39 - 58 minutes - 60.3 MBHave you ever faced a spreadsheet where one column contains values for each “section” of the spreadsheet but you want to fill those values down through the rest of the column? This is a common problem when you get a data dump from a database or perhaps a copy/paste from a PivotTable. You have values […] The post Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast) appeared first on .
Dear Analyst #109: Data strategy and optimizing the vaccine supply chain at Johnson & Johnson with Sarfraz Nawaz
November 14, 2022 06:45 - 33 minutes - 25.2 MBJohnson & Johnson is one of the largest corporations in the world and they produce everything from medical devices to baby powder. They were also on the front lines of developing a vaccine during the pandemic. Internally, J&J is also at the forefront of digital transformation. Sarfraz Nawaz studied computer science and built data analytics […] The post Dear Analyst #109: Data strategy and optimizing the vaccine supply chain at Johnson & Johnson with Sarfraz Nawaz appeared first on .
Dear Analyst #108: Skills needed for a successful data analytics career (Glich podcast re-broadcast)
October 31, 2022 05:26 - 48 minutes - 46.4 MBThis episode is a re-broadcast of a podcast I did with Bassem Dghaidi, a senior software engineer at GitHub. Bassem has a podcast and YouTube channel called Glich. On his show, he covers moderate to advanced engineering topics on coding, architecture and management. Data analytics is a little outside of the topics he generally talks […] The post Dear Analyst #108: Skills needed for a successful data analytics career (Glich podcast re-broadcast) appeared first on .
Dear Analyst #107: Using Twitch to teach people about analytics and launching a food tech startup with Matthew Brandt
October 17, 2022 10:30 - 40 minutes - 35.2 MBMatthew 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 .
Dear Analyst #106: Democratizing data knowledge and community building in Africa with Gift Ojeabulu
October 10, 2022 05:09 - 24 minutes - 23.1 MBGift 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 appea...
How to do a VLOOKUP with multiple conditions or criteria (3 methods)
September 26, 2022 05:05 - 24 minutes - 25.3 MBOnce 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 .
Dear Analyst #104: Creating a single source of truth by cleaning marketing analytics data with Austin Dowd
September 05, 2022 14:14 - 35 minutes - 32.2 MBI’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 .
Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)
August 22, 2022 06:08 - 22 minutes - 24 MBI 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 .
Dear Analyst #102: Building a culture of experimentation on a data analytics team with Mel Restori, former Director of Analytics at Trove
August 08, 2022 05:02 - 28 minutes - 21.7 MBExperimentation 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...
Dear Analyst #101: How to invest in modern data startups with David Yakobovitch
July 25, 2022 15:05 - 37 minutes - 38.3 MBOutside 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 .
Dear Analyst #100: Hitting a hunned! A look back at the top 5 episodes of Dear Analyst
July 11, 2022 05:59 - 21 minutes - 23 MBHoly cannoli. Somehow we’ve hit 100 hundred episodes of the Dear Analyst podcast. This podcast started off as an experiment because I was lazy and got tired of writing. I figured speaking about Excel and data analytics would be easier than coming up with prose. Ironically, I’m still writing because all the show notes for […] The post Dear Analyst #100: Hitting a hunned! A look back at the top 5 episodes of Dear Analyst appeared first on .
Dear Analyst #99: Hyperscaling at Uber Eats and using VBA to automate M&A models with Ryan Cunningham
July 05, 2022 05:14 - 54 minutes - 44.4 MBMLOps, neuromorphic computing, next-generation enterprises. These are concepts you generally don’t hear about in the field of data analytics. This episode shows that you can parlay a career in data analysis into any field you want. That’s exactly what Ryan Cunningham did to become a Senior Associate Builder at AI Fund. Ryan studied finance and […] The post Dear Analyst #99: Hyperscaling at Uber Eats and using VBA to automate M&A models with Ryan Cunningham appeared first on .
Dear Analyst #98: How a career in graphic design helps you with data storytelling and visualizations with Wacarra Yeomans
June 21, 2022 20:04 - 39 minutes - 30.2 MBWhen you’re working in a marketing or advertising agency, you’ll work with clients across various industries. The data you analyze will also vary client to client, giving you exposure to various datasets and the business logic that drives these datasets. Wacarra Yeomans started her career as a graphic designer in the agency world. She always […] The post Dear Analyst #98: How a career in graphic design helps you with data storytelling and visualizations with Wacarra Yeomans appeared first o...
Dear Analyst #97: Becoming a data Swiss army knife for marketing, operations, and customer support data problems with Sarah Krasnik
June 13, 2022 15:24 - 37 minutes - 28.4 MBAs a flex player on a data team, you might play the role of a data scientist, data analyst, or data engineer. Sarah Krasnik is one of those people who has held all these roles. In this conversation, Sarah gets into the weeds of what most data analysts do: helping business partners make better decisions […] The post Dear Analyst #97: Becoming a data Swiss army knife for marketing, operations, and customer support data problems with Sarah Krasnik appeared first on .
Dear Analyst #96: Treating data as code and the new frontier for DBAs with Sean Scott
June 06, 2022 05:19 - 35 minutes - 27.1 MBWhat did the developer say to the DBA? It doesn’t matter, the answer is “no.” I’ve never worked with a database administrator (DBA) before but know they play an important part in the data lifecycle at a company. Sean Scott stumbled into the DBA world and has been in this field for 25+ years. He […] The post Dear Analyst #96: Treating data as code and the new frontier for DBAs with Sean Scott appeared first on .
Dear Analyst #95: Nobody ever got fired for choosing Google Sheets
May 23, 2022 05:00 - 29 minutes - 29.1 MBThe motivation for this post/episode is a selfish one (scroll to the very bottom or skip to the end of the podcast to see why). As I thought about the framing of this post during my normal “thinking” moments (commuting, on the toilet, during useless meetings), I realized I’m going to take a different approach […] The post Dear Analyst #95: Nobody ever got fired for choosing Google Sheets appeared first on .
Dear Analyst #94: Helen Mary Barrameda on having a “portfolio career” prior to being a data analyst, winning the NASA Space Apps challenge, and wfh tips
May 16, 2022 05:37 - 43 minutes - 31.4 MBA common theme I’ve noticed from talking with many data analysts and data engineers is that they didn’t come from a “data” background. Helen Mary Barrameda someone who exemplifies this theme. She is based in the Philippines and started her career as a freelance writer in 2004 writing lifestyle pieces. She used her earnings from […] The post Dear Analyst #94: Helen Mary Barrameda on having a “portfolio career” prior to being a data analyst, winning the NASA Space Apps challenge, and wfh tips...
Dear Analyst #93: How to bring data literacy to schools and teaching Python with Sean Tibor and Kelly Schuster-Paredes
May 09, 2022 06:25 - 41 minutes - 35.7 MBThis episode is quite different from other episodes for a few reasons. One, it’s the first time I’ve had two guests on the show at the same time. Second, it’s the first time I’ve had educators on the show. Third, the guests have a podcast about Python so they taught me a thing or two […] The post Dear Analyst #93: How to bring data literacy to schools and teaching Python with Sean Tibor and Kelly Schuster-Paredes appeared first on .
Dear Analyst #92: Generating insights from vehicle telemetry data and crafting a data strategy with Victor Rodrigues
April 25, 2022 05:35 - 34 minutes - 28.5 MBData can come from different places, and one area I don’t hear about too often is from vehicles. Victor Rodrigues is from Brazil and transitioned into a career in data six years ago. Before that, he was working in various IT including network and infrastructure administration. He eventually relocated to Dublin working as a cloud […] The post Dear Analyst #92: Generating insights from vehicle telemetry data and crafting a data strategy with Victor Rodrigues appeared first on .
Dear Analyst #91: Growing Peloton’s product analytics team and growth funnel experimentation at Superhuman with Elena Dyachkova
April 18, 2022 05:40 - 38 minutes - 29.8 MBI first heard Elena speak on another podcast and was shocked to hear an analyst talk about one of the biggest companies to emerge during the pandemic: Peloton. Someone from the inside, as it were, is talking about topics that Peloton would likely want to keep confidential. Due to PR and the restrictions that come […] The post Dear Analyst #91: Growing Peloton’s product analytics team and growth funnel experimentation at Superhuman with Elena Dyachkova appeared first on .
Dear Analyst #90: Biostatistics, public health, and the #1 strategy to land a job in data with Tyler Vu
April 11, 2022 05:07 - 49 minutes - 38.3 MBYou go to a family gathering and everyone is fawning over you cousin who has a cushy stats job at Harvard. Knowing your cousin, you think to yourself: if my cousin can do it, so can I. Next thing you know, you are a research fellow at Harvard University. Tyler Vu was studying applied math […] The post Dear Analyst #90: Biostatistics, public health, and the #1 strategy to land a job in data with Tyler Vu appeared first on .
Dear Analyst #89: Leading high performing data teams and deciphering the data stack with David Jayatillake
April 04, 2022 05:10 - 25 minutes - 20.3 MBMost episodes I have the privilege of speaking with analysts who are in the trenches using tools and doing analyses. In this episode, we look at the role of data from a manager/director of data’s perspective. David Jayatillake is currently the Chief Product & Strategy Officer at Avora, an augmented analytics solution that helps companies […] The post Dear Analyst #89: Leading high performing data teams and deciphering the data stack with David Jayatillake appeared first on .
Dear Analyst #88: How to learn data science and machine learning from scratch with Santiago Viquez
March 21, 2022 05:01 - 42 minutes - 34.8 MBCompanies are generating more big data these days, so dumping the data into a CSV for analysis just doesn’t cut it anymore. Sure you could use Power Query or Power BI, but more analysts are turning to Python and platforms built for big data processing. The next step is to use machine learning to help […] The post Dear Analyst #88: How to learn data science and machine learning from scratch with Santiago Viquez appeared first on .
Dear Analyst #87: What we can learn about Enron’s downfall from their internal spreadsheet errors
March 14, 2022 12:34 - 33 minutes - 32.9 MBEveryone is probably familiar with the 600,000 emails released by Enron after their scandal right at the turn of the century. A lot of different analyses was done on those emails, but there’s one interesting analysis that I didn’t see until recently: the emails with spreadsheets as attachments. Felienne Hermans, a computer scientist at Delft […] The post Dear Analyst #87: What we can learn about Enron’s downfall from their internal spreadsheet errors appeared first on .
Dear Analyst #86: One Important Excel Feature to Know to Do Your Best Data Analysis
February 28, 2022 18:47 - 28 minutes - 28 MBNothing like a click-baity headline to get your spreadsheet emotion all riled up amirite? Earlier in my data analysis career, I thought knowing advanced Excel formulas and writing macros made you a good analyst. If you’ve been following this podcast/newsletter, you’ve probably discovered that there is no one magic Excel feature that automatically makes you […] The post Dear Analyst #86: One Important Excel Feature to Know to Do Your Best Data Analysis appeared first on .
Dear Analyst #85: Preksha Kaparwan talks about her journey as a chef To CMO of a data analytics company
January 18, 2022 07:02 - 47 minutes - 43.8 MBYou might think not having a data background means it’ll be tougher for you to get a career in data. For Preksha Kaparwan, co-founder and CMO at Alphaa AI, the journey into data was anything but traditional. In this episode, Preksha talks about starting her career in the hospitality industry, falling in love with data […] The post Dear Analyst #85: Preksha Kaparwan talks about her journey as a chef To CMO of a data analytics company appeared first on .
Dear Analyst #84: Top 3 data analytics trends in 2021 and top 3 predictions for 2022
January 03, 2022 13:46 - 26 minutes - 25.9 MBUnlike the NBA, you can’t easily pick and choose the top “plays” of 2021 in the data analytics field like you can with basketball games. This list is by no means exhaustive and is just based on my reading of news and trends in the data analytics world. It’s easy to talk about big changes […] The post Dear Analyst #84: Top 3 data analytics trends in 2021 and top 3 predictions for 2022 appeared first on .
Dear Analyst #83: Cleaning up and doing an exploratory data analysis of all Friends episodes raw data in Excel
December 27, 2021 06:38 - 30 minutes - 28.9 MBI was playing around with a dataset on TikTok recently to show a PivotTable trick. The raw data is a list of all Friends episodes that have aired starting in 1994. I noticed that the raw data requires some cleanup so decided to take the dataset and to some cleaning operations and also try out […] The post Dear Analyst #83: Cleaning up and doing an exploratory data analysis of all Friends episodes raw data in Excel appeared first on .
Dear Analyst #82: Translating the best lines from The Godfather with Google Translate in Sheets
December 06, 2021 18:02 - 11 minutes - 10.5 MBI haven’t seen a good use case or template for the GOOGLETRANSLATE function in Google Sheets. I was inspired by Blake Burge’s Top 8 Google Sheets Tweet and thought a bit more about when you might use GOOGLETRANSLATE in Google Sheets. I suppose if you work as a translator or at the United Nations, you […] The post Dear Analyst #82: Translating the best lines from The Godfather with Google Translate in Sheets appeared first on .
Dear Analyst #81: How to hack award flights on Avianca Airlines with Google Sheets
November 22, 2021 06:22 - 34 minutes - 34.3 MBI love a good deal, especially when it comes to getting a good flight. Ever since I got into churning a few years ago (signing up for credit cards to get rewards), I started booking flights primarily with reward points from these credit cards. I spend more time searching for flights with good point redemptions […] The post Dear Analyst #81: How to hack award flights on Avianca Airlines with Google Sheets appeared first on .
Dear Analyst #80: Applying the rules of Squid Game to real-life games like negotiating a job offer
November 01, 2021 12:39 - 47 minutes - 46.5 MBI finished watching Squid Game a few weeks ago and still have all these swirling thoughts about the series. Through a few basic survival games, the show brings to light wealth inequality, capitalism, and other aspects of the human condition. Trying to find the loose threads between the show’s deeper meaning and data literacy is […] The post Dear Analyst #80: Applying the rules of Squid Game to real-life games like negotiating a job offer appeared first on .
Dear Analyst #79: How to finally AutoFit column widths in Excel for the Mac (and PC)
October 11, 2021 04:06 - 24 minutes - 23.9 MBWhen 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 .