theKeyCuts.com

We love data analysis, productivity hacks, and thinking critically | Excel training for businesses and organizations.

[theKeyCuts.com @KeyCuts]

Dear Analyst ep # 134: Film data analyst @stephenfollows talks about how he analyzed all Oscar speech to see if Harvey Weinstein was mentioned more than God. First time I've talked with someone who is actively using AI with Excel to clean data! https://t.co/VgnswRynn7

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #133: Back to doing a solo tutorial: How to check if a cell contains text from a list of values. In #googlesheets the formula gets complicated since it involves array formulas. I walk through 3 methods in this episode https://t.co/FYAW0Erd3M

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #128: Replay from a conversation I had with Neil Miller on the Citizen Development Live podcast about #citizendevelopment, building solutions with spreadsheets, and when to move off of spreadsheets: https://t.co/ZifCAPDFDJ

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. 127: Spreadsheets vs. @Atlassian @Jira: which one is better for your team? Inspired by conversations at #atlassianteam24. Also discuss the #econtalk podcast with @EconTalker & Jeremy Weber on why context is important in data analytics. https://t.co/P5zxXW2HaT

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #126: Executive director of the @DataVizSociety @abmakulec talks about data storytelling. She talks about creating COVID charts with Johns Hopkins Center for Comms and what questions to ask when creating a #dataviz. https://t.co/dLci4ENfk0

[theKeyCuts.com @KeyCuts]

Dear Analyst #125: How to use @spotify API data to find the most underrated @taylorswift13 song with Andrew Firriolo, senior data analyst at @buzzfeed. We discuss his methodology and the feedback he received from #Swifties https://t.co/ACfnLltVcO

[theKeyCuts.com @KeyCuts]

Training individuals at large companies on how to learn Excel and analytics tools varies by team. @Kolokolovalex discusses consulting with large companies and how company politics plays a role in deciding which analytics solutions get deployed. https://t.co/IHOPJQWyM2

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #123: @ben_wylie discusses how he got into data journalism, what makes a stunning data visualization, and some interesting visualizations he's built using NBA and rugby data.

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #122: In 2016, @uber China competed w/ @didiglobal on signing up new drivers, and at the center of it all was an online version of Excel @mattbasta created to calculate driver incentives. We also discuss working on @ibm TM1 FP&A platform. https://t.co/COwdFCR0SU

[theKeyCuts.com @KeyCuts]

Dear Analyst ep #121: Behavioral scientist @danariely fabricated survey data for one of his famous experiments in Predictably Irrational. This episode highlights a blog post from @DataColada analyzing the irregularities in the data. https://t.co/mR9AjJd8WM

[theKeyCuts.com @KeyCuts]

Dear Analyst #118: Learn about the experiments at @facebook / @Meta and analytics best practices to drive long term user value. Akos Lada is the Director of Data Science for Feed Ranking & Recommendations and he shares all about data science at Facebook. https://t.co/SyvHLsB14R

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #117: New 2023 Google Sheets functions for transforming data. Also discuss @DefiantNews with @synthetix founder Kain Warwick on crypto/addiction & Forward Thinking CFO @Numeritas ep. #8 with @brijones on Excel vs. verticalized software https://t.co/RBeogifBKC

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #116: Breaking down @Microsoft Copilot for @msexcel demo and whether it will replace analysts. Also discuss People Make Games video where @chrisbratt @Quinns108 talk about the origins of @FMWC_ and solve a question from the competition https://t.co/t7qvMIhp1H

[theKeyCuts.com @KeyCuts]

Dear Analyst ep #114: How a small real estate company uses modern data tools just like the big enterprises. Doug Walters from Elite Development Group discusses how they started with Google Sheets and moved to @fivetran, @getdbt, @awscloud, @Sisense & more: https://t.co/toaXKgkYIA

[theKeyCuts.com @KeyCuts]

Dear Analyst #113: The top 5 data analytics predictions for 2023. Some predictions include #AI, data privacy, & data literacy skills. Also discuss @MakingSenseHQ podcast ep #299 where Sam Harris talks with @EconTalker about decision making and uncertainty. https://t.co/xKbOy82fUK

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #112: What is #businessoperations and how do you get into this role as an analyst? I discuss the world of processes and building solutions with my friend @ArianaCofone on her new podcast Secret Ops: https://t.co/cy2EYcHTYw

[theKeyCuts.com @KeyCuts]

Dear Analyst ep #111: Korhonda Randolph is a senior IT manager. She discusses why master data management is important for enterprises. She talks about creating business rules at @AutoTrader_com & helping with the merger between BB&T and Suntrust Banks: https://t.co/NkLJzCVEJJ

[theKeyCuts.com @KeyCuts]

Thinking about buying Grape Drink Purple Cover for Mac Excel? Read our latest review of the product by Kampus t. https://t.co/SoXMh1Esqf via @yotpo

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #110: How do you fill values down in a column? This is re-broadcast of a presentation I gave at the Vancouver #PowerBI & #Excel User group hosted by @kpuls in Apr 2021 going through a VBA and Google Apps Script for filling values down https://t.co/JXeXik9cmW

[theKeyCuts.com @KeyCuts]

Dear Analyst ep. #109: @nawaz2112 does product/analytics mgmt at @JNJNews & he talks about supply chains, data strategy, and vaccine distribution in this episode. Also chat about @Hanselminutes ep #831 with @randommood of @fastly about systems thinking: https://t.co/jxR2P4Ch7M