Data Operations

Posts about data operations, analytics, and organizational data management

175 posts

3 Quick Ways to use Pivot Tables

Photo by Edgar Chaparro on Unsplash One of the fastest and best ways to start understanding a dataset is to look at it using a pivot table. Pivot tables are a feature in most spreadsheet applications that summarize data, analyze…

Preparing for growth before it happens

Photo by Daniel Öberg on Unsplash One of the most challenging things thinking about scale in a 0-1m company (or a 1-10m, or a 10-100m) is the difference between where you are right now and the place you’d like to…

Salesforce reports are a major headache 🙈

Photo by Anne Nygård on Unsplash Ask almost anyone who uses Salesforce (or administers it) how they use reports. The answer usually includes some combination of the following: “Ugh. That’s hard. We do simple reporting in SFDC and more complicated…

Handshakes between teams are state machines

Photo by Simon Kadula on Unsplash “Can you create that report for me?” “Is that data loaded yet?” “Do you know what went wrong?” These are all simple (or not so simple) examples of interactions between team members that can…

Connecting things with twist ties and grit

Photo by Lucian Alexe on Unsplash If you have a comment or are interested in sponsoring, hit reply. Integration in SaaS software is a hot topic. With the right connectors and experience, you can bring almost any data to your…

Applying Mise en Place to Data Operations

Photo by Rudy Issa on Unsplash “Mise en Place” is a French culinary term for putting everything in its place. It’s a way to prepare your kitchen for cooking, and more importantly, a technique to make it possible for you…

Even low-code workflows can be simpler

Photo by Danae Paparis on Unsplash I’d be the first person to tell you that I am a utilitarian code builder rather than an elegant software developer. That means when I build workflows I keep building until they work, and…