Reliable Six Sigma & SPC Excel Add-in
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 […]
Continue Reading "It’s Hard to Do Data Analysis on Ugly Data… Part 2"
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?
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 […]
Continue Reading "It’s Hard to Do Data Analysis on Ugly Data"
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” […]
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
Continue Reading "The Difference Between Lean Six Sigma Fundamentalists and Revolutionaries"
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?
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 […]
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.
Continue Reading "Excel Column Charts Hide The Signal in Noise"
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, […]
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/
Continue Reading "HIMSS says Healthcare Needs Data Analysts Who Are Problem Solvers"
Read What Others Say
- CNET Five Star Review
- Industry Leaders
- Our Customers
KnowWare International, Inc.
2696 S. Colorado Blvd., Ste. 555
Denver, CO 80222 USA
Toll-Free: 1-888-468-1537
Local: (303) 756-9144
© 2017 KnowWare International Inc. All Rights Reserved. Legal Information.