It’s Hard to Do Data Analysis on Ugly Data... Part 2

Improvement Insights Blog

It’s Hard to Do Data Analysis on Ugly Data… Part 2

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 data about medications that might affect patient falls, we have to:

  1. Transpose the data
  2. Use Excel’s Text-to-column feature to split the meds into separate cells
  3. Use QI Macros UnStack Columns tool to get all of the meds into a single column
  4. Use QI Macros Data Mining Wizard to create a PivotTable and Pareto chart of medications involved in patient falls

You can watch the video below:

This entry was posted by Jay Arthur in Data Mining, Improvement Insights and tagged , , . Bookmark the permalink.