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
Notes Exported from Tracking Systems
To access QI Macros Data Mining Tools, find the Data Mining sub menu.
Excel 2007, 2010, 2013, 2016:
Excel 2011 and 2016 for the Mac:
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.
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.
Use these tools to simplify comparing means and variances, doing regression testing and other key data analysis tools and techniques.
- PivotTable Overview
- Packaging Defects Example
- Denied Claims Example
- Emergency Room Example
- ICU Medications Example
View Data Mining Tools Tutorial - 14 minutes