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 […]

The post Dear Analyst #134: How Stephen Follows used AI to decode the Oscars and film data to debunk the film industry appeared first on .

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 […]

The post 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) appeared first on .

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 […]

The post Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty appeared first on .