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
QI Macros add-in for Excel installs a new tab on Excel's menu:
Excel 2013-2019, Office 365:
You'll Find These Easy to Use Data Mining Tools in QI Macros
Analyzes an entire table of defect data using PivotTables, control charts and Pareto charts.
Creates 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 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.
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!
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.
- PivotTable Overview
- Packaging Defects Example
- Denied Claims Example
- Emergency Room Example
- ICU Medications Example
View Data Mining Tools Tutorial - 14 minutes
Other Reasons to Choose QI Macros
- Only $299 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free