Tracking progress towards your goals with scorecard snapshots

In order to effectively close the gap between where you are now and where you want to be, you need to know that the gap exists and how big or small it is. One way to do this is with a reporting tool called a scorecard. Much like the checked and unchecked items on a to-do list, a scorecard gives you a snapshot of the gap between where are you now and a target, where the target can be a growth goal you’ve set for yourself, or a projection of where you think you’ll be by a certain date, all things considered.

Read More

Analyzing time spent: Time management with box and whisker plots

We all know that there are only so many minutes in a day, and that goals like being more productive and effective hinge on things like better time management, that is, working smarter not harder. This is particularly true if you think you’ve got a pretty standard process in place. In this post, I’m going to demonstrate a visualization tool called a box and whisker plot. This tool will help you determine how long you can typically expect your standard process to take, and how to spot when there’s enough variability to say that it’s time to reexamine what you’re doing, so you can:

  • streamline a process for yourself, or
  • identify when it’s time to schedule a training or other intervention for your staff.

If you can find the middle thing in a list, you can do this time analysis.

Read More

Using big data to generate content ideas | A SOP Story

TL;DR? Big data knows what questions people have, and you can capitalize on that to generate an endless list of answer-focused content ideas that draw from and showcase your experience, knowledge, and expertise. Scroll down to the section titled ‘Bringing it together’ for a quick list of the steps. Scroll back up for the nuance.

There’s nothing new under the sun, so what could you possibly have to offer the world that hasn’t been addressed before?

I’m always a big advocate of asking people for help when I get stuck, and, as it turns out, people are telling you what they want you to talk to them about all of the time. If you’re systematic about how you listen, you’ll build up quite a data store to flip through the next time you’re missing your muse and staring down a blank page and a deadline.

Read More

How to design dashboards for data insights for business decisions

You want data insights at a glance, but it’s hard to digest and process a large volume of data, and you’re creating and collecting more data all of the time. You’re suffering from DRIP: you’re data rich but information poor. To get information, you turn to dashboards, but, if you don’t design them correctly, you can become dashboard rich but information poor, what I’ll call DRIP 2.0.

In this post, I’ll talk through 3 steps, with guides, for designing dashboards to generate insights for business decisions while all forms of DRIP.

Read More

Content packaging tips for click-worthy YouTube videos | A SOP Story

TL;DR? You can grow your YouTube channel without falling prey to cheap clickbait tricks and other “dark side” habits; the secret is providing value with your content and being strategic with your content-packaging SOPs. Scroll down to the Video Packaging Essentials Checklist for some content packaging points for your own YouTube upload checklist.

Read More

3 ways to use surveys to quickly figure out your next step when you don’t know what to do

How do you choose your next step? You’d like to do more of what’s working, but sometimes you’re not sure what parts of what you’re doing are working, or whether that pivot you’re considering might resonate with your target market, so you’re not sure what you should do more of or where to focus your efforts. In this post, I demonstrate three ways to use surveys to quickly get the data you need to make an informed next step.

Read More

How I adapted my in-person presentation SOPs for a virtual world | A SOP Story

This is a story about how I pulled together my historical data and my company’s philosophy and mission statements to adapt and generate virtual presentation SOPs for the pandemic and beyond.

Read More

Improve data integrity, data quality, and business insights with standard operating procedures (SOPs)

Is your data worth tracking? This is a question about the quality and integrity of your data – its accuracy, completeness, and fit with your use cases. And it’s an important question to consider, because low quality data can mean that your business insights are ill-informed. I’ve covered some of these points in my posts on clean data and data classification. In this post, I’m going to focus on how standard operating procedures, or SOPs for short, can help you improve the quality and integrity of both your data and your business insights.

Read More

Choosing the “right” visualization: A diversity, equity, and inclusion example

When we talk about Diversity, Equity and Inclusion (DEI) efforts, we frequently turn to the data to see how we’re doing relative to our own internal goals, and, as possible, how our efforts and relative success rates compare to those in our local communities and others in our industries. That is, we typically talk and think in terms of benchmarks and progress towards a target percentage. But we don’t just need to wrangle and analyze the data. We also need to communicate the findings of the analysis so that we can figure out what to do next, and this is where choosing the right visualization comes in. In this post, I discuss how different visualization choices enable different understandings of the data, and different conversations and decisions around the data.

Read More

What counts as clean data? It depends…

We’ve all been told, ad nauseum, that it’s important to have clean data, and, if you’ve looked into it, you know what it can cost to have someone clean up your dirty data. But what does it mean to say your data is clean? In this post, I provide a definition, and discuss why someone else’s clean data might not be clean for you.

Read More