PivotTable Wizard and Data Transformation Tools

Find the Invisible Low Hanging Fruit

Lesson  5

Days Left in Your Trial

16

In This Issue
Data Transformation Tools
Watch Video Examples
Download Free Resources
Buy Now
View Other Lessons
Get the Most Out of Your Trial With These Free Resources
Thank You for Evaluating the QI Macros,


You've probably heard people talk about the "low-hanging" fruit just waiting to be plucked by Six Sigma. Sadly, most people don't know how to find the low-hanging fruit because its invisible.

Many of our customers tell us that half the battle of meaningful data analysis and chart creation is to get their data in a usable format. Is your invisible low-hanging fruit buried in files that look like this?  


Every multi-million dollar project I've ever worked on began with PivotTable analysis to find the low-hanging fruit. Believe me, it's out there.

Imagine having a Pivot Table Wizard at your fingertips to help summarize this data so that it can be turned into the control charts and pareto charts of a breakthrough improvement project.

60-Day Money-Back Guarantee  Order Now

Data Transformation Tools 

 

I purchased the QI Macros and have had great success with it. Your product is awesome. I love it. It has made my job way easier. I don't dread "crunching" the numbers because I know how easy it will be, and the presentation is worthy of forwarding on to my customer. Keep up the great work.
- Rick Hinton, Main Steel Polishing Inc.

The QI Macros contains the following tools to help you transform and reorganize your data:

 

Pivot Table Wizard makes it easier to run Pivot tables on your data. Just select up to four columns of data and select our Pivot Table wizard.

Count Words in a Table will count the number of times a word or two word phrase appears in your data. You can then run pareto charts on these counts to identify common themes and problems.

Stack/Restack increases or decreases the number of columns your data is organized into. It can take one column of data and "stack" it into multiple columns or it can take multiple columns of data and restack it into one column.

Paste Link/ Paste Link Transpose: Excel lets you paste link and paste transpose but it doesn't let you do both at the same time. Use these functions to link your data to a QI Macros fill-in-the-blanks template. Update your data sheet and the template and chart are automatically updated. Use these function to build dashboards.

Box Cox Transformation multiplies the selected data by a transformation factor. The purpose is to transform non-normal data into data that is closer to normal.

60-Day Money-Back Guarantee  Order Now

Watch Video Examples
  
To use the Data Transformation tools just select your data and choose a data transformation tool from the pull down menu (e.g., paste, restack, etc.)
  
For more information:

Download Your Free Resources

   

View Other Lessons

In Lesson #6 we will provide more detail about the Automated Control Chart Dashboards.
Previous Lesson Next Lesson

Jay Arthur, the KnowWare® Man, solves problems of delay, defects and deviation—the three silent killers of productivity and profitability—using the tools of Lean Six Sigma.

 

Rights to reprint this article in company periodicals is freely given with the inclusion of the following tag line: "© 2011, Jay Arthur, author of Lean Six Sigma Demystified and the QI Macros SPC Software for Excel. Download a 30-day trial from www.qimacros.com."  

 

You can reach Jay at 888 468 1537 or info@qimacros.com
Check out our website at http://www.qimacros.com