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.
Latest "Data Mining" Posts
More than 40 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.
Out of Work? Need a job? Want to become indispensable to your employer?
Learn the data analysis skills for problem solving (a.k.a. Lean Six Sigma). Do it now. It’s Free!
Click here to get started: www.lssyb.com
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and the QI Macros [software].
“I don’t know about you, but right now, I’m staying home because of the directives around COVID-19. I know there’s a lot of people out there who have been displaced and are out of work, and now might be a good time to learn a new skill. I can tell you: being able to do some data analysis that results in problem solving is a skill that every, every, every business wants.
Too many quality professionals are clinging to the way things have always been done. There’s some sort of taboo about doing things quickly and easily. What are the differences between 20th and 21st Century Quality? Watch and find out:
A recent TED video showed that Big Data is a $122 Billion Dollar business, but 73% of projects failed to return a profit. That’s a one-sigma performance. You don’t need big data. You can get big profits from small data.
“Our evolutionary instincts sometimes lead us to see patterns when there are none there. People have been doing this all the time – finding patterns in random noise.” – Tomaso Poggio
People just need a way to separate the Signal from the Noise.
Here are some insights from the book by Nate Silver.
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 QI Macros UnStack Columns tool to get all of the meds into a single column
- Use QI Macros Data Mining Wizard to create a PivotTable and Pareto chart of medications involved in patient falls
You can watch the video below:
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 plot the data.
The March-April 2017 issue of HBR has a survey of 1770 managers in 14 countries. When asked to identify the top 3 skills needed, the managers identified two that are important to quality:
- 31% of managers said Data Analysis and Interpretation
- 20% said Quality Management and Standards
QI Macros New Data Mining Wizard can dramatically accelerate anyone’s ability to analyze and interpret data.
Quality management is process management and statistical process control (SPC). QI Macros can do that too.
People skills were another key focus: social networking, people development, coaching and collaboration.
Learn more about people here: https://www.qimacros.com/knowware-articles/teamwork/
Most data is preprocessed or overprocessed. All the nutrients that you need to solve problems are gone.
Solution: Go on a Raw Data Diet