Blog

Latest Posts

It’s Hard to Do Data Analysis on Ugly Data… Part 2

People often get stuck before the “Analyze” phase of DMAIC because of ugly data. You can’t analyze data until it is in the right format for analysis. In this data about medications that might affect patient falls, we have to: Transpose the data Use Excel’s Text-to-column feature to split the meds into separate cells Use […]

Posted by Jay Arthur in Data Mining.

DayMinder Typos

I use a small DayMinder monthly calendar. I noticed that someone forgot to use spell check before it went to print. That must be expensive!   If you can’t spell the months correctly, how can I trust the rest of the calendar?

Posted by Jay Arthur in Six Sigma.

It’s Hard to Do Data Analysis on Ugly Data

I have found that people often get stuck before the Analyze phase of DMAIC because of ugly data.  You can’t analyze data until it is in the right format for analysis. In this example of patient falls data, we have to: Transpose the data Use PivotTables to summarize the data Use a c Chart to […]

Posted by Jay Arthur in Data Mining.

Measuring Six Sigma Success

This recent article talks about how GE measured Six Sigma success: “Engineers and scientists were measured on how many Six Sigma projects they completed during the year.” Since I know that 4% of the business is causing over half of the waste, rework and lost profit (the 4-50 rule), making everyone do “Six Sigma projects” […]

Posted by Jay Arthur in QI Macros, Six Sigma.

The Difference Between Lean Six Sigma Fundamentalists and Revolutionaries

Lean Six Sigma Fundamentalists believe: – Get management commitment – Train lots of black and green belts – Implement wall-to-wall floor to ceiling Lean Six Sigma Revolutionaries believe: -Engage informal leaders -Train money belts -Laser-focused, data-driven breakthrough improvements

Posted by Jay Arthur in QI Macros, Six Sigma.

Glitches are Opportunities

The next time you hit a glitch are you going to 0. Ignore it 1. Find a work around 2. Take heroic action to fix it. 3. Fix the glitch and then take the time to prevent it from ever happening again?

Posted by Jay Arthur in QI Macros, Six Sigma.

One-Third of Food is Lost or Wasted

As reported in the ISE magazine, the United Nations Food and Agriculture Organization reported that “one third of food produced in the world is lost or wasted, which affects not only world hunger but carbon emission, water and land use.” I was recently rereading Juran on Quality by Design (1992) in which Joseph Juran lists “high […]

Posted by Jay Arthur in QI Macros, Six Sigma.

Excel Column Charts Hide The Signal in Noise

The July/August 2017 HealthLeaders magazine had a series of charts about the impact of Adverse Events. In general, the magazine used column charts: But wouldn’t a Pareto chart illuminate the important adverse events more clearly? The first three accounted for over 57% of 2013 deaths.

Posted by Jay Arthur in Excel, QI Macros, Six Sigma.

Data Science is On The Rise

The Sept-Oct 2017 Harvard Business Review reports that the job market for data scientists is growing rapidly. Over 2.3 million of these jobs were listed in 2015. And the demand is expected to grow by 39%. But these positions are expensive and hard to fill. In a related column about how companies use big data, […]

Posted by Jay Arthur in QI Macros, Six Sigma.

HIMSS says Healthcare Needs Data Analysts Who Are Problem Solvers

This article discusses the need for data analysts in healthcare: http://www.himss.org/library/healthcare-needs-data-analysts-who-are-problem-solvers The QI Macros Data Mining Wizard makes it easy to crunch the data about medical mistakes and errors, denied claims, patient falls and whatever else you can find. Learn more here: https://www.qimacros.com/data-mining-analysis-excel/data-mining-wizard/  

Posted by Jay Arthur in QI Macros, Six Sigma.