What does a typical data wrangling workflow include?

point

Validating the quality of the transformed data

Recognizing patterns

Predicting probabilities

Using mathematical techniques to identify correlations in data

Question

OpenRefine is an opensource tool that allows you to:

point

Automatically detect schemas, data types, and anomalies

Enforces applicable data governance policies automatically

Use addins such as Microsoft Power Query to identify issues and clean data

Transform data into a variety of formats such as TSV CSV XLS XML and JSON

Question

What is one of the steps in a typical data cleaning workflow?

point

Inspecting data to detect issues and errors

Building classification models

Establishing relationships between data events

Clustering data

Question

When youre combining rows of data from multiple source tables into a single table, what kind of data transformation are you performing?

point

Denormalization

Unions

Joins

Normalization

Question

When you detect a value in your data set that is vastly different from other observations in the same data set, what would you report that as

point

Irrelevant data

Missing value

Syntax error

Outlier