Data Analysis Improvement Insights

Improvement Insights Blog

Posts tagged "Data Analysis"

Form Storm Norm Perform Takes Too Long!

Traditional Form-Storm-Norm-Perform models of team development take too long. Here’s how to collapse the time and skip right to perform.



“I was looking at myASQ, and somebody was asking about the four steps of Team development: Form, Storm, Norm, Perform. You know, if you do it traditional (how it usually was taught), it takes a long time for a team to form (come together), storm (fight each other a little bit), normalize their behavior (so they get productive).

“Well, I found that that takes too long. I can’t get to results that way. What I discovered was if I could do the analysis and figure out how to pinpoint where the problem would be, then I can figure out who ought to be on that team to solve that problem.

Posted by Jay Arthur in Data Mining, Improvement Insights, Jay Arthur Blog.

RRTs vs Code Blues – What is Your Data Telling You?

Sometimes your data seems to be telling you something counterintuitive. Here’s a healthcare example using Rapid Response Teams (RRTs) and Code Blues. What is your data telling you?



“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].

“Last week I got a call from a customer and they said, “Here’s some data and we need your help a little bit.” (This is rare, okay, but they did ask for help.) So anyway, the issue is in a hospital when patients’ respiratory [numbers] and everything else drops to zero, that’s what they call a Code Blue, right?

Posted by Jay Arthur in Improvement Insights, QI Macros, Six Sigma.

When You’re Stuck – Hire Help

Most of us are hesitant to admit that we don’t know how to do something. So we can waste a lot of time trying to learn how. But in business, that’s a foolish waste of time and money. Here’s why:



“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].

“Like many other people, I have a hard time asking for help. The other day, I was trying to work on something for our website: it was a process link to go out to the United Postal Service and get the Zip Plus 4 thing.

Posted by Jay Arthur in Improvement Insights.

Great IT PRO – 2/17/21 Webinar

Jay Arthur was the featured speaker for the Great IT Pro Webinar on 2/17/21. His topic was “Problem Solving With Data.” You may view the recorded video of Jay’s webinar below:



If you’re interested in learning more about QI Macros for Excel (the software Jay wrote and developed), click HERE and view the demo video in the yellow box. You may also sign up for a free 30 day trial of the software by filling out the form on that page next to the video, or by signing up at THIS link. If you’re interested in learning more about Jay’s ideas on Agile Lean Six Sigma, you can download a free brief summary of Jay’s ideas in his “Agile Lean Six Sigma Manifesto,” available at THIS link.

Posted by Jay Arthur in QI Macros, Service, Webinar.

Why Big Data is Bad for Small Business

There’s a lot of hype about Big Data, but approximately three-quarters of the money spent had no return on investment. There’s big profits in small data. Here’s what to do differently.



“Hi, this is Jay Arthur, author of “Lean Six Sigma Demystified” and the QI Macros [software].

“Big Data is actually bad for small business. Now, there was a lot of hype around Big Data, but it kind of crested about 2011-2012 and it’s falling down now because people are discovering that Big Data doesn’t always give you the answers you want. What you need [is] small data, and there’s big profits in small data.

Posted by Jay Arthur in Data Mining, Improvement Insights.

Take DM Out Of DMAIC

Most companies are drowning in data, so you don’t need to Define and Measure anything new. Take DM out of DMAIC to accelerate results. Here’s why:



“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].

“In the whole Six Sigma world, the DMAIC process, one of the things I’ve noticed is every company I’ve ever gone to… ever… has so much data they’re just… they’re drowning in their own data, and they don’t know how to analyze what they’ve got. And yet in DMAIC, we teach people to Define and then figure out something to Measure.

Posted by Jay Arthur in Improvement Insights.

Measure Success or Failures

Measure failures not success. Here’s why:

“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].

“Recently one of our users called up and asked me about showing percent compliance. You know, present success (in this case it was neonatal intubations – this is for healthcare). But the goal obviously is to get to 100% first-time success at intubating a preemie, right? So that would be a good thing.

“Now what most people do is they try and focus on the success side of this, so if you’re down here, you want to get up that-a-way, right?

Posted by Jay Arthur in Improvement Insights, Six Sigma.

Six Sigma Success Metrics

Most companies measure success of Six Sigma using simple, easy to understand metrics. Are you using these measures of success?

“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software]. Today I want to talk to you about success metrics.

“Back in the late 60s I was in high school. I had a paper route and this was during the Vietnam War, and every day I would fold 120 papers and deliver them. The headlines always on the Tucson Daily Citizen was that we’d killed so many Viet Cong and so many Americans had died, so we had this body count metric every single day, Monday through Sunday.

Posted by Jay Arthur in Improvement Insights, Six Sigma.

Cholera and COVID-19 Hot Spot Detection and Quarantine

There are COVID-19 hot spots and cold spots. How do we keep the cold spots open and detect and quarantine warming spots? Maybe statistical process control can help.

  denver covid case rate

“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].

“Back in the mid 1800s there was a cholera outbreak in London, and John Snow (not of Game of Thrones, but Dr. John Snow) said, “I think there’s a pattern here.” He went out and figured out that everybody who had cholera was getting water from the Broad Street pump. Back then, there was no indoor running water so you had to take your pail, go out to the pump and get your water for your home or your business or your restaurant.

Posted by Jay Arthur in Improvement Insights, Six Sigma.

How Long Should Lean Six Sigma Projects Take?

Should a project take 4-16 months or 4-16 hours? Should you measure projects with a calendar or a stopwatch? I think the answer is obvious, but here’s my take on it.

“Hi, I’m Jay Arthur. Every year, we exhibit at lots of conferences with QI Macros so I get to go to presentations by all kinds of folks. Now, last year I saw a presentation by some consultants who said they’d done some research into how long Six Sigma projects take. They found Six Sigma projects take anywhere from four months to 16 months.

“I [thought], “What? How’s that possible?” That makes no sense to me, because I’ve done multimillion-dollar projects in between 4 and 16 hours.

Posted by Jay Arthur in Agile Lean Six Sigma, Data Mining, Improvement Insights, QI Macros.