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:
- Transpose the data
- Use PivotTables to summarize the data
- Use a c Chart to plot the data.