Data Mining and Analysis Tools for Excel

Analyze Your Data Quickly and Easily with these QI Macros Tools

You'll Save Time and Look Like an Expert

Customers tell us half the battle of meaningful data analysis is to get their data in a usable format.

  • Do you struggle with Excel's Pivot Table function?
  • Is your data buried in flat transaction files or text files like the ones below?
  • Do you struggle to turn this kind of data into actionable improvement stories?

Data Exported from Tracking Systems

data files exported from tracking systems

Notes Exported from Tracking Systems

count words in excel


To access QI Macros Data Mining Tools, find the Data Mining sub menu.

Excel 2007, 2010, 2013, 2016:

data mining tools for Excel

Excel 2011 and 2016 for the Mac:

excel data analysis tools in QI Macros


Data Mining Wizard

This tool will analyze an entire table of defect data using PivotTables, control charts and Pareto charts. It will create all of the charts necessary to develop a rock-solid, bullet-proof business case for change.


PivotTable Wizard

Excel Pivot tables can be hard to learn but they are a snap with the QI Macros. Just select up to four columns of data and then click on the QI Macros PivotTable Wizard to create a PivotTable in Excel.

There are million dollar improvement projects lurking in this kind of data. Are you missing out on huge opportunities?


Word Count Wizard 

Counts the number of times a word or two-word phrase appears in comment data collected by employees, such as call center reps. Use it to summarize raw text data and then create pareto charts.

Want to know what customers are peeved about? Use Word Count to find out!


Stack and Restack

Changes how your data is organized. You can increase the number of columns (e.g. 1 to 2, 1 to 4, 3 to 5, etc.) or you can decrease the number of columns (e.g. 4 to 1, 4 to 2, 3 to 2, etc.)


Paste Link/Paste Link Transpose

Excel allows you to either Paste Links to data or Transpose your data, but not both at the same time. Use QI Macros to do both. QI Macros Paste Link and Paste Link Transpose also use formulas to prevent putting zeros instead of blanks in linked cells.

Use these features to create the links from existing data to the QI Macros Lean Six Sigma chart templates to simplify reporting.


Statistical Tools for Hypothesis Testing

Use these tools to simplify comparing means and variances, doing regression testing and other key data analysis tools and techniques.


Case Studies...

View Data Mining Tools Tutorial - 14 minutes

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!