KeyCuts Profile Banner
theKeyCuts.com Profile
theKeyCuts.com

@KeyCuts

Followers
304
Following
19K
Media
28
Statuses
599

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

NYC
Joined November 2012
Don't wanna be here? Send us removal request.
@KeyCuts
theKeyCuts.com
9 months
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!
thekeycuts.com
Stephen Follows is a film data analyst and he shares an Oscars project where he analyzed speeches to see how often God and Harvey Weinstein are mentioned.
0
0
1
@KeyCuts
theKeyCuts.com
1 year
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
Tweet card summary image
thekeycuts.com
There are times when a problem nags at you like a pebble in your shoe. Even when you’re not working on the problem itself, you’re thinking about the problem which make it even worse. Rarely do I come...
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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:
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
1
@KeyCuts
theKeyCuts.com
2 years
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
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
2 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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:
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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.
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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:
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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:
0
0
9
@KeyCuts
theKeyCuts.com
3 years
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
0
0
0
@KeyCuts
theKeyCuts.com
3 years
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
1
1
2
@KeyCuts
theKeyCuts.com
3 years
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:
0
1
1