Qliksense for business
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.
Analyze data fast and make decisions quickly with Qlik Sense
Our goal was to have everyone reviewing business analytics in one spot and making decisions based on explainable data. We were Excel users for analytics at first. It was OK but we couldn't scale. We dabbled with Tableau. It was dreadfully slow and awkward. We demo'ed a couple more software and chose Qlik Sense due its speed, scalability and performance on mobile devices. Within days of using Qlik, our staff was able to convert 10 most used Excel dashboards into excellent dashboards that gave a much clearer perspective into business operations and finance. On modest server, we have been running Qlik Sense to provide enterprise-wide data analytics and our ability of decisioning has improved significantly due to Qlik.
Speed. Qlik Sense loads data quickly into memory and analysis is stunningly fast. It is very easy to get the information you need quickly and begin to make decisions. Slicing and dicing the data is very fast as well. Having used competing software like Tableau, Qlik Sense is a breath of fresh air. There's no waiting time during analysis and that keeps a person focused on the application and gets the person curious about information being presented.
The software's support model is horrific. Qlik uses value added resellers (aka VAR) for the most part. Most VARs I have talked to aren't exceptional and provide absolutely no valuable support after selling the software. They basically add zero value. Qlik has no idea what VARs are doing and VARs have no idea what Qlik is trying to tell them. Getting a license key correctly can take a few tries. Great software, horrific delivery. If I were the CEO of Qlik, I'd change the business model and remove VARs altogether and bring sales, marketing and support right into Qlik.
Best in class ETL capabilties combined with great visualizations and ergonomics
Qlik Sense is problably one of the quickest if not the quickest BI solution to implement. With Qlik Sense we were able to design and implement advanced business apps within days. The ability to go back and forth between data sources, data modeling and dashboard within the same interface enables a seamless production of even the most complex KPIs.
Qlik Sense is a powerful solution with best in class ETL capabilities, which simplifies and speeds up developments and enables a collaborative approach to data. Qlik Sense not only delivers great data visualization features but also offers a comprehensive set of tools which helps to collect data from various sources and deliver insightful dashboards. When it comes to interactivity Qlik Sense set the standard while the competition truly lies behind. I recommand any company on the market for a BI / data viz solution to consider Qlik Sense no matter what their size or industry.
I hope in the future Qlik will embed Nprinting features in order to generate pixel perfect documents from the Qlik Sense platform. Automated alerts also would be nice as well as a centralized data management for common dimensions and kpis between apps.
Top notch scalable self-service BI tool with cutting-edge visuals
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.
Perfect Self-Service tool
Qlik Sense - Rapid Development of Dashboards
Qlik Sense helps in rapid development of dashboards. The load scripts, data model viewer and the available visualizations have enabled us to create dashboards at a fast pace for demos and proof-of-concept apps.
Qlik Sense is a self-service visualization tool which users can learn to use within a short span of time. Adding the data sources is a smooth experience. Select the columns that's required, drag and drop into a new dashboard and we have a dashboard ready in minutes. The data model component helps to create associations/joins between the columns/fields of a table/file. The associative data model of Qlik Sense keeps the data associated across visualizations in a dashboard. Change a parameter and the whole dashboard gets reflected immediately. Qlik Sense also supports 3rd party extensions for visualizations and they are regularly monitored and approved by Qlik. Qlik Sense load scripts can be overridden to include custom code.
1) Cyclic Groups feature is missing. It was present in QlikView. We have to depend on qsVariable which is a 3rd party extension.
2) Trellis Chart is missing.
Extremely powerful analytics tool
We've used Qlik sense for a variety of different things. From analytics to financial statements and even reporting. If you have the experience, Qlik sense can be an undeniably strong tool for any business.
Qlik sense by itself can be a little lacklustre at times—but with the help of extensions—most problems and shortcomings can easily be overcome, making it very versatile in most situations.
On the other side of the coin, the base product can be lacking in some aspects without the use of said extensions. You need to do to research, as well as testing to find the right extensions to solve your issues.
Self-Service Reporting and Data Analytics
Ability to connect to multiple data sources, very easy to create powerful data models.
Many powerful visualizations to choose from (Pivot charts, trend lines, funnels, etc)
Lacks the design flexibility and some of the features that are available for Qlik View
Powerful BI tool that's now leveraging AI
Constantly evolving and building on features recommended by the user base.
Excellent range of out the box connectors and easy data source setup.
Leveraging AI and NLP which just improves the user-friendly nature of the product.
Advanced/customisable visualisations require third party extensions to be installed which add to cost.
Best Tool New BI, Good Value
It is self service analytical tool based on the business intelligence plate form
This tool open source community , user community is very good and also great people
It support for mostly new business users but existing not that much support
Architecture in the back end is very good
Solid application with a good balance between features, performance and usability.
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.
Data analytics for the masses
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).
Highly flexible and powerful analytics tool
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.
Qliksense is very easy to develop....
Overall very much satisfied with Qliksense. Daily KPI's and dashboards delivering to Top management was major task.
It is very easy to develop the dashboard reports. Most important point is the response time. it process data very fast and open dashboards having million of records due it's technology to store data. Overall it is world class Business Intelligence tool for any type of management (Top / Middle / etc). Nprint tool is very good and these dashboards and KPI's can be published over email.
Nothing as such. As of now it is very useful. All kind of features are available. Data export option is very useful.
Réponse de Qlik
Thank you so much Balpreet for the kind words! Glad you're finding value in Qlik Sense!
A work in progress, though it will get you there!
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'.
Scalable, customizable, easy to deploy and use reporting tool
Many business units in many locations within the company use Qlik Sense to report their KPIs and efficiency to everyone. All the IT has to do is create table and dashboard structure then the business unit can create its own reports and graphs according to its liking.
- It's scalable. Many business units in various locations in our company use it to report their big data.
- It's live and autonomous. Once it's deployed, it automatically creates up to date reports, so that nobody has to re-create new reports every time.
- It's online. Created dashboards can be viewed in any deviced, anytime as long as there's internet.
- It's easy to use for users to create their own graphics and reports. Not much effort for the IT team.
There's nothing to dislike in terms of functionality, UI and efficiency. Only thing I can criticize is that the name is confusing for some people in business unit. It is obviously chosen intentionally but they keep confusing Qlik with Click.
Rapid development and strong supportive community
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 Tool, good value!
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.
Great tool for data analysis
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.
Qlik was an great starting point on the company path to meaningful Business Intelligence
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.
QlikSense - Complete tool for BI
There isn't any problem that you can't tackle with QlikSense.
I like ETL within QlikSense. You don't need additional software or changes in your database or data warehouse to have full control about your data. You can do this ETL process within each app.
Some connectors are very expensive, for example SAP connector.
Réponse de Qlik
Thank you Gustavo!
Great software, easy to customize front end apps
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.
Qlik Sense is Powerful to use and Easy to Manage
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.
True Self Service BI with a few trade offs
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.
An easy to use and powerful BI tool.
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.