#71 🎯 Self Service Data Quality with VizLib Writeback in Qlik Sense
Following my previous post, we accepted that Data Quality is an important part of every data analytics project.
When I start to build a Data model from raw data, I’m used to “audit” fields to better understand them. But I always need a knowledgeable eye to validate them or not. In this stage, we run different kinds of controls to find data issues.
These controls will also be valid once the application is in production to track new data.
Yes, Data Quality never stops!
One of the keys to being better at quality is empowering people. And therefore give them the right tools to do so.
I don't want any more "Hey Christophe, please add a control on this or that field". 😪
Self Service Data Quality with Vizlib Writeback
Because I'm tired of doing the same things over and over again project after project, I’ve built this app (see the GIF below). The concept is pretty simple and gives people the ability to run predefined controls over a dataset.
Build a Writeback From and defines controls
Write conditional script for each one
Use System Fields in drop down
Visualize results in a dashboard
This Proof Of Concept app includes basic controls such as : Missing values, Greater or lesser than, Date Format, is numerical.
What other tests do you often do? Do you find it useful?
Let me know in the comments !
Cheers