Qlik Sense is a self-service analytical tool based on the same in-memory technology as QlikView. It's associative engine allows for snappy selections, filtering and prompt re-calculation of all charts and aggregations on the fly as the user navigates throughout the dashboard, even on datasets of over 100 million rows.
Qlik Sense focuses more on the self-service aspects of BI, where users are encouraged to build their own Adhoc visualisations without the use of keyboards simply by drag & dropping various elements, making the technology utmost business friendly. Also, as the whole technology is fully web-based, it embeds the latest visualisation libraries (D3, Raphael etc.) and allows for a seamless integration of customised extended JS charts (so-called extensions). The latter enables for unlimited possibilities when it comes to visualisations (http://d3js.org/) and further integration with web-services (R servers, real-time analytics, Hadoop etc.). Also, the Qlik Sense Server deployment is tailored to facilitate a multi-node deployment, allowing for a very scalable enterprise solution, even cloud-based.
The data security technology (Section Access) is the same one as in QlikView and is customisable, secure and robust.
All in all, when it comes to deploying a scalable and business-friendly BI solution, which has very presentable dashboards, a fast and robust aggregation engine with extended self-service capabilities, Qlik Sense is currently the best product of its kind on the market.
Qlik Sense is still a new product and not very mature yet, as it has only been released a year and a half ago. The review is based on Qlik Sens version 2.1 which is important to emphasise, because QlikTech is constantly updating the software and publishing releases with enhancements and bugfixes.
Qlik Sense is not the right tool, if you requirement is:
1. To have a guided analytics dashboard, where the user is constraint in the way he views his data.
-> This can be overcome by creating mashup websites, however you will need a web developer to do this.
2. Standardised reporting via Qlik Sense and production of pdf files is not possible (yet).
-> An integration with nPrinting, QlikTech's latest acquisition, could change this and it's on Qlik's roadmap for the next year.
3. Your BI solution needs to accommodate flexible data extraction capabilities (e.g. to Excel).
General current disadvantages:
1. The story telling functionality is not mature yet - users have more benefit using PowerPoint directly. In my opinion it's missing a live connection of the snapshots used in the story to the underlying chart objects.
2. Security settings (NOT on data level) are governed centrally via the management console and are complicated to comprehend.
3. No guided analytics aspects, even navigation between sheets can't be controlled.
4. No supported data extraction capabilities. It's almost impossible to get comprehensive extract of it's underlying data, something that was possible with QlikView (Export functionality e.g.)
5. The vendor has little practical knowledge on how Qlik Sense is deployed enterprise wide within a business and is not really able to support.
6. The vendor is focusing more on the data story telling and collaboration aspects of the Qlik technologies and almost imposes those on the business. Personally, I would prefer if QlikTech listened to its customers a little bit more.
An easy and intuitive way to create storyboards for everyone to understand, parting from relative large and difficult to understand and analyze data. The main benefit was a simple way to create quick charts which served as main discussion point with co-workers to make better decisions. So basically a great way to display business information.
First its usability and design. Regarding the User Interface: the application is well designed and I felt like every button and function was where I would expect it to be. The program is responsive and fluid, you always know where you are and what you should do. Having said that, there is some learning curve to the many features, which are a good thing. The program is easy enough to create a histogram with a simple spreadsheet while also allowing for much more complicated statistics and good looking charts, e.g. plotting geo-data, heat-maps, box-plots and so on.
I specially like the ability to write your own aggregation functions and even more the dashboard where you can put different charts and statstics and build an interactive and dynamic kind of storyboard. The interaction works seamless. If you select (in a bar chart) a specific bar or group of bars, the other charts will automatically adjust to show just the relevant/selected data. The program does not hesitate and performs really well, even with large quantities of data. Support is also pretty solid and there is a lot of information and questions already answered on the online forums. It supports many of the standard data sources.
The aforementioned ability to write your own functions has a somewhat steep learning curve. You do have to search online for the primary functions you need (though these are well documented). Unfortunately if your data has to much variables or data points, the charts prioritize the specific variable instead of the whole diagram. What I mean by that is that you can end up with a very large horizontal chart in which you have to scroll horizontally to find the other data instead of 'cramming' all variables into the visible space. This depends on taste, but I did not find any way to change that, which brings me to the next point. The charts are somewhat 'customizable' regarding color and design. However, I've used comparable software which allows for much more flexibility in the structure and formatting of charts. A few times it can get frustrating to use the program, mainly for two reasons. 1. The aforementioned displaying of information in a non-customizable way and 2. the lack of knowledge of how the program really works that hinders you from doing exactly what you want. But of these aspects become less of a problem, the more you use the program.
Qlik Sense is not QlikView. For those of us who have been working with both might seem like the next iteration of the latter. It is not. It uses websockets instead of HTTP and this has a huge impact in performance and usability. The cloud solution is still a work in progress, but for the needs of most users, enough and recommendable. Disclaimer, I'm a former Qlik employee and current Qlik customer.
Proven in-memory engine and robust data extraction language. Drag and drop user interface, responsive, ready to create, not just consume, from mobile devices like tablets. Overall performance and very complete integration with web technologies. Open sourced libraries. Fine-grained user access engine.
Applications are limited to the power of one single computer, although several computers (nodes) can be clustered, they act, at the end, individually (i.e.: not adding up resources from all the servers available). As of version 3.2 lacks a full governance tool and a central library across applications, so what is created for one can be reused in another. Built-in objects are basic, leaving more advanced visualizations to extensions or development of some kind, usually far from the advanced user knowledge (e.g.: widgets).
The first thing you'll notice with Qlik is how easy and quick it is to load some data and get insights. That's down to 3 aspects of the tool. The first is the data manager which allows you to drag and drop data to extract and transform data. The second is augmented intelligence (the cognitive engine) which can build a data model for you if you wish, or simply make recommendations on how to set up relationships in our data. The last is AI in the front end of the product which generates insight at the click of a button; suggesting charts and alternative ways of presenting your data. Within seconds you can load some data, build a model and present some insight.
When you want to go further you've got the data load editor which allows you to write an ETL script and take advantage of compressed storage in the form of QVDs. In the front end, end users can see the whole story in their data because Qlik never leaves data behind, unlike linear ETL tools like SQL. End users can navigate data intuitively using green, white and grey colour coding.
Qlik Sense makes makes data intuitive and available to everyone.
There is a steeper learning curve than some other tools if you want to use the script editor to write code. This is worth doing though as it gives you greater control over your data.
The legends on the map objects do not always correctly describe the maps.
Though it really has its place in the market for simpler deployments, do take care when planning bigger or complex deployments as the servicability of such a deployment is difficult and tricky (but doable).
-Qlik code is easy, Qlikview-code is easy reusable
-Lots of help online
-In the end it will get you allmost there...
-Visualisation not on par with 'the other big-ones'. No proper customisation, and a lot of basic visualisations are not available (Band chart, Radar chart, Combi-plot).
-No analitics/statistiscs toolkit.
-Presenting data/apps takes forever in a citrix-environment.
-Developing a set of dashboards/apps in Sense feels clumsy and messy. There is no hierarchy, keeping track of sequential apps.(Extract/Translate/Presentation) is quite a thing. Think debugging...
-No check-in/check-out tooling, no folderstructures for unpublished apps but a cluttered personal workspace so a lot of discipline and creative thinking is needed.
-Building a corporate environment in Sense feels actually quite 'dirty'.
From my experience, most of the though/completed how-to's I solved with the help of the community.
Hence I strongly recommended, in any tool that you are checking validate how large and cooperative is the community.
- Rapid development and strong supportive community.
- You can build a very nice dashboard and/or reports very fast. Simple reports can be built in matter of minutes! even if your data
is scattered between different files or even different platforms (excels, DB, etc.).
- You can extend the basic (out of the box) platform with Widgets and Extensions
- 'QIik Branch' - open source community sharing Widgets and Extensions that you can embed into your installation.
- Running in memory DB is fine on the server but on the desktop edition might be a problem for large DB.
- While "Associative Model" is what give Qlik the ease of rapid building dashboards and reports it might cause some odd
results if you are not truly understand this and pay attention while building the data model.
- While there is great training for how to use the basic features, there are not a lot for how to build Widgets and extensions.
Great company, great people, wonderful user community. I highly recommend this tool over others in its space. It's more of a European take on business analytics, than an American, so a bit less flashy in the graphics but loads of more feature-rich functions and abilities.
Very well architected in the back end, with loads of security and functionality to leverage. Easy to use from a self-discovery standpoint for even the most basic data lover. Covers our 80/20 rule of 80% self-serve and 20% access to raw data for advanced analytics.
Get's a bit clumsy top administer when your user base grows, unless you staff the tool with a decent administrator. Set your expectations early with the business on these needs, or you will struggle maintaining the tool while fighting for additional resources. A bit pricy at entry level, but more than pays for itself with big revenue gains.
Thanks to Qliksense we are able to provide easily the information the user wants and to personalise it depending on their needs. Sometimes a given report can be used as base to create another which saves you time to deliver critical information in the least amount of time with the best results.
What I like most about Qliksense is the ease in which you can portray the information, also the duplicate function helps you to customise your sheet until you like it over and over again.
Also it's really easy to convert an information table into a pivot, graph (any kind), filter, etc.
Also the export feature as well as the filter can help you greatly to get just the information you want in the format you want.
Sadly when you work with a lot of information lines or put to much formulas into a report it will limit how you can export it (you have to filter by parts to get the full report) or it will not show the information and you will have to filter the overall report to just visualise the information you need.
We've used it to replace time consuming Excel reporting freeing up people's time, creating new dashboards for our warehouse, and identifying and digging into data and system issues that have arisen. Qlik Sense is certainly the quickest way to dig into issues when they are identified
Easy to use with plenty of self-service features for those who can't/don't want to dig into scripting and expression functions. Scripting engine means you can extract from a lot of data sources (Excel, SQL, API, Google Analytics...) and model to whatever your needs are. Also simple to use UI and can give users power to create their own charts using preset dimensions and measures
The main thing I have found is that sometimes it can be a big buggy. New features are coming out multiple times a year which is great but sometimes the odd bug creeps in.
It helped us greatly simplify our monthly management reporting and has been earmarked for a number of Reporting options going forward
Easy to use interface for data consumers and the ability to generate meaningful measures and KPIs quickly. We can post large amounts of data for our decision makers to digest and analyse without resorting to reams of spreadsheets. Uptake and feedback has been really good and most if not all users are pleased with the development so far and are looking forward to more applications in the pipeline going forward. Being able to find other user created plugins to manipulate data has also been really useful.
The data connections out of the box don't contain MDX and SSAS connections which would have been nice. The data designer isn't as good as some of its competitors and needing to learn another scripting language slowed down some of the early progress.
Qlik Sense has helped us analyze hundreds of millions of lines of data quickly and efficiently, with relative ease to how we were operating previously. We are one of the rare customers that does not work with sales data, rather security services with staffing levels, compliance performance variables, service forecasting, etc.
This has made it a little difficult to get help from the Qlik Community and Qlik directly as every example is geared towards financial information or selling goods. There is a distinct lack of resources out there if your company is in the same boat as us. We have had multiple staff members go through Qlik courses and we purchased the official book for Qlik Sense that was available at the time, which only covers the very basics.
Once you have your data connections flowing, and you spend the time learning and experiencing the product, you will start to benefit a lot more than taking the training (my opinion). The program itself is great, and it is amazing how fast and efficiently you can zoom in and out of enormous levels of data. My example would be to see a yearly total of hours billed, then each click zooms a level --> Year, Month, Week, Day, Hour, Minute of 900 staff members punching at 25 different locations at various times of the day at a 24 hour operation, then right back out to the yearly view. There is no slow down, the transitions are almost seamless.
The quickness and ease of building tables, charts, graphs, etc. in the front end.
There is a distinct lack of technical resources when you are not dealing with sales and financial data.
Great tool, easy to get started in your environment with the free trials. Easy to manage with Azure and overall cost effective with a low or high user count. Medium sized it is more costly than other solutions, unless you plan on eventually ramping up to 500+ users and can then leverage the token pricing model.
Puts self discovery in the hands of the analysts in each Business Unit. Let's us centrally manage data, governance and security with ease.
I do not like the "token" model for licenses, it is confusing and challenging to stay on top of. Paying for add-on connectors and features like GeoAnalytics and NPrinting is a turnoff, as they are very valuable tools, but should be included in the premium price of Qlik Sense already.
Qlik has never been a company to sit on it's hands as competitors eat up it's margins. As such, Sense is an obvious response to the simplicity and aesthetic beauty that Tableau brings to the table. Drag and drop analytics make Sense an amazing tool for power users still trying to bend Excel to their needs while providing many unique and compelling ways to share the knowledge gained.
In addition to simplicity, Sense is at home in a mobile environment. Build a single application and deploy to any device with a browser, be it your laptop or iPad.
The biggest shorfall of Qlik Sense is it's age. Though well thought out, the product is still underdeveloped and can at times feel like a beta product in the hands of a more seasoned BI specialist. Simplicity often comes at the expense of customization.
Easy of use that leverages productivity to the maximum and the final result that looks so much good.
Among many good features, Qlik Sense has a very good data load interface. The scripts are very easy to learn and also very powerful. You can transform and validate data at load step without have to know any programming language neither SQL, of course, if you know SQL you can make even more complex and complete scripts. The built-in and graphical data load tool is enough in many scenarios, you can even use it to generate the "gross" script and then refine it with your own rules.
Another good point is the customer support and knowledge sharing which exists in their forums, you can find almost anything you ever need there. I never needed to open a customer ticket for technical reason, but some questions regarding licensing and product availability has been quickly and completely answered by e-mail.
Some minor features which is already available in other BI tools, even on Qlik View, is not available in Qlik Sense. As an example, I miss some kind of "share expression/measure" function in this tool. When we create a measure, we cannot use this as a source to another measure, or to an expression, instead, we must replicate that logic any and everywhere it is required.
Qlіk Sеnsе hаs аll thе nесеssаrу tооls fоr vіsuаl рrеsеntаtіоn оf dаtа; іt іs lосаtеd іn thе tаb “Mаіn Elеmеnts”. All thеsе еlеmеnts аrе еаsіlу trаnsfеrrеd tо thе wоrk surfасе. It іs роssіblе tо сrеаtе nеw іtеms bу sіmрlу drаggіng. Sіmрlіfіеd funсtіоns аllоw уоu tо wоrk оn thе орtіоn drаg - аnd - drор. Thе sеlесtіоns іn thе рrоgrаm аrе vеrу sіmрlе, bаsеd оn Glоbаl Sеlесtоrs. Thіs funсtіоn аllоws уоu tо vіsuаllу сhаngе thе соlоr оf оbjесts, аnd sеlесts thе nесеssаrу dаtа fоr соnstruсtіоn.
In fасt, I dіd nоt hаvе аnу bіg рrоblеms fоr thе еntіrе tіmе оf usіng Qlіk Sеnсе.But thеrе аrе sеvеrаl nеgаtіvе роіnts оf thіs рrоgrаm. Thе рrоgrаm саn wоrk slоwlу іf уоu lоаd lаrgе dаtа оr іf уоu аrе nоt іn а gооd wіfі аrеа.
Qlik Sense is a lot easier to pick up and get going with than QlikView, but has most of the same underlying capabilities and benefits. It is also more of a self-service tool for business analysts as there's less technical skill required to build charts/graphs in Qlik Sense.
Qlik Sense is great, but to get the real power from it, you still need to learn Qlik's scripting language. It doesn't have quite the same level of functionality that QlikView has, but is catching up quickly. If you're dealing with large volumes of data, the hardware requirements can be quite large.
Fantastic BI Analytical Software that will help you knit your data together and discover new opportunities within your data for marketing and sales. As far as advice goes - do not underestimate how long it will take to design the interface itself once you've got all the data together.
Quick to process large data sets
Easy to merge differing data sets to a single view
intuitive tools to drive development
Great active online forum/blogs to help the less naturally gifted
It is fun to use and discover your data with
Initial steep learning curve to get up to speed
Set Analysis is not easy to pick up - misplace a bracket at your peril
Easy implementation of data clouds and BI analysis, increase the speed of data
processing thanks to the extraction logic in the QVD
it is continuously updated with interesting new features, it's user friendly, it is a program that takes into consideration the design and the new trends, it is nice to see and the animations on the graphics make it even more innovative
tokens are too expensive for a medium-sized company, the QMC is still a bit complicated to use. Updating qlik sense server is a bit tricky, (especially moving from Synchronized Persistence to Shared Persistence)
Overall I like this tool. I have worked on both QlikView which is a guided analytic tool and Qlik Sense which is a self service tool. Both has pros and cons.
1. It is self service BI tool, ease to use.
2. It has both ETL and Data Viz layer
3. Business user with structure data can quickly create dashboards out of it and share with others
4.It supports sending static reports through NPrinitng and embedding to another web application through Mash up.
1. It needs to add more visualization capability.
2. NPrinting development needs to be easy and less time consuming.
Connecting to data sources is simple and manipulating the data into a usable, non-bulky data model is simple using the Data Manager feature. Creating visualization is a breeze. There is plenty of assistance in the Qlik forums for anything you need help with.
As it is meant to be an easy-to-use design tool, there is little room for personalization and customization as these would be considered more advanced features. Sometimes it would be nice to be able to manipulate the objects as you can do in QlikView.
We are understanding our business in a deeper way than we could with our native reporting from our systems. We have been able to tackle labor, margin, and sales issues that would have otherwise gone unnoticed.
We have many different systems across our organization. We can use Qlik to pull in data from every source to help us analyze our the business is performing. We combine Qlik with NPrinting to automate many reports that are sent all around the organization.
We needed to purchase a separate piece of software to automate reporting.
I would highly recommend Qlik Sense to any company, regardless of size, because it is so easy to install, deploy, and use, and it's very affordable.
Easy to install, easy to learn, easy to train users. Deployment of Qlik Sense is very straightforward.
There's a bit of a learning curve for developers, most noticeably with Set Analysis expressions and data load scripting. This is not a huge hurdle, but it can be frustrating for some people. Luckily, there is a strong user community that is very responsive and willing to teach.
Strong Technology, Great Support. Very easy self service capabilities enabling 3rd Gen BI
More custom visuals and dashboard creation freedom
Overall experience is good. All in all a great product to work with. Has been in the market for sometime and still evolving.
there are multiple tools in the market and QlikSense overcome most of them in terms of cost. Features provided are more or less similar and they are still upgrading the product regularly.
Sometimes it becomes difficult to find out where the issue is. Since we moved altogether to this new platform, there was a bit of learning curve and to resolve it.
I like the most on this software is the reason why it is build, to provide eye candy dashboard solution. A beautiful and stylish dashboard with amazing functionality on dashboard navigation. Drilling down of data can be done with ease. Creation custom formula is very flexible. Sorting on what field you like is also possible.
I like the least on this software is price and the exporting of dashboard into image or pdf is not that nice.