We recently adopted QlikView as our Business Intelligence application, using it primarily to draw from and combine data from three different databases. It is a very cool product that is great for everything from producing regular standard governance reports to providing a playground for cutting and exploring data every which way.
For beginners it is pretty easy to get going with QlikView. There is a 'wizard' approach to connecting to data sources and creating a dashboard (I found this most useful when connecting to Excel files). Learning the basics is remarkably quick and easy. Using an existing dashboard is very intuitive with multiple ways to drill down and filter. As well as the obvious clicking on one or more selections on a list approach to filtering and drilling into data you can click directly on chart elements or items in a chart legend, or click and drag over visual elements to achieve the same result. A range of data and image copy/export options can be added as icons to the menu bars at the top of every object - ideal for quickly dropping tables or charts directly into documents.
First appearances may give you the impression that this is a fairly simple and limited piece of software, but don't be deceived. Under the hood there is a huge amount of capability hiding, though beyond the basics there is a steeper learning curve for BI newbies like myself. Support exists through a mix of videos, blogs and forums, and there is a downloadable comprehensive 900 plus page guide.
Where data is drawn from a mix of sources QlikView will assume that fields with exactly the same name in different datasources are the same thing, and will create links between the different data tables based on these. This can be great and can save time manually matching fields, but it can also create data 'loops' that require a bit of re-naming in the data load statements to fix.
As well as vastly improving our understanding of our business at a reasonable financial cost I have found this to be both an easy way to learn BI basics and a great platform for moving up to a more intermediate level of dashboard creation. If an easy to use geographic location mapping option was included this would be a hard product to fault.
Easy to get started, very intuitive for end users, great data and image output capabilities, simple to use over multiple data sources within one document.
Creating geographic mapping charts is pretty complex unless third-party add-ons are purchased.
This is an excellent analytical tool with below best suited features:
1) Flexible chart design
2) A lot of charts and plenty of minutes properties to configure the chart.
3) Power of custom expression using a expression language called "SET ANALYSIS". This enables a better control on data transformation and manipulation.
4) Script editor where in Data Layer can be defined, designed and managed.
5) Nice client server architecture so that report designed can be easily published over to web and access can be controlled easily through management console.
6) Qliksense, a cloud model, is a best thing qlikview has.
It's nothing like bad things but good if it has few features (that other BI tool has)
1) Data management should be more user friendly. Right now it is in script editor. Someone with good knowledge of Relational Database can easily handle this but a programmer knowledge is must. End users or non technical person may timid to start with qlikview as they will find it hard to start with.
2) Too many properties and configuration available. (It's not a bad thing at all as it gives more flexibility) But many configuration can be easily clubbed together systematically and user do not waste time to find the properties configuration. Meaning configuration should be simplified and structured.
QlikView is an excellent tool for data visualization. Developers can create intuitive solutions with relative ease.
QlikView has a positive 80/20 ratio. The first 80% of what you need to know (everything you need to know for most visualizations) can be learned in 20% of the time. The remaining 20% (complex expressions, extensions, and other advanced options) takes 80% of the time to learn.
A skilled analyst can sit down on day one and create a useful, meaningful QlikView solution. An advanced user could spend years learning new possibilities and creating more advanced offerings.
QlikView is an "in-memory" BI tool, which does offer speed and data manipulation capabilities. However, the data model is loosely managed. If it's not structured carefully, loading and processing times become unnecessarily long. The underlying model could be strengthened and otherwise improved to help the platform scale to larger projects.
Performance, easy use, less maintenance required.
Dashboard Designing made so easy in this Tool.
Bunch of formatting options and features.
Scripting capabilities took this tool to next level to build more complex dashboards in a simpler way.
Implementation and maintenance is so easy compare to Business Objects.
Data integration, mapping capabilities, drill functionalities are too good.
In Memory capabilities gears up performance.
Another big advantage is, just one product.
Not that great when you work with data sources like BW and Big Data.
R integration is not possible.
For Detailed reporting is it not the tool preferable.
If you are looking for a great scheduling and publication capabilities you may not like this tool since this requires a separate setup like NPrining etc..
QlikView is extremely easy to use, user-friendly and developer-friendly. At the same time, it offers a lot of depth - when a complex solution is required, QlikView offers robust tools for your most intricate analytical needs.
After 13 years of using the product, there are many little things that I don't like. For example, while QlikView scales up very well to handle hundreds of millions (sometimes even billions) of rows of data, QlikView Server management tools are relatively simplistic. It's easy to manage a single server or a few servers, with a few dozen of reload tasks, but it may be difficult to manage many servers with thousands of users and hundreds or thousands of reload tasks. Having said that - QlikView is still one of the most well-rounded tools that offer a great frond end and a phenomenal back end in one package.
my work revolves around these BI software. They gave me the opportunity to take certifications
The very high level of personalization of formulas and objects. Moreover there are different versions of the software (like the QV publisher) to further restrict the accesses of the staff involved in the consultation. Excellent tool for SQL
you need some training to use this software, and a minimum of one year of use to be able to use it with ease. It is not easy to understand the "set analysis" syntax to make intrarecord selections.
The qmc could be improved. It would be interesting to integrate the possibility to refresh the document directly from the front end to update the data analyzed. Improve the use of macros and enable the QV publisher to use them
Allowing us to knit together multiple data sources into a single customer view to aid our marketing and sales teams to better target their audiences.
Has a multitude of options to enable the creation of complex dashboards. Fantastic online community providing excellent support and guidance. Good intuitive, professional interface makes it productive to use. Can handle extremely large record sets without a problem.
Tough initial learning curve to get to grips with the language and best practice methods. Some extras likes maps and email marketing ability carry additional costs. Requries computer with lots of RAM.
Qlikview enable us to create high performance statistical dashboard which help us provide great user experience to our clients. Another thing is the drilldown capabilities you can have this easily and without scripting or coding.
I like the most on this software is the creation of formulas for your chart object. it enable you to create formula on what you imagine. You can get the computation the you need. Another is the performance, For me this is the fastest data visualization tool i have used.
I think the only cons of this software is the price. Its pricey but it worth it.
After implementing 3 projects, I was so convinced I am not even close to not so familiar, not so user friendly, not so popular tool to the people who would ask to use.
I read its manual and couldn't code anything close to what I could quickly on my day 1 in Power BI and Tableau kinda tool
Good slicing feature
Can handle terabytes of data
Its in memory stuff brings gigs of server storage space that might turn a pro into a con
Implementation cost per user are too much that small to medium sized business cant even think of affording it.
Infra cost would rise
Coding they say is easy but not really that easy especially for non It users
Performance issues are so severe
Poor customer support
Qlik has always been about giving the user unparalleled flexibility. Some customers use QlikView as a powerful visualization tool on top of a well though out BI stack. Others leverage QlikView's ETL and scripting engine to wrangle disparate data sources into a simple to use tool.
With flexibility comes some complications. Dashboards and reports can be built out quickly but new customers will find that the number of options can be somewhat overwhelming. Complex visualizations and manual scripting can take time to polish, often leaving the customer wondering where the 'Wow' they saw in the sales cycle went.
QlikView's unique in-memory, associative data engine makes it possible for an organization to gain insight quickly from vast amount of data.
QlikView is trend setter in the business discovery space and a leader in the Gartner's magic quadrant for business discovery tools.
QlikView's visualization capabilities are not as strong as one offered by Tableau but Qlik Tech is addressing that with a new product -- Qlik Sense. It has yet to be seen how QlikView and Qlik Sense will work as a suite.
Qlik Tech has yet to articulate their long-term vision for QlikView and Qlik Sense. Customers feel uncertainty due to lack of clarity.
Brilliant if you have had the correct training!
Can pull in data in its rawest form and make sense of it by creating charts, lists, graphs.
You can design and develop almost anything and can link in other pieces of data from Excel or tables files sat on the server.
This is not the easiest software to use and will require extensive training which in itself. Since using this I have had 2 separate training courses to get my head around the coding and scripting side of it. The design part os easy if you have someone already transforming the data for you.
Using QlikView has helped me produce nice graphics that are completely zoomable to the end user. QlikView also has some nice graphical and analytical capabilities that help me communicate my message.
QlikView's data visualization options are nice, although not best in class. The way QlikView offers zoom in capabilities is much better than any other data visualization tool I've ever used, and the ability to share analysis is great.
I had an enormous difficulty connecting QlikView with various data sources, although once connected, the system works fine. QlikView's graphics are a little different than other data visualization tools - like the zooming - which are sometimes an advantage and sometimes a disadvantage.
QlikView is an extremely flexible tool. The development process is similar in speed and complexity to Excel, but the results are far superior. While it works with just about any data source, I've been most impressed with the SAP connector. An experienced ABAP developer can be at least 10 times more productive using QlikView.
QlikView is great at data visualization. However, it does allow for the creation of data. It would be nice if the tool had better capabilities for entering data.
gives an insight of the data available, easy to use, real time, fast processing (on memory), availability
It is simply a reporting & analysis tool that does not allow WRITE BACK to database.
It's in-built reporting-printing is not very efficient (some third party tool like N-Printing is used)
Very intuitive software with great data visualization. The software is very easy to use and customizable. It even allows you to do what if analyses to show impact all around. Qlik is the new wave for increasing data analytics and reporting. It allows the users to get the real story behind the data very quickly to make concrete decisions on the hits and misses within ones industry. I would highly suggest this software and I'm sure many more companies will jump on board after they just get a wiff of what this software can do for the business.
Qlikview is a great tool
1.To build aggregations and analytics on fly.
2. Charts and visualizations are best.
3. Relational data model is easy to build and provides lots of flexibility to analyze data.
4. Tool can read data from many data sources and ERP like SAP
5. Lots of technology upgrades and integrations like NPrinting, GI maps are very useful features.
1.Language syntax is close to SQL but not exactly. Its sometimes confusing.
2. Does not provide lot of flexibility with objects and sheets
Back when I was a SQL developer, I was told I was to sit in on a demo of a GUI-driven reporting solution I was skeptical of what it would deliver. However, when I saw what the associative engine was doing in filtering data without having to write queries, it was nothing short of a revelation. Building solutions with QlikView is what I wanted to be doing. Since that moment I have been lucky enough to be able to demo QlikView to a large number of people - giving them that same 'Jaw Drop' experience.
When you have built something in QlikView, you want to share it with everyone. Unfortunately, the licensing model can make this quite expensive quite quickly. However, it is often possible to achieve massive efficiency savings by moving to QlikView, making a quick ROI a possibility.
QlikView enables associations get more information from the data have, a particular term, and it gives you fast results
No form controlling is accessible and parameter records can be utilized for information associations. distinct absence of specialized assets when you are not managing deals and money related information Qlik Sense should update few functionalities
1. Qlikview's capability to handle large volumes of data is really good. It reduces the size of datasets to one-tenth of original size when converted to QVD formats.
2. Strong data management capabilities
3. Adaptors available to connect to a variety of data sources
1. Visualizations and user interface is not as great as other competitive solutions - can be improved
2. Doesn't have "Activity" feature which Tableau has - when you click on a graph/data point, you move to another graph in some other dashboard - this becomes very interactive when you want to present the effect of one thing on another
3. You need to know a bit of programming language to use the tool completely
I recommend the tool. Friendly user, you can have very good dashboards using only a simple spreadsheet.
Low cost against BO, Cognos,...
You can simple use Tables, databases, web tables and a lot of other kind of connection to use the data.
It don´t have a flexible map as a standard. You should acquire a "Geo Analysis" add in for a best use.
Building the meta data for each dashboard is easy and the tools have enough depth for any complicated calculations. All the objects have lots of options and the scripts for each data point can be heavily customized or left as a single field. Conditionals for each object combined with global variables make each dashboard dynamic
Desktop design tool that sometimes hogs memory and crashes. Licensing between small business and big business is not very flexible.
Cost is low compared to value. Truly connects to any data source. Data governance, security, and user adoption rates couldn't be better. Directly embed into EHR workflows to deliver maximum value to end users. Extremely fast timeline associated with production application development. Ease of use in the context of truly 360 degree data access.
Skill set of Qlik developers isn't exactly a commodity in today's market. Keeping up with intensely high rates of end user adoption is difficult. Building a team that can meet Sid requirements and business leaders that are able,to take ownership of DQ and data definitions.
Qlikview has an exceptional data mapping engine which makes setting up data sets a breeze. You will be up and running in no time, connecting to your data and viewing information in any one of a variety of formats.
I've only been using the product for a reasonably short time, but this provides a lot of flexibility to allow users to control the data which they would like to see.
I've found QlikView to be really easy to use in most areas with the exception of making changes to views once configured. The UI could be a little more user friendly when considering how and when to make changes as an administrator.
We use the free version of QlikView to give every user in the office access to all our data. Without it, their only option for viewing and analyzing data is to either look at each constituent record individually, or pull huge spreadsheets out of the database and hope the data they need is there.
The free version is fully featured. While it's a pain to deploy, everyone in the office can get a lot of use out of it.
The UI is super clunky, the fonts aren't smoothed and to have a truly useful product, you have to be your UI designer.