QlikView Review

Yet another possibility with QlikView.


I sometimes wonder, haven’t we seen all the possibilities for QlikView?

The answer is simple – NO!

The other day a client of my, asked if I could build some kind of a data warehouse monitor upon their enterprise data warehouse.

This client has a SQL Server data warehouse with QlikView as a frontend. The data in the data warehouse are updated in parallel processes, so data for each country are loaded in different time of the day. They also do ad hoc updates of the data warehouse if needed.

They have a nice log table in the SQL Server data warehouse, telling us when each ETL step is updated, and if there have been any errors in a step. However, reading this log is not that easy. Therefore, they asked if QlikView could visualize the data in some kind of a data warehouse monitor.

My idea was, why not create a one sheet overview, showing each of the component in the data warehouse architecture and visualize this? I wanted to use red and green icons and arrows showing witch part of the data warehouse is currently under update and if there were any errors to take care of.

I ended with this lovely solution:

I have used text-boxes with images as background, color expressions and conditional show of objects.

Simple, very useful and hopefully a good inspiration.

Disclosure: The company I work for is partners with several vendors

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 Comment
Database Manager at a tech services company with 501-1,000 employeesConsultant

Thanks for giving the nice information about Qlikview. I also want to create such type of visualization for the data warehouse of my client. Can you please give me any idea that how you created this graphical sheet? Did you use any built-in wizard?

14 January 14
Guest
Sign Up with Email