More examples

More areas where data quality may need be suspect include consistency, reliability, appropriateness, and accessibility. DataManager offers various means for addressing these as well.

Consistency

In an earlier example, we looked at the use of the DataManager VBScript node to reformat the record date field of our data. Another example where data may be valid yet still in constant include scenarios such as the value of the sex field.

The Male, M, Female, F, 1, or 2 values are all perhaps valid values yet these inconstant responses make visualization of data challenging. Using the VBScript node can easily address this example. Again, using the power and flexibility of VBScript, you might use the code shown in the following screenshot:

Get Big Data Visualization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.