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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.