It’s Hard to Do Data Analysis on Ugly Data

I have found that people often get stuck before the Analyze phase of DMAIC because of ugly data.  You can’t analyze data until it is in the right format for analysis.

In this example of patient falls data, we have to:

  1. Transpose the data
  2. Use PivotTables to summarize the data
  3. Use a c Chart to plot the data.

This entry was posted by Jay Arthur in Data Mining, Improvement Insights and tagged , , , , . Bookmark the permalink. Follow comments with the RSS feed for this post.