Blog

Latest "Data Mining" 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.

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.

Will Automation Steal Your Job? Skills to Beat AI

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 […]

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

New Year’s Resolution – Go On a Raw Data Diet

Most data is preprocessed or overprocessed. All the nutrients that you need to solve problems are gone. Solution: Go on a Raw Data Diet

Posted by Jay Arthur in Data Mining.

Nobody Wants to Read Your Spreadsheet!

Nobody wants to read your spreadsheet! No matter how hard you try to make it pretty, create great labels or whatever, the only person who can read your spreadsheet is a CFO or Excel spreadsheet geek. And the Excel geek is going to tell you 10 ways to make it prettier. The purpose of data […]

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