I did a quiz on The Guardian’s website called “How well do you really know your country?” The pic I saw after the quiz reminded me of Excel’s INDEX function. Yes, I see Excel function names everywhere I go! Continue reading
Date Archives → January 2016
National Electronic Injury Surveillance System (NEISS)
This is my first post about exploring free public data sources. Knowledge really is powerful and knowing how people get injured is important in order to learn from it and avoid future accidents.
Continue reading
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 00141 Formula Auditing Maestro
Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. Continue reading