Is There a Million Dollar Improvement Project Lurking in Your Data?

• Saved $20 million in postage expense
• Save $16 million in adjustment costs
• Reduced order errors in a wireless phone company from 17% to 3% in just four months saving $250,000 a month in rework.
• Reduced denied insurance claims in a healthcare system that saved $330,000 a month with simple process changes that could be implemented immediately.

PivotTables can take up to 65,000 rows of line-by-line transaction data and:

• Count the occurrences of a keyword, phrase or number
• Sum or Average Numbers
• Turn Raw Data Into Knowledge
• Help Drill Down into Mounds of Data

This kind of analysis is almost impossible to do by hand, but PivotTables can do it in seconds.

Once summarized, it's easy to draw control charts, pareto charts and other charts from the PivotTable using the QI Macros.

• Identify the kind of data to analyze with PivotTables
• Use PivotTables to summarize your data
• Use the QI Macros to generate the control charts, pareto charts and fishbone diagrams needed for your Million Dollar Improvement stories.

The video includes several examples from healthcare and manufacturing.