Struggling with How to Analyze Your Data in Excel?

QI Macros has easy to use data mining tools to help!

Customers tell us that half the battle is figuring out what to do with their data.

  • 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?

Structured Data Exported from Tracking Systems

excel data files exported from other system

QI Macros Improvement Project Wizard Results

Improvement Project Wizard

Unstructured Data Exported from Tracking Systems

count words in Excel

QI Macros Word Count Wizard Results

Word Count


QI Macros Data Mining Tools can be accessed on a tab we add to Excel's menu:

Excel 2013-2021, Office 365:

data-mining-excel


You'll Find These Easy to Use Data Mining Tools in QI Macros

Improvement Project Wizard (formerly Data Mining Wizard)

Analyzes an tables of defect data using PivotTables to create Improvement Projects with control charts, Pareto charts and Fishbones.

Creates 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 QI Macros PivotTable Wizard to create a PivotTable in seconds.

There are million dollar improvement projects lurking in your data. Don't miss out on these huge opportunities.

Word/Number Count Wizard

Counts the number of times a word or two-word phrase or number appears in text/number data. Use it to analyze employee feedback, call center notes, customer reviews and more. Easily create Pareto charts, too!

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

Unstack, Stack and Restack

Changes how your data is organized.

For example take a 6 x 6 matrix of data points and stack or restack it into as many columns and rows as you want (e.g. 4 x 9, 3 x 12; 18 x 2, etc.)

Stack and Unstack by labels or subgroups as well.

Paste Link/Transpose

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

Use Paste Link / Transpose to link existing data to QI Macros Lean Six Sigma chart templates to simplify reporting.

View Data Mining Tools Tutorial - 14 minutes

QI Macros Draws These Charts Too!