Shantanu's Blog

QlikView is a Business Intelligence (BI) software, which combines the features of dynamic presentations and instantaneous data manipulation. The paid version comes with a nice user friendly web interface. For example check out the Global Games app by qlikview.

http://ap.demo.qlikview.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Global%20Games.qvw&host=Demo11

a) Australia's performance has deteriorated in the last 3 Olympics.
b) Australians are good at swimming and cycling but not in Shooting.
c) Male to female ratio is equal.

There are 3 steps involved to get any type of report. for e.g.
a) Type australia in the search box.
b) Choose the last 3 years in the years drop down on dashboard.
c) Click on "country profile" tab.

Qlikview has eliminated the scripting layer from the reporting process.  Reporting can be easy, intuitive and fun!

_____


After testing the tool with dummy data, I have come up with some interesting advantages over traditional spreadsheet tools like Excel.

1) Charts
Charts can be easily created based on the selected data. Zoom in / out and export to image file is as easy as pie. (image 1)



2) Two dimensional data
This has been explained in image 2 and image 3.


 
Here are the report inferences those can be derived based on the data analysis.
a) Acer devices are using Android as well as Windows Mobile OS but Android is more popular. (image 2)
b) Acer has around 17 models with A100 and S300 being most poular. (image 3)



Excel can do this, but reverse engineering is not possible in excel.
For e.g. If I need to know all the devices those use Android platform, I will have to re-sort and then re-group the data. qlikview allows us to do all this and much more using right click button as shown in image 4.