2014-05-07T11:42:00Z
it_user110916 - PeerSpot reviewer
Business Analyst at a tech services company with 51-200 employees
  • 6
  • 12

Does QlikView support my requirements?

I'm looking into implementing QlikView and need to know if it meets my requirements.

My requirements are: 

IT User Requirements

  1. Meta data - the setup should be easy and easy to maintain.
  2. Security - The security should link to Window's AD (Active Domain) and the security setting in BI tool should allow by individual, by group/function.
  3. Setting at BI tool to disallow query of all rows in the database (which will slow or hang the whole network)
  4. BI tool can only read, must not allow to edit/write/create any data.

End User Requirements

  1. Must be very easy to use and good performance - No scripting or sql is required for queries/generating reports by end user.
  2. Must able to query and generate report from DB (i.e. our databases which is MySQL) to Excel (Word, pdf and Powerpoint - optional).
  3. Must be able to save query result to Excel (Word, pdf and Powerpoint - optional).
  4. Must be able to query/report from different tables (IT terminology, i.e. able to have inner/outer joins) to Excel (Word, pdf and Powerpoint - optional).
  5. Able to create dashboards for standard/regularly use queries/reports.
  6. Able to drill-in/drill-out, dicing and slicing.
  7. Support real-time dashboards/reports
  8. Dashboards/reports able to be displayed on internet/intranet with real-time data or refresh at certain timing.
  9. Able to save the result of my queries for later use. E.g. Query further from the save result and other data source (tables, excel, word, pdf).
  10. End-user should be able to use the BI tool from their mobile devices.

Does QlikView support my requirements?

5
PeerSpot user
5 Answers
it_user5436 - PeerSpot reviewer
Director of Data Analytics at Visokio
Vendor
2014-05-21T09:29:41Z
May 21, 2014

If you are using MySQL, rahter than the full MS 'stack', then an MS-based solution would be far from 'free' as suggested above. For comparison, I suggest you compare cost and time/complexity to implement with Omniscope 2.9, which also meets all your requirements above, does not require developer/SQL type scripting, and does not require you to start with a server edition, just a single desktop for POC. Compared to Qlikview, Omniscope is more open and modular on the back end, and operations can be 'chained' across multiple in-memory files, spanning different disciplines and departments with in your organisation to ensure data governance and give the best overall 'fit' and highest ROI/speed of acceptance.

Search for a product comparison
it_user97479 - PeerSpot reviewer
Consultant at a tech services company with 51-200 employees
Consultant
2014-05-07T18:24:30Z
May 7, 2014

Here are my answers:

IT User Requirements

1. Meta data - the setup should be easy and easy to maintain. OK
2. Security - The security should link to Window's AD (Active Domain) and the security setting in BI tool should allow by individual, by group/function. I think that you can do this with server edition It is more expensive. If you have small number of users, you can use all settings that could be used with a file stored in a folder at disk.
3. Setting at BI tool to disallow query of all rows in the database (which will slow or hang the whole network) - QV works differently. It import data into special comprised file via ETL procedure. When data are loaded, no additional queries to database appear. You not need any special settings, it meets this requirement.
4. BI tool can only read, must not allow to edit/write/create any data. It is OK. It meets your requirement.

End User Requirements

1. Must be very easy to use and good performance - No scripting or sql is required for queries/generating reports by end user. - OK
2. Must able to query and generate report from DB (i.e. our databases which is MySQL) to Excel (Word, pdf and Powerpoint - optional). - The file can be saved as any of the following formats: Comma Delimited, Semicolon Delimited, Tab Delimited, Hypertext (HTML), XML and Excel (xls).
3. Must be able to save query result to Excel (Word, pdf and Powerpoint - optional). See 2.
4. Must be able to query/report from different tables (IT terminology, i.e. able to have inner/outer joins) to Excel (Word, pdf and Powerpoint - optional). OK
5. Able to create dashboards for standard/regularly use queries/reports. OK
6. Able to drill-in/drill-out, dicing and slicing. It is much better, it immediately recalculate all outputs, when you chage selection of parameters. As it has in-memory technology it takes seconds.
7. Support real-time dashboards/reports OK
8. Dashboards/reports able to be displayed on internet/intranet with real-time data or refresh at certain timing. OK
9. Able to save the result of my queries for later use. E.g. Query further from the save result and other data source (tables, excel, word, pdf). See 2.
10. End-user should be able to use the BI tool from their mobile devices. OK

Does QlikView support my requirements? It seems that YES!

it_user93543 - PeerSpot reviewer
BI Expert at a tech services company
Consultant
2014-05-07T14:23:03Z
May 7, 2014

Yes, QlikView supports most of your requirements as outlined below.

IT User Requirements
1. Meta data - the setup should be easy and easy to maintain. ...YES
2. Security - The security should link to Window's AD (Active Domain) and the security setting in BI tool should allow by individual, by group/function. ... YES 
3. Setting at BI tool to disallow query of all rows in the database (which will slow or hang the whole network) .. YES
4. BI tool can only read, must not allow to edit/write/create any data. ... YES

End User Requirements
1. Must be very easy to use and good performance - No scripting or sql is required for queries generating reports by end user....YES, the IT Manager must have uploaded all necessary fields the user could be interested in for analysis. All the user needs to do is drop a new table or object on the sheet and analyse.
2. Must able to query and generate report from DB (i.e. our databases which is MySQL) to Excel (Word, pdf and Powerpoint - optional). .. YES
3. Must be able to save query result to Excel (Word, pdf and Powerpoint - optional)...YES SAME AS ABOVE
4. Must be able to query/report from different tables (IT terminology, i.e. able to have inner/outer joins) to Excel (Word, pdf and Powerpoint - optional)... YES , all reports generated on QlikView can be exported to excel, iimage files, pdf
5. Able to create dashboards for standard/regularly use queries/reports. .... YES
6. Able to drill-in/drill-out, dicing and slicing... YES
7. Support real-time dashboards/reports ... YES this depends on the refresh rate u set
8. Dashboards/reports able to be displayed on internet/intranet with real-time data or refresh at certain timing... YES 
9. Able to save the result of my queries for later use. E.g. Query further from the save result and other data source (tables, excel, word, pdf).
10. End-user should be able to use the BI tool from their mobile devices... YES

Please revert if you need further clarification.

it_user110322 - PeerSpot reviewer
IT Administrator
Vendor
2014-05-07T12:13:34Z
May 7, 2014

I have not implemented QlikView, I have implemented the Microsoft BI Stack (SQL.SSIS/SSRS/SSAS). All these fit your requirements. A big plus is that these are free, as it comes with SQL Server. Excel power pivot is compatible with sql server and gives you ultimate performance and dash boarding with no cost and high rate of return.

Vendor
2014-05-07T12:08:23Z
May 7, 2014

Hi July,
I cannot answer every point but you will need to do allot of scripting with Qlik from a MetaData perspective and End User perspective

Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
657,397 professionals have used our research since 2012.
Related Questions
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Jul 3, 2022
If you were talking to someone whose organization is considering QlikView, what would you say? How would you rate it and why? Any other tips or advice?
2 out of 5 answers
TP
Crm/Business Intelligence administrator at Kc firiakis LTD
Apr 25, 2022
I am just a customer and an end-user. I'm not sure which version of the solution I'm using. I'd recommend the solution as it is pretty user-friendly in general. Overall, I'd rate the solution an eight out of ten.
Jason Heunis - PeerSpot reviewer
Senior Manager: Diversified Operations at Pharmacy Direct
Jun 6, 2022
I would recommend QlikView for a small business with very specific data needs. QlikView makes sense for small businesses with a very specific data environment where data is controlled, and there are one or two people requiring the data or reports. For anything bigger than that, there are other more modern tools that you can use at a lesser cost. I would rate it a five out of ten because there is quite a learning curve for using the tool, and it has been falling behind other tools.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Jun 6, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 7 answers
it_user928116 - PeerSpot reviewer
Technical Lead at a tech services company with 1,001-5,000 employees
Sep 25, 2018
The pricing is too high compared to the other solutions on the market.
CM
Manager, Financial Systems Deployment, EPSI at a healthcare company with 1,001-5,000 employees
Oct 4, 2018
It is not very expensive. I think it it is on par with other similar products on the market.
Explore this product
Download Free Report
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
657,397 professionals have used our research since 2012.