How to Use Pivot Tables to Mine Your Data

December 19, 2011

To succeed at Six Sigma or any process improvement effort, you’ll often have to analyze and summarize text data. Most companies have lots of transaction data from “flat files” like the one shown below, but because the data consists of text and raw numbers, they sometimes have a hard time figuring out what to do with it. These examples use Excel along with QI Macros for Excel:

pivot table data in Excel