A Google Sheets formula that handles an uncertain number of rows Taking a list of unknown length and reformatting it to a delimited list, adding a comma on the last item What is “Data Operations”? According to one pundit (me),…
A still from Apple’s 1984 Super Bowl commercial, directed by Ridley Scott If you’ve never seen this iconic 1984 ad for the Apple Macintosh computer, take a minute and watch. It will seem familiar to you, even 40 years after…
If you add a time series of the things that happened, you’ll get better analysis Time series measure the change from x to y by when: a value, demonstrated by its value at the beginning of a time range and…
What you get when you open a default FigJam template Let’s talk about prototyping. By design, it needs to be ugly. Prototypes are a quick way to share an idea, see whether a flow will work, and suggest something believable…
“A data model created by business users who want to describe their Salesforce data, illustration, movie poster” – created in Midjourney by PromptHunt.com If AI-driven image prompts could create an effective data model for business users to describe the data…
Photo by Jay Toor on Unsplash When you’re looking at data to inform a RevOps question (or any question), one of the key calculations you typically do is compare the average of a set of data to its median. Why…
Photo by Buzz Andersen on Unsplash It’s easy to get excited about a great idea. You’re going to change the world! When you get that epiphany and want to translate it into a working product, it’s important to keep the…
Is the app in the spreadsheet, or is the spreadsheet in the app? An example that surfacing app capabilities from a spreadsheet As a programmer, when you need new capabilities for an app or an environment that you are building,…
Imagine you can ask for anything you want. A picture of a unicorn eating a hamburger. An essay on the relative merits of a hot dog and whether it is a sandwich. A recipe that hallucinates a new combination of…
