Data Operations

Posts about data operations, analytics, and organizational data management

175 posts

Using Substitute Textjoin And Counta

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),…

Future Proof Your Time Series Data

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…

Data Modeling for the Rest Of Us

“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…