Well-formed Data - Part 4: Missing Data

How often do you get data that needs to be charted or graphed only to find out some of the data’s missing?  We see it all the time.  However, just because it’s missing, doesn’t mean you can ignore it.  You need to know how to make it consistent, how to deal with it if it is missing, or sometimes even how to recover it.  In this 9:12 video, the fourth in our series on well-formed data for charts & graphs, we cover:

types of missing data
differences between incomplete, space, blank/null, and 0 data
dealing with missing text
dealing with missing numbers
dealing with implied data

Let [...]

Well-formed Data – Part 2: Concatenation & Extraction

Continuing our series on preparing data for analysis & visualization, we’ve just released the next video on concatenation and extraction.  The ability to break data apart and put it back together in new ways is essential to preparing data.  By storing data at the lowest sensible level, it can be used separately or combined with other data for interesting analysis and visualization.  In this practical video, we discuss 6 key Excel functions for extraction including left(), mid(), right(), search(), len(), and trunc().

Check out this 9:57 video to learn how to take the next step in preparing your data for analysis [...]