Data mining
Blog

Posts tagged "Data mining"

*Latest webinar: 11/6/19 QI Macros Webinar

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 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 Excel, QI Macros, Webinar.

1/8/19 Webinar

Almost 50 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 versions 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 “Find Tool” search feature or the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in QI Macros, Webinar.

QI Macros Upgrade 2017 V3

It took me 25 years to figure out how to make the QI Macros software do all this automatically, and now you can:
…analyze your data with the QI Macros Data Mining Wizard,
…have the QI Macros Chart Wizard choose which chart your need,
…allow the QI Macros Statistics Wizard analyze your data…

…ALL “AUTOMAGICALLY”! Upgrade your software to the latest version by 12/31/17, and take advantage of the $150 savings!

Posted by Jay Arthur in QI Macros.

Big Data Bust

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.

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

Signal versus Noise

“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.

 

Posted by Jay Arthur in Data Mining, Improvement Insights, Jay Arthur Blog, Six Sigma.

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:

  1. Transpose the data
  2. Use Excel’s Text-to-column feature to split the meds into separate cells
  3. Use QI Macros UnStack Columns tool to get all of the meds into a single column
  4. 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:

 

Posted by Jay Arthur in Data Mining, Improvement Insights.

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:

  1. Transpose the data
  2. Use PivotTables to summarize the data
  3. Use a c Chart to plot the data.

Posted by Jay Arthur in Data Mining, Improvement Insights.

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 is to provide insights for action, not just report past performance.

How Do I Know That Most Excel Users Try to Make Their Spreadsheets Readable By People?
According to Renu Davi, Sr. Program Manager for Excel, Microsoft tracks how people use Excel. The vast majority of the 650 million users use it for lists and reports.

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

Most Valuable Career Skills

This month’s issue of Money Magazine discusses the 21 Most Valuable Career Skills. At the top of the list, statistical analysis increasing pay by 6.1%. Right behind statistical analysis is Data Mining at 5.1%. It’s incredibly easy to learn these two skills using QI Macros and Six Sigma.

Also on the list, Customer Service Metrics (4.3%). I have found that the written comments in customer service systems can be easily analyzed using the QI Macros Word Count tool to identify the most common type of call or complaint. Then simple root cause analysis can reduce or eliminate those calls.

Business analysis (3.8%) is easy with QI Macros Control Chart Dashboards.

Posted by Jay Arthur in healthcare, Lean, Manufacturing, QI Macros, Service, Six Sigma.