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 and visualization:
In the next 2 videos, we’ll continue the discussion with Normalization (advanced ideas to support One Concept per Row), and Missing Data (how to deal with missing or implied data).