Skip to content

Charting the Course: Enhancing Executive Dashboards with Control Charts

Introducing Statistical Process Control: Your Data’s New Sheriff in Town

Enter Statistical Process Control (SPC), the John Wayne of the data world. Once upon a time, SPC was content to mosey around manufacturing floors, keeping an eye on widget production. But like a restless cowboy, it’s broken free from the factory corral and is now riding high across all sorts of business prairies. At its core, SPC is like a seasoned sheriff in a rowdy frontier town—it keeps the unruly, meaningless fluctuations in check so you can focus on the real troublemakers and gold strikes that truly deserve your attention. It separates the wheat from the chaff, ensuring that only the most important data points make it onto your Most Wanted list.

The star of SPC’s posse? The control chart. Think of it as the deputy’s badge for your metrics—not that your KPIs are wearing ten-gallon hats and spurs, mind you, but wouldn’t that be a sight? This shiny badge gives your data the authority to keep order in your business town, separating the law-abiding citizens (normal fluctuations) from the troublemaking outlaws (significant deviations) faster than you can say “there’s a new sheriff in town.”

The Science Behind the Charts

The secret sauce of control charts is a set of rules, most famously the Western Electric rules. And no, these have nothing to do with making sure your phone line is clear of static. These rules are more like the Sherlock Holmes of the data world, minus the deerstalker hat and pipe. They’re always on the lookout for suspicious behavior in your numbers, ready to dramatically declare, “The game is afoot!” when something’s amiss.

Let’s break down two of these rules using a hypothetical chart of monthly sales figures:

  1. The “One Point Beyond Zone A” Rule: Imagine your control chart as a dartboard. The bullseye is your average sales figure, and there are rings around it representing one, two, and three standard deviations from this average. We call the area beyond the third ring “Zone A”. If any single month’s sales falls outside this third ring (either way above or way below average), it’s like throwing a dart and missing the board entirely. This rule says, “Whoa there! Something unusual is definitely going on.” Maybe you had a surprise bestseller, or perhaps there was a major supply chain hiccup. Either way, it’s time to investigate.
  2. The “Two Out of Three Points in Zone B or Beyond” Rule: Now, let’s focus on the area between the second and third rings, which we call “Zone B”. This rule is like your data giving you side-eye. If two out of any three consecutive months fall in Zone B or beyond (remember, that includes our bullseye-missing Zone A), it’s suggesting a pattern may be emerging. It’s the chart’s way of saying, “I’m not saying there’s definitely a problem, but… there might be a problem.” This could indicate the start of a trend, like a gradual increase in market share or the early signs of a sales slump.

These rules help you distinguish between normal fluctuations (darts hitting all over the board) and potential issues that need your attention (darts consistently missing in a particular direction). They’re like having a wise old statistician whispering in your ear, “Hey boss, you might want to take a closer look at this.”

Versatility in Business Applications: The Swiss Army Knife of Analytics

Control charts are the Swiss Army knife of the business world, minus the tiny, useless scissors. They can slice and dice data from every corner of your empire. Customer satisfaction scores? Check. Sales performance? You bet. Employee turnover rates? Absolutely. They can even keep tabs on your social media engagement, though they can’t help you come up with witty tweets—that’s still on you, I’m afraid.

Implementation: Easier Than Assembling IKEA Furniture

Setting up control charts in your executive dashboard is easier than you might think—and definitely less frustrating than putting together that BJÖRKSNÄS bookcase. You start by picking a KPI that’s crucial to your business (no, the office ping-pong tournament standings don’t count). Collect some historical data, let your data team work their magic with averages and standard deviations, and voilà! You’ve got yourself a control chart. Just remember to keep it updated, or it’ll be about as useful as that dusty treadmill you bought last New Year’s.

The Tangible Benefits: Because Who Doesn’t Love Results?

Once you’ve got control charts in your arsenal, you’ll be spotting problems faster than a teenager spots a Wi-Fi signal. You’ll waste less time on false alarms, make decisions based on actual data instead of your gut feeling after that dubious sushi lunch, and generally look like the data-savvy boss you’ve always dreamed of being.

Riding Off into the Data Sunset: Success for Every Business Buckaroo

On the frontier of business, where data tumbleweeds blow across the prairie faster than a spooked mustang, control charts are your trusty steed. They’ll help you navigate the canyons of information overload, avoid the quicksand of false assumptions, and steer clear of the rattlesnakes of irrelevant data. With control charts as your sidekick, you’ll be striking gold faster than you can say “quarterly earnings report.”

So there you have it, pardner. Control charts: turning the wild data west into a well-managed ranch for nearly a century. They’ve come a long way from their manufacturing homestead, evolving into an indispensable tool for any modern-day business pioneer. Whether you’re running a small-town startup saloon or managing a corporate cattle empire, these charts offer a guiding star in the dark night of data.

In the OK Corral of modern business, you don’t want to be the one bringing a gut feeling to a data gunfight. So why not give control charts a spin of your six-shooter?

Now saddle up and ride out to chart your path to success—where your insights are as sharp as your spurs, your decisions as sturdy as your saddle, and your data points always fall within the corral (except when they’re supposed to be out rustling up new business, of course). Happy trails!

For more columns from Michael Bagalman’s Data Science for Decision Makers series, click here.

Contributor

  • Michael Bagalman

    Michael Bagalman brings a wealth of experience applying data science and analytics to solve complex business challenges. As VP of Business Intelligence and Data Science at STARZ, he leads a team leveraging data to inform decision-making across the organization. Bagalman has previously built and managed analytics teams at Sony Pictures, AT&T, Publicis, and Deutsch. He is passionate about translating cutting-edge techniques into tangible insights executives can act on. Bagalman holds degrees from Harvard and Princeton and teaches marketing analytics at the university level. Through his monthly column, he aims to demystify important data science concepts for leaders seeking to harness analytics to drive growth.

    View all posts
 
 

Related Content

A matrix-like image of code going down the information/data highway.
ecosystems

Innovation Community Resources on Analytics

As we continue to look back and explore the educational sessions at FEI 2024, All Things Innovation brings you an extra edition featuring additional r…

A graphic of a light bulb with a large number of machine gears (in place of the actual bulb).
partnerships

Innovation Community Resources on Process

All Things Innovation brings you a bonus edition featuring additional research, insights and resources centered on FEI 2024’s Process track. The tra…

A digital hand and a human hand touching through a futuristic background.
artificial intelligence

The Future of AI: A Roundtable Perspective

A key session at FEI 2024 earlier in the year was the GenAI Use Case Roundtables, where the entire show delegation shared opportunities and concerns w…

Like a star or comet shooting out rays of light beams.
transformational innovation

The First Steps to Transformational Innovation

All Things Innovation’s annual roundtable discussion, held at the Front End of Innovation (FEI 2024) conference, tackled the big question: “Is tra…

Big pile of light bulbs with one lit up.
human insights

Unlocking the Potential of Data Innovation

With FEI 2024’s focus on AI, human capabilities, and the data-innovation journey, among other topics, All Things Innovation had a chance to discuss…

Colorful USB plugs moving up like a chart from left to right.
innovation talent

Plugging into AI & ML Adoption

In the rapidly evolving landscape of consumer-packaged goods (CPG), the integration of artificial intelligence (AI) and machine learning (ML) is no lo…

A diamond and its facets.
technology

Finding the Value of Innovation

Gail Martino, VP Partnerships, 387Labs, was on hand at FEI 2024 as a moderator for the Brunch with the Bots presentation on the final day of the confe…

Three architects looking over blueprints at building site.
innovation team

Building the Right Data & Insights Team

You’ve heard it before: Data is the new oil. Just as crude oil needs refining to become valuable, data must be processed to unlock its potential. Ente…

The closeup of a jet engine.
data science

Creating a Culture of Experimentation

Many in the community feel that fostering a culture of innovation is paramount. A key to this is building a culture of experimentation. This stems fro…

An Olympic swimmer in the pool racing.
innovation strategy

Is Your Company Innovation Ready?

The term innovation readiness is often used to refer to an organization’s ability to develop and launch new products, services or ideas. Some may poin…

A sphere in space, with data points of light
artificial intelligence

Innovation in Action: Trends from FEI 2024

This past June, the vibrant city of Boston, known for its trailblazing spirit, became the epicenter of innovation as it hosted the Front End of Innova…

Crumpled paper on top of idea/innovation sketch pad with drawing of light bulb.
innovation culture

FEI 2024 Report: The Future of Innovation

A successful three-day event marked Front End of Innovation (FEI) 2024 in Boston, held June 10 to 12 at the Omni Hotel at the Seaport. A reenergized a…

Lifting a hand weight at the gym/fitness theme.
new product development

Harnessing the Power of Consumer Insights

Innovation doesn’t happen in a silo, and a great product or idea can only go so far on its own. Tapping into the pulse of your consumer is key to ta…

A hand holding a glowing green globe.
sustainable innovation

A Call for Sustainable Development

An MIT environmental engineering undergraduate from Jamaica, Runako Gentles uses his personal story to advocate for sustainable development to be inte…

Futuristic city at night with data points of light rising from the bottom.
artificial intelligence

Mapping Out the Data-Innovation Journey

This year, in our latest Innovation Perspectives Report, the editors of All Things Innovation brought together a cross-section of innovation, insights…

Bulletin board with post it notes. One in center says Make Things Happen.
innovation team

Managing Productive Innovation

Conservatively, I estimate that I’ve attended 20,000-plus meetings throughout my career. I’ll admit, many of them should have been replaced with email…

An accelerating speedometer.
data science

Accelerating a Data-Driven Approach

If we accept that data lies at the heart of marketing and business decision-making, a data-driven approach must be paramount in today’s environment….

a surface of black cubes rising from floor, varying heights, one stands out in yellow above the rest.
data science

Leveraging AI in B2B Respondent Insights

In the B2B marketing landscape, artificial intelligence has shown great potential. It is becoming an essential and advantageous tool, a tool which no…

coin operated binoculars and open blue sky
artificial intelligence

The Road to FEI24: Analytics for Innovation

Anu Sundaram, Vice President, Business Analytics, Rue Gilt Groupe, is planning an interactive analytics session for FEI 2024, taking place this June….

explorer in a cave
user experience

Applying AI to Anthropological Research

Agile research and methodologies are of primary importance to the innovation discipline, as they promote a more versatile, rapid, adaptive approach to…

Shopper in a grocery store.
risk management

8 Risks If You Don’t Have an AI Strategy

In the fast-paced world of Fast-Moving Consumer Goods (FMCG), where product life cycles are short and consumer trends shift with lightning speed, stay…

prompt engineering
artificial intelligence

Positioning the Role of Prompt Engineering

Prompt engineering is one of the latest buzzwords when it comes to artificial intelligence, but what is this evolving and complex job function? Some m…

data analytics

Powering AI-Driven Innovation

The advancements in artificial intelligence have rapidly impacted and transformed the business world around us. For insights and innovation, it has in…

data science

Finding Best Practices for Data Management

Data management is critical in today’s innovation and overall business environment. This ensures that data is collected, cleansed, analyzed and stor…

technology

Gaining an Innovation Edge with Automation

With the focus on how artificial intelligence, as well as digital transformation efforts, can help streamline operations, it’s worth another look at…

artificial intelligence

Advancing Universal Interaction

Artificial intelligence, specifically generative AI, has the potential to be a great equalizing disruptive technology of our time. While we are still…

analytics

How AI is Redefining Business Strategy

Over the last year, AI went from being the next big thing to being the Big Thing. In particular, Large Language Models (LLMs) from companies like Open…

innovation team

Winning the Innovation Strategy Game

We know that having a creative mindset can fuel innovation, and that fostering a culture of innovation is also important to get the job done. Yet ther…

innovation talent

Taking Next Steps with Innovation Talent

As we head into the new year, taking the next steps with innovation talent remains an important question to explore. With the competitive landscape in…

disruptive technology

Shaping the Future with Disruptive Technology

As we head into 2024, innovation of all types, most especially in technology, will continue to disrupt, transform and impact our lives, from the workp…

artificial intelligence

The Impact of AI on Innovation

Artificial Intelligence (AI) is having a profound impact and influence on a broad range of industries. From healthcare to publishing to industrial fie…

measuring innovation

Measuring Innovation Performance

Innovation can be a key component to drive a company’s success and performance, in both short-term and long-term initiatives. Yet many executives gr…

technology

Living in A Digital Transformation World

Digital transformation (DX) has been a hot topic in the innovation space for some time, but the term can be easily misunderstood as well. As we accele…

innovation team

The Finance Factor in Innovation

The finance function in an organization often gets tabbed as a bottom line-oriented, conservative department that more often than not stifles innovati…

innovation team

Setting the Strategic Direction

A chief strategy officer (CSO) is increasingly becoming a more relevant element to a research and development team in an organization. An innovation t…

optimization

Playing Moneyball for the Win

In the popular baseball movie “Moneyball,” the character Peter Brand (played by Jonah Hill) highlights the “epic failure” of MLB leadership in managin…

innovation analytics

Leveraging Data Analytics to Drive Innovation

Insights, data and analytics can often work in close partnership with innovation to drive product and service development. Indeed, supporting the inno…

data analytics

Diving Into Humanity-Centric Innovation

With the continued emergence and evolving development of artificial intelligence, there rises a question of how humans and AI can work together more e…

technology

15 Second Workday

This morning I generated 40 new product ideas with concepts and ad copy to accompany each.  It took 15 seconds. This is just a small fraction of what…

innovation leadership

Breakthrough Innovation

While the rest of the industry relies on iterative change, Alex Moyes explains the breakthrough innovation happening at Dominion Energy. “So Dominio…

innovation talent

Control The Sails

Although the world was affected heavily with change in the last few years, not much in the business world has changed as far as topics and issues go….

innovation talent

Innovation Culture

Innovation starts with the employees of an organization. As we know, the people that work for a business are some of its greatest assets. In today’s…

measurement

Measurable Innovation

Each company has their own KPIs that are important to their specific business in place to progress and be successful. Are people at the forefront of i…

innovation talent

Certain Uncertainty

Life is uncertain in every way. It’s always interesting to meet new people and try new things. On the other hand, attackers may sometimes appear out o…