QI Macros Data Mining Wizard

Complete Improvement Projects in Seconds
Using the Revolutionary New Data Mining Tool for Excel

How do you succeed in project after project with 100% success rate? Take out the guesswork!

Over the years, I've helped companies save millions of dollars by analyzing data from all kinds of systems—payroll, accounting, service orders, CRM and many more. The secret has always been to analyze the data using Excel PivotTables to summarize the data and then turn those summaries into control charts and Pareto charts.

data mining wizard excel

I finally realized that I shouldn't waste people's time teaching them how to do this if I can make Excel do it for them. That's why I have added a Data Mining Wizard to QI Macros Add in for Excel. It automates the creation of a PivotTable and all of the charts that can be derived from the data. That's right! It will examine your data, summarize it and create control charts and Pareto charts automatically!

Here's how it works


There are people in the Excel and Six Sigma communities that will think this is cheating! That it's too easy. So what? Ignore them and start creating million-dollar improvement projects.

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 to 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 Menu - QI Macros

Step by Step Overview 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 for data mining

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).
    QI Macros Control Chart from Data Mining
  4. Change the PivotTable and draw Pareto charts using the remaining columns.
    Pareto Chart from Data Mining QIMacros
  5. Drill down into Line 3 to look for more detailed, lower level Pareto charts.
    Second Level Pareto Chart of Data Mining QIMacros
  6. Create a fishbone (Ishikawa) diagram from the "big Bar" on the Pareto Chart.
    Fishbone Diagram from Pareto Chart Data Mining QI Macros
  7. So, now we can form a team to do root cause analysis to prevent it. Too easy!

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


What is Cool about QI Macros Data Mining Wizard for Excel?

I realized that this is what I was doing anyway when I found a table of data, so why not automate the analysis to save me time. Of course, if you want to do this on your own, you can use QI Macros PivotTable Wizard to summarize the data and then use control charts and Pareto charts to create the same improvement story.

Why Choose QI Macros Data Mining Software?

select the right control chart

Are You New to Data Mining and Six Sigma Projects?
QI Macros Data Mining Wizard Eliminates the Learning Curve!

If you've got raw data about defects, but don't know what to do with it, the Data Mining Wizard will do it for you. I've taken 25 years of hard won data analysis and Six Sigma experience and coded it into the software. The Data Mining Wizard will create control charts, Pareto charts and Fishbone diagrams from your data.


data mining wizard excel

Are You Already Using Data Mining?

The Data Mining Wizard, PivotTable Wizard and Word Count Wizard will accelerate your results. I used to spend hours and sometimes days creating PivotTables and charts. Now I can do it with one click of a button. I spend my time analyzing the results and making improvements, not figuring out what to do with the data.


compatible with Excel 2010-2019/Office 365 (PC) | 2016, 2019/Office 365 (Mac)

Is Most Your Data In Excel?
QI Macros Works Inside Microsoft Excel

You don't need to learn a separate software application to create Six Sigma projects. And whatever you create can be shared with anyone who has Excel!

QI Macros is compatible with Excel 2010-2019/Office 365 (PC) | 2016, 2019/Office 365 (Mac)


Unfortunately, the Data Mining Wizard is not functional in Excel 2016 Professional Plus, as this version of Excel does not respond to VBA code pertaining to PivotTables.

While we are currently awaiting a fix from Microsoft for this issue, note that all other functionality and tools found in QI Macros, except for the PivotTable Wizard and Word Count tool, are compatible with Excel 2016 Professional Plus.


Learn More...

Create these charts and diagrams in just seconds using QI Macros for Excel...