QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

8/11/20 QI Macros Webinar

Over 80 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent releases of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

NAHQ NEXT 2020 HQ Showcase – Jay Arthur

If you’re a registered NAHQ Next 2020 attendee, you can view Jay Arthur’s showcase until October 31, 2020. 1. Click on the link below. https://www.webcastregister.live/nahq2020/welcome   2. Click on the NAHQ Next top banner to log in. It will take you to the page below. Log in with your name and email address: nahq   3. Once you’re logged in, visit the On-Demand Sessions and scroll to the very bottom to view Jay’s session, “Zero Harm and the Trillion Dollar Prescription.” nahq

Posted by Jay Arthur in Agile Lean Six Sigma, Healthcare, Jay Arthur Blog, QI Macros.

7/7/20 QI Macros Webinar

Over 80 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent releases of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

COVID-19 Cases by Type of Facility

The New York Times published a list of cases by facility. I tweaked it to get Pareto Charts of the biggest problems. Nursing homes and rehab facilities were 64% of the total, then prisons and food processing (e.g., beef, pork, poultry, etc.).

cases by type of facility

facility related cases by state

Posted by Jay Arthur in Agile Lean Six Sigma, Jay Arthur Blog, QI Macros.

The Cost of Lean Six Sigma Training

Traditional Lean Six Sigma Training takes weeks when it’s possible to train people and get results in one day. Here’s why it costs so much to train people using last century strategies:

“I want to talk to you about the economics of a Six Sigma class.  All right, so as much as I hate pie charts, I’m going to use one to demonstrate this.  Let’s say you have a classroom and let’s say you have 20 odd people or something go in there.  Now, I can tell you in advance every class is filled with three types of people:  Prisoners, Vacationers and Learners. 

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

Skipping Stones or Diving Beneath the Surface of Your Business?

Are you skipping Six Sigma stones across the surface of your business or are you finding people who take to it like a duck to water. People who can dive beneath the surface to find the invisible low-hanging fruit?

“Have you ever skipped a rock across a lake? Maybe the first time you threw it out there it just went “sploosh.” Then you figured out that flatter rocks skip better, so you started throwing them out and they’d go “skip-skip-sploosh,” or maybe get three or four or five “skip-skips” and “sploosh.”

“Then a duck came flying in, put out its landing gear and just kind of eased into the water.

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

6/9/20 QI Macros Webinar

Over 140 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent releases of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

  If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

Root Cause Analysis in the Time of COVID-19

That's root cause analysis: What are the common patterns? Where's the Pareto principle?

Posted by Jay Arthur in Healthcare, Improvement Insights, QI Macros.

5/14/20 QI Macros Webinar

Over 120 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent releases of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

  If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

Create a COVID-19 Control Chart Using QI Macros

Control charts offer a promising way to analyze COVID-19 Data. Learn where to get the data, how to mine it and how to chart it in this video.

Posted by Jay Arthur in Ask Jay, Data Mining, QI Macros, Six Sigma.