Data Mining Wizard Step-by-Step Video and Example

Learn what the data mining wizard can do for you.

What are Customers saying about our Data Mining Tool?

"I was very well impressed with the functionality of QI Macros Data Mining Wizard. This certainly saves time and cuts down the chart populating process substantially. I will be recommending this tool to my colleagues here at work and within the ASQ leadership community."

- Jerrod Higgins
Quality Engineer

Where Do I Find QI Macros Data Mining Wizard?

You'll find the Data Mining Wizard in the Data Mining tools section of the menu:

data mining wizard in excel

Step by Step Example of the Data Mining Wizard

All you need is some data in Excel. Just select two column headings (preferably a date and currency, number or text). In this case it's a date and lost time due to some sort of failure:

Excel table of data

Then just click on the Data Mining Wizard. It will:

  1. Analyze the entire table to determine if the field contains dates, dollars, numbers, text or sentences.
  2. Use Excel's PivotTable tool to summarize the data.
  3. Draw a control chart using the selected fields (one must be a date, not just Jan/Feb/Mar):
  4. control chart created by data mining wizard

  5. Change the PivotTable and draw Pareto charts using the remaining columns:
  6. pareto chart by line

  7. Drill down into Line 3 to look for more detailed, lower level Pareto charts:
  8. Line 3 Pareto by type of defect

  9. Create a fishbone (Ishikawa) diagram from the "big Bar" on the Pareto Chart:
  10. fishbone diagram line 3 folded flaps

  11. Repeat the analysis for other Pareto charts and fishbone diagrams.
  12. Summarize the analysis, charts and possible improvement projects in one worksheet:

    summary of charts and improvement projects

That's all there is to it. Click on two column headings and click on the new QI Macros Data Mining Wizard.

Learn More...

Other Reasons to Choose QI Macros Excel Add-in



  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free