TexasPGB logo artwork

Blog Layout

Finding Your Process Automation Sweet Spot

Aug 19, 2021

When it comes to automating processes around your business, it can simultaneously seem like everything can be automated, and absolutely nothing can be automated. As with many other things, the real answer is somewhere in the middle but can be a bit challenging to put your finger on. These projects usually start when someone at the strategic level of the organization has decreed that “we are going to automate!” and either they personally go on the hunt for what to automate or they hand it off to someone on their team to go do the leg work and come back with “automation” (maybe in a nice box with a bow on it). Sound familiar?

Whether you’re part of Executive Leadership or a Manager, having a decisive way to identify process automation opportunities, and more specifically find what we call the Process Automation Sweet Spot, will significantly increase the likelihood of success for your automation endeavors. To start down this path, we suggest coming up with a list of candidate activities around your company and assessing the Frequency and Complexity of each. Now, if that doesn’t mean much to you now, no worries, we’re about to explain it in more detail. 


When we talk about the Frequency of an activity, we refer to how often the team does this particular task. For example, if your team downloads the same content from a website once every hour, that’s probably a high-frequency activity. On the other hand, if your team creates a simple report one time per month, that would probably be considered a low-frequency activity. Frequency is relative for every organization; There’s no guideline or standard for what constitutes high-frequency or low-frequency. 


Shifting our focus to Complexity, we often like to think of how straightforward the task is and how concise the checklist would be if you wrote down the steps. Continuing with the example above, if you always go to the same website to download the data, and the button to download always says the same thing, and there are never any exceptions or deviations, then it’s probably a low complexity activity. On the other hand, if you have a laundry list of business rules, exceptions, or workarounds, it is perhaps a high complexity activity. 


Now that we’re thinking about Frequency and Complexity in the same terms, let’s review why they matter. Complexity is almost always directly related to the amount of investment required to build the automation. Frequency is a good indicator of how quickly you’ll be able to recover the investment you make in automating the process. When we overlay these two components in the graph below, we expose the Process Automation Sweet Spot – High-Frequency, Low Complexity activities with a big green checkmark.


Why is this the sweet spot? These are Low Complexity activities which means they can often be automated without significant investment. They are also High-Frequency activities which means you do them very regularly and get back a bit of value every time they happen, creating a return on your investment. Getting something back is crucial, and that’s why we find these to be the best candidates for automation, at least when you’re starting out. 


You may be wondering about the Low-Frequency, Low Complexity activities and the High-Frequency, High Complexity activities. These are denoted with a question mark, and sometimes they are good candidates for automation, particularly as you progress on your automation journey and learn more about how it can be beneficial. With Low-Frequency, Low Complexity activities, we find that some clients perform those activities just often enough that automating them makes sense for their business, and sometimes it doesn’t. With High-Frequency, High Complexity activities, we know that the complexity is likely to lead to a bigger investment in the development, but if they are happening really often (like multiple times per day, or multiple times per hour), then it can definitely make sense to pursue those. We recommend that you consider both of these categories on a case-by-case basis.


Finally, if you’re wondering about the big red X, that’s the no-go zone for automation. Those Low-Frequency, High Complexity activities are a trap where you’ll be led down a path of significant investment in development, only to find minimal if any return on it since you rarely do those tasks. Avoid these.


What next? Go find those High-Frequency, Low Complexity activities, the Process Automation Sweet Spot, and chase them down! If you’ve got questions along the way, set up time to talk with Patrick Boren, a Principal Consultant at TexasPGB, by scheduling directly on his calendar using the form below.

Share this post with others:
17 Aug, 2021
Data is everywhere. You’ve got a lot to focus on and it can be hard to stay on top of what’s going on with your business. Report creation in Excel is often time-consuming and can quickly become a nightmare. Modernizing your reports and streamlining your process with PowerBI to get more reliable and consistent reporting across all of your systems can be a game changer for your business. Read on to learn about three key acceleration tactics that our team uses on every implementation that we facilitate.
Infographic: How to Save time and Money with Microsoft Teams
By Patrick Boren 08 Feb, 2021
83% of knowledge workers require technology to work together. Microsoft Teams is a cloud-based collaboration and communication tool that lets workers share the right information to the right people all through one integrated platform. According to a Forrester report, The Total Economic Impact of Microsoft Teams, there are a variety of ways using Teams saves organizations time and money. Read and download the infographic to share here .
Top Features of the Power Automate App for Teams by Microsoft
By Patrick Boren 22 Jan, 2021
How to Get Started with the Power Automate app for Teams You can get started with Power Automate app in just 3 quick steps:  Click on the … in the left-hand corner of your teams browser Search for “Power Automate” Click on the Power Automate app icon and pin it to your left-hand Teams navigation panel
What Are Your TOP 3 Processes To Automate In 2021
By Patrick Boren 18 Jan, 2021
As mentioned, there are several options available for automating your business. One of our favorite low-code/no-code options is the Microsoft Power Platform. As a suite of 4 different tools, the Power Platform can automate routine tasks, customer support, data visualization, and more. A few highlights on the effectiveness of the Power Platform are:
Top Microsoft Solutions to Watch in 2021
By Patrick Boren 06 Jan, 2021
It is no secret that 2020 and the coronavirus pandemic altered the reality of doing business. These changes are showing little signs of letting up and a lot of the adjustments made to respond to a remote workforce may very well become a permanent feature in daily business operations. As business decision makers (BDMs) and IT decision makers (ITDMs) head into a new year it is important to keep an eye out for technology solutions that can further support these operational changes while increasing efficiency. This post briefly highlights the top 3 digital solutions we have our eyes on for 2021 and our Microsoft-based clients.
Video Webinar Introducing Microsoft 365 Dynamics Project Operations
By Patrick Boren 31 Dec, 2020
In our latest video series, Patrick Boren, Principal Consultant at TexasPGB, introduces the newest addition to the Microsoft Project family, Microsoft Project Operations. In this video Patrick discusses: What challenges Project Operations aims to solve What is Project Operations and common use cases for the tool Who uses Project Operations Upcoming "Day in the Life" Sessions Watch the video or read the condensed transcript below.
Top Tips on How to Use Microsoft PowerBI to Avoid Data Overload
By Patrick Boren 19 Nov, 2020
Having a wealth of data at your fingertips is great, but what happens when your data is so vast that it takes you years to make a key discovery? A friend of mine told me a story recently about an experience he had. His first company conducted a VP meeting every quarter – everyone scrambling to put together their presentations and make their case based on the data from Excel spreadsheets. Departments and information tended to be segmented into silos. While much of the data could be shared across the company, rarely was it compiled in a way to show how one area of the business could affect another.
Solution Design SharePoint vs Common Data Service
By Patrick Boren 12 Nov, 2020
If you are looking to migrate your data to Microsoft 365 there are two common methods to funnel your data - SharePoint or Common Data Service (CDS). SharePoint solutions take advantage of lists and libraries. Data is housed, originated, and manipulated entirely within the SharePoint platform. CDS solutions use both standard and custom entities to collect and house data that is then integrated across the Microsoft 365 platform. Below we will review a few ways each method is different and what you should look for before making a final decision for your data migration plan.
How managed service providers and technology consultants are different and why you need both
By Patrick Boren 15 Sep, 2020
When it comes to technology, do you have a one-size-fits-all vendor? In today’s world of cost cutting, we see more and more organizations that end up missing out on huge technology opportunities by assuming a single vendor can and will do it all.  As a technology consulting firm, we’re frequently asked “aren’t you the same as my managed service provider (MSP)?” Fortunately, for those that ask, we’re able to shed light on how a Technology Consulting Firm varies from an MSP.
5 Reasons why a downturn is the right time for digital transformation
By Patrick Boren 11 Sep, 2020
Do More with Less Fact: Digitally mature companies are 23% more profitable than their less mature peers. When business gets tight, cost management is critical. For most businesses, scaling back is a hard thing to achieve without sacrificing quality or convenience. Through technical improvements, such as process automation, you can optimize your operations while decreasing costs previously related to implementing manual tasks. Executives say the top 3 benefits of digital transformation are:
More Posts
Share by: