Splitting Costs With Friends Just Got Easier In A Spreadsheet [+Template]

How many times have you gone on a group trip with friends, and figure out the costs at the end of the trip? Maybe one person pays for the hotel, one person pays for the rental car, and someone else pays for the dinners. Or maybe one person pays for everything, making splitting costs much […]

Dear Analyst #134: How Stephen Follows used AI to decode the Oscars and film data to debunk the film industry

Ever wondered if Hollywood’s magic is just smoke and mirrors, or if there’s actually some cold, hard data behind those blockbuster hits? I sat down with Stephen Follows, the film data analyst who’s basically Indiana Jones, but instead of chasing ancient artifacts, he’s digging up the buried truths of the movie industry. We’re talking about […]

Dear Analyst #133: Find or check if a cell contains text from a list of values or partial matching text in a list (3 methods)

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 across a Google Sheets/Excel task I cannot solve with formulas, but this one evaded my extensive knowledge […]

Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty

When you think of your data warehouse, the “semantic layer” may not be the first thing that pops in your mind. Prior to reading Frances O’Rafferty‘s blog post on this topic, I didn’t even know this was a concept that mattered in the data stack. To be honest, the concept is still a bit confusing […]