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

excel data files exported from other system

Notes Exported from Tracking Systems

count words in Excel

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

Excel 2010-2019, Office 365:


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