Saturday, December 27, 2008

Why QlikView

Why QlikView

The organization that do have Standard ERP, Customized ERP, CRM, Legacy System or combination of any of these have some frequent report in built in the system as well as they have a team which can modify the GUI of existing report or can create a entirely new report as on demand of management/end-users.
It is easy to say that we do have a team and we can create our new report by using some GUI editor software (Most of them are using Crystal Reports). But when those report which are Ad-hock in nature are very frequent or demand for those reports are high then normal practice is to bring data in excel. When use of excel is there then it increase pressure on IT-Team and most worsen situation comes when functional user starts making report in excel. It has two consequences first is that it is totally wastage of highly paid skill sets in development of reports second the truth may be altered while presenting these report to Management.
Now the question is what is the solution of this situation? The suggested solution is bellow
1. Reduce the use of excel sheets
Problem is my top management has a practice to see report in excel only?
2. Give your top management something that look like excel and they don’t require to learn anything extra.
Good Thing is QlikView GUI is almost Similar to Excel
3. The tool you have opted for should have capability to make reports faster than any other tool.
QlikView can implement in ¼ of time than any other BI software. In another way if you are making 50 reports in T Time in same time you can generate 200 QlikView reports and those reports would be dynamic in nature.
4. The tool you have opted for should have less vendor dependency ( Since you are looking for a tool which can fulfill your needs of ad hock reporting need you require 100% control on report development)
QlikView gives you freedom from vendor dependency as the person who knows SQL scripting can implement entire QlikView suite after 3 days of Enterprise an 2 days of professional training that your vendor can easily provide.
As well as in comparison to OLAP base technology where your control is limited to Cube level only, in QlikView you have full control up to data source level, you can easily add or delete a dimension in QlikView report and it is 100 % GUI based. Even to write a code you can use your mouse only in 70 % cases (As it has almost all functions and logics inbuilt and they are only click apart)
5. The tool you have opted should have multidimensional report and it should not be limited to aggregates only.
QlikView gives you n-dimensional reports (Where in OLAP you can get Maximum 7 dimensional report practically). It is best in aggregate as well as in detailed reports also. (you can have drill down up to transaction level.)
6. Management can travel with their reports.
One can easily carry their QlikView report with full functionality even when they are not connected to network (Provided if they do have valid authentication) it will show an time stamp when data has last refreshed.
7. The tool you have opted for should have very good past and future.
QlikView have more than 10000 customers in 90 countries. And it has 98 % project success rate in comparison to 38 % project success rate of OLAP based tools.
According to IDC QlikView is fastest growing BI software in the world and it is now adding 14 customers per working day across the globe.
It falls in Visionary Quadrant of Gartner’s Magic Quadrant for BI Software.
QlikView is Market leader in in-memory based software.Being in memory it is supported by Gartner as Gartner say by 2012 almost 70 % of Global to 1000 companies would bring their data in to the memory for analysis.

8. The tool you have opted for should have low cost of ownership without compromising of value. QlikView can implement in almost ½ the cost and it delivers 2*Value in comparison to traditional BI software. Initial investment is even 1/8 than any other traditional BI software
Now the Question is how to evaluate QlikView-?
I suggest seeing is believing. Call your vendor for a ½ day Proff of Concept (POC) on you data ask them to create some of your management’s report on your data by directly pulling from your transaction system.
For any POC on QlikView feel free to contact me at
Sudhir Kumar
Mobile- +91-9312667720 or write me at

Search more on BI on Web

Know the Blogger