Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading
Awkward Data
Posts Tagged → Data cleanup
Normalize Data using Excel Get & Transform
In my last post I used formulas to solve a messy data disaster. In this post/video I’ll show you how to use Excel’s amazing Get & Transform feature (aka Power Query) to re-arrange the data. Continue reading
2018 World Cup and Excel !
Last week I was helping a friend build a World Cup pool in Excel. It was fun debating the pool’s scoring rules. I also taught him a few Excel tricks along the way. Continue reading
Re-arrange, Rotate, Transpose, Twist, Cascade the data!
Who knows what could happen in the future but for now humans using software cleanup and analyze data (not nerdy robots!). This post reviews examples of awkwardly twisted data that require transposing, rotating, repeating, etc before it can be properly analyzed.
Video 00142 Horizontal list to Vertical list (layered transpose)
We don’t always find out how data got twisted into awkward forms. Our job is to fix it by normalizing, unwinding, transposing, etc. Once the data is in the correct format we can then get to the real job of extracting meaning from it. Continue reading
Video 00135 Cali Data Cleanup
Have you ever received an awkward data set? In my life as a Data Analyst this has happened to me many times in different shapes and forms. Continue reading
Video 00114_Cleanup Data From Internet
Have you copied data from the internet and pasted it in Excel?
It can be very frustrating when the data is messy!
Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.