O'Reilly logo

QlikView Unlocked by Andrew Dove, Roger Stone

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dirty data and what to do about it

A major use of QlikView is to create Data Quality Dashboards as the issue of Data Quality affects everyone and is something that we need to bear in mind when designing the data model.

Background

Different data sources have their own levels of quality issues. Databases have field types, which, at least, prevent errors such as text in a numeric field or an invalid date entry in a date field. However, spreadsheets usually do very little in the way of verification. Always try to work with clean data, even if it means extra work before starting the real development work. Ideally, you can ask the data provider to clean up the data for you!

How to do it

Whatever our data source, we have to assume that there could be issues ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required