KeyCuts's profile picture. We love data analysis, productivity hacks, and thinking critically | Excel training for businesses and organizations.

theKeyCuts.com

@KeyCuts

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

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


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


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…


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…


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


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


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


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.


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


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


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…


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


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


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


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


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


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…


Thinking about buying Grape Drink Purple Cover for Mac Excel? Read our latest review of the product by Kampus t. reviews.me/twitter_card?d… via @yotpo


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


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…


United States Trends

Loading...

Something went wrong.


Something went wrong.