theKeyCuts.com @KeyCuts

We love data analysis, productivity hacks, and thinking critically | Excel training for businesses and organizations. thekeycuts.com NYC Joined November 2012

Tweets

599
Followers

303
Following

39
Likes

19K

theKeyCuts.com @KeyCuts

5 months ago

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! ow.ly/rUrx50VoRAk

0 0 1 22 0

theKeyCuts.com @KeyCuts

9 months ago

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 ow.ly/X7Pm50UjoiT

0 0 0 34 0

theKeyCuts.com @KeyCuts

a year ago

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: thekeycuts.com/dear-analyst-1…

0 0 0 22 0

theKeyCuts.com @KeyCuts

a year ago

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. thekeycuts.com/dear-analyst-1…

0 0 0 43 0

theKeyCuts.com @KeyCuts

a year ago

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. ow.ly/6Bxj50Rg635

0 0 1 43 0

theKeyCuts.com @KeyCuts

a year ago

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 ow.ly/OIkP50R0XIo

0 0 0 49 0

theKeyCuts.com @KeyCuts

2 years ago

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. ow.ly/XOZe50QxTFF

0 0 0 31 0

theKeyCuts.com @KeyCuts

2 years ago

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.

0 0 0 59 0

theKeyCuts.com @KeyCuts

2 years ago

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. ow.ly/2YPo50QfA0C

0 0 0 49 0

theKeyCuts.com @KeyCuts

2 years ago

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. ow.ly/R8fY50PZLBU

0 0 0 66 0

theKeyCuts.com @KeyCuts

2 years ago

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. thekeycuts.com/dear-analyst-1…

0 0 0 63 0

theKeyCuts.com @KeyCuts

2 years ago

Dear Analyst ep. #117: New 2023 Google Sheets functions for transforming data. Also discuss @DefiantNews with @synthetix_io founder Kain Warwick on crypto/addiction & Forward Thinking CFO @Numeritas ep. #8 with @jones206 on Excel vs. verticalized software ow.ly/LNuj50Ovh4t

0 0 0 77 0

theKeyCuts.com @KeyCuts

2 years ago

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 ow.ly/F0w550NsX39

0 0 0 62 0

theKeyCuts.com @KeyCuts

3 years ago

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: ow.ly/2woA50MssrI

0 0 0 64 0

theKeyCuts.com @KeyCuts

3 years ago

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. ow.ly/M5RM50McBBb

0 0 0 83 0

theKeyCuts.com @KeyCuts

3 years ago

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: ow.ly/PwIt50M6REU

0 0 0 41 0

theKeyCuts.com @KeyCuts

3 years ago

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: thekeycuts.com/dear-analyst-1…

0 0 9 0 0

theKeyCuts.com @KeyCuts

3 years ago

Thinking about buying Grape Drink Purple Cover for Mac Excel? Read our latest review of the product by Kampus t. via @Yotpo

0 0 0 0 0

theKeyCuts.com @KeyCuts

3 years ago

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 ow.ly/b2NJ50LJLim

1 1 2 0 1

theKeyCuts.com @KeyCuts

3 years ago

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: thekeycuts.com/dear-analyst-1…