Data visualization and analysis are powerful tools for discovering and communicating stories held in your data. However, before most of today’s data visualization tools can be used effectively, the data must be cleaned, organized and prepared. Over the next 4 videos, I’ll be discussing how to prepare your data to be visualized. The first step in the process is consistency. Consistency is made up of 4 principles:
- One Concept per Row
- One Data Type per Column
- One Format per Data Type
- Using the Lowest Sensible Level
Check out this 9:43 video to begin the most important step in preparing your data:
In the next 3 videos, we’ll continue the discussion with Concatenation & Extraction (how to put things together and take them apart), Normalization (advanced ideas to support One Concept per Row), and Missing Data (how to deal with missing or implied data).
[...] 1: Consistency (9:43) Part 2: Concatenation & Extraction (9:57) Part 3: Normalization (8:52) Part 4: Missing [...]