Data QA

Ojay

I'm trying to put together an Alteryx workflow which I can use on a regular basis which can serve as a standard for the QA of data contained in Excel files rather than carrying out the QA in Excel before transferring over to Alteryx.

Any help with this will be appreciated.

Thanks.

Olu

Thableaus

@Ojay 

These are some example on how to do QA of your datasets:

- With RegEX tool and RegEX function in formula Tool - you can identify patterns of date format and correct them. 

If you don't know what RegEX is, I recommend you to study more about it. Here are some topics in the community and a website to help you:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/RegEx-Examples-12-Handy-Use-Cases/ta-p/40680

https://www.rexegg.com/

- Basic Data Profile Tool hands you a lot of useful information from all of your fields

Including Leading and Trailing whitespaces, longest length, number of nulls etc.

Here is a useful topic on this tool

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Basic-Data-Profile/ta-p/28610

- Field Info tool brings MetaData info to you. Field types, field sizes, names. Here is a topic about it.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Field-Info/ta-p/60723

- Frequency Tool is able to identify the frequency of each value on each field. Perfect to find duplicates

- Field Summary is similar to Basic Data Profile. It focus on the fields you select.

These are some tools to do Data QA. Browse Tool also has the ability to do most of what these tools do, and you can use it to do ad-hoc analysis on the quality of your data.

I'm appending the package with the dataset analyzed and all the tools commented. 

I hope I was able to clear your mind on this topic and that this can serve to boost your interest in Alteryx.

Cheers,

DataQA.yxzp