Try our new research platform with insights from 80,000+ expert users
Franz Grubmüller - PeerSpot reviewer
Finance Manager at ELIN GmbH
Real User
A valuable solution for producing individual reports and linking reports, but needs better Excel integration
Pros and Cons
  • "Some of the valuable areas of this solution include producing individual reports and closing the gap."
  • "Right now, it is complex and you have to understand the data model prior to analyzing it, so basically I would like to see an integration with Excel in the future."

What is our primary use case?

We use this solution for standard reporting for cost and finance accounting. It creates VAT reports, balance sheets reports, and a lot of cost reports. You can split the company into departments and produce individual reports to deduct or extract, for example, German projects, which have to be brought for tax collection for Germany. Since ELIN is an Austrian company, we have to take out the part that has to be allocated to the German tax authorities.

From what I understand, we have data tables in proALPHA and then we have a kind of intermediate bridge, which is the Microsoft environment where this data is copied, and then from that database it is brought into Qlik Sense.

What is most valuable?

Some of the valuable areas of this solution include producing individual reports and closing the gap. Within proALPHA, it is not possible to implement a link of information from separate parts. This link can be done by Qlik Sense.

What needs improvement?

What would help is an Excel sheet that is linked directly to Qlik Sense so that instead of having to produce an Excel file, you would already have an Excel file that is connected to Qlik Sense. I don't know why it is not already set up this way because it would be more convenient. Right now, it is complex and you have to understand the data model prior to analyzing it, so basically I would like to see an integration with Excel in the future.

For how long have I used the solution?

I have been using this solution for two years.

Buyer's Guide
Qlik Sense
November 2024
Learn what your peers think about Qlik Sense. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,636 professionals have used our research since 2012.

What do I think about the stability of the solution?

The solution is stable and reliable. 

What do I think about the scalability of the solution?

The solution is easy to scale and about 20 people work with it in my company.
The rollout should be for the full user amount, which is roughly 200% from 20 to 200. But one main report is missing, and it doesn't make sense to roll it out because if they desperately need this one report and if it is not included or not completely correct in this new tool, then we would have understandable complaints from the users.

How was the initial setup?

Integration was my colleague's responsibility. It wasn't easy, and altogether it took about one year. My colleague used some consultants for support because it wasn't easy to understand, collect, and integrate the data in the correct way, but the rest he did himself. 

As far as I understand, there is a very low level of maintenance because he does as much as possible by himself.

What other advice do I have?

Some reports are not fully translated from the old QlikView version into the modern Qlik Sense, including some basic reports in the construction business. One main report is missing because if it was completely deployed in the new Qlik Sense system, QlikView could be closed forever because QlikView's so old.

QlikView only produces aggregated amounts, so you can never trim down in it. In Qlik Sense, it's the opposite. The results are produced by collecting the specific entries, so you always have to trim down, which is obviously the better approach.

Qlik Sense is a good tool for BI in order to connect in normal circumstances, but not for integrated data tables in big ERP systems. I would rate this solution as a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Intelligence Developer at Bonduelle SAS
Real User
Set analysis is great for its power user capabilities but the QMC needs more work
Pros and Cons
  • "Set analysis is great for its power user capabilities such as performing an IF on an aggregated column. The ability to create custom coloring expressions based on values is also a good idea although not as easy as I wished it was."
  • "The QMC needs more work. Some of the features should be available directly from the hub. Too many duplicates/publish. Intelli-sense when loading a stored qvd would help so much with remembering column names. The pop-up windows are too small when working in the QMC."

What is our primary use case?

Our primary use case of Qlik Sense is as a dashboard. It replaces some Excel grids we used to provide to people. We are currently serving only a few business units but are working on expanding to all other BU over time. We normally use this tool by loading data from our data warehouse into a QDF (Qlik deployment framework). This allows for better reusability at the cost of duplicate apps. We have also recently begun using Qlik Sense to load data from other sources, such as excel to help other business units that previously had no BI at all.

How has it helped my organization?

Qlik Sense did not improve our organization. Its use was forced by our parent company. We already have Cognos installed with dashboarding capabilities. The tool is good but we already have a clean data warehouse which means a lot of redundant work to load qvd files. It feels like Qlik was invented with a quick create report/throwaway when done mindset. We are not a company built around this so it makes reusing code very difficult. I must say the setup is easy and the user token is very flexible.

What is most valuable?

Set analysis is great for its power user capabilities such as performing an IF on an aggregated column. The ability to create custom coloring expressions based on values is also a good idea although not as easy as I wished it was. Its new trellis feature is great for not having to redo a lot of small charts multiple times and scales well over time. The ability to create presentations in the tool itself is good for users. This prevents having to copy/paste lots of images in an external document.

What needs improvement?

The QMC needs more work. Some of the features should be available directly from the hub. Too many duplicates/publish. Intelli-sense when loading a stored qvd would help so much with remembering column names. The pop-up windows are too small when working in the QMC. There is no reason why all the front-end is responsive but the publish windows are too small for most app titles to show up completely. I wish you could work directly in a published app instead of having to duplicate it to your content then publish it again when done. I also wish you could create folders in your own content to make sorting your apps easier.

For how long have I used the solution?

I've been using Qlik Sense for almost 2 years.

Which solution did I use previously and why did I switch?

We still use IBM Cognos but only for it's Excel grid features.

What's my experience with pricing, setup cost, and licensing?

I was not part of the evaluation team.

Which other solutions did I evaluate?

I was not part of the evaluation team.

What other advice do I have?

Good software but not for us at the moment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Qlik Sense
November 2024
Learn what your peers think about Qlik Sense. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,636 professionals have used our research since 2012.
PeerSpot user
Safety Data Analyst at Novo Nordisk
Real User
Good visibility on a single pane of glass, and one-click reporting saves us time
Pros and Cons
  • "The drag and drop functionality provides an easy and fast development approach."
  • "We have faced some issues with NPrinting, so I feel there is some improvement needed such that it would allow the use of variables and calculative fields from Qlik."

What is our primary use case?

We are in the Pharma industry and we get a lot of patient-related data for our products. This data contains post-marketing cases and clinical cases that my organization conducts, and we use Qlik to analyze the data.

We also use Qlik in some of the reporting we do with health authorities with different affiliates. We track the information sent to affiliates, whether the reporting was done on time or not.

We use the GxP setup, so it is very controlled and split by three different environments: Dev, Val, and Production. 

How has it helped my organization?

It has improved the amount of time it takes to get information out to the business in a few ways. It gives a detailed and high-level overview on one single page. We can generate reports with a single click, which saves a lot of time.

It has also helped by providing cleansed data to analysts so that they can create their own analysis. It also created an associate model that connects different data and combines them into one single view. We have a complex setup for our patient-related data and Qlik has fixed it.

What is most valuable?

On one click, it filters out most of the information, which gives an opportunity to drill down into the data. The drag and drop functionality provides an easy and fast development approach.

The associative searching and filtering capability is a unique feature among other BI tools, and one does not need to deeply understand the underlying data.

The powerful data handling and preparation ability to transform data is very helpful.

The associative model that connects the relevant column by looking at the same column names is a good feature.

      What needs improvement?

      We have faced some issues with NPrinting, so I feel there is some improvement needed such that it would allow the use of variables and calculative fields from Qlik.

      The reload error could be explained a bit more in detail, and if they can also include a debug mode in the load script while writing code, that could also advance the performance and minimize the effort.

      Lastly, if the Qlik Continuous Classroom could be available for free for trained users, that would be great.

      For how long have I used the solution?

      We have been using Qlik Sense for approximately the past five years.

      What other advice do I have?

      Overall, the product is very good so far.

      Which deployment model are you using for this solution?

      On-premises

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Business Analyst at H-Hotels.com
      Real User
      Helped handle the high cancellation rate in hotel management and slowly rearrange to the normal, pre-crisis level of bookings
      Pros and Cons
      • "Unique data visualizations created based on - among others - customer reviews and hands-on experience. Qlik is an experienced company in the Business Intelligence / Data visualization area, that doesn't necessarily mean it is the best solution, however, based on my personal experience it is much more complex than Power BI and Tableau as I've had some things to do with these two concurrent softwares."
      • "Even though a huge set of learning material is available, anyone starting his/her journey on learning the software doesn't even know where to start it. The so-called Continous Classroom service is not cheap, but there are many free tutorials, they are not sorted or enlisted adequately though."

      What is our primary use case?

      During the COVID-19 crisis, we used our live dataset to be visualized adequately by Qlik Sense and present them to the leadership in order to let them make the best decisions. As it turned out, they had to concentrate more and more on the never-seen-before cancellation rate in the hotel industry, and besides turning the deposit - where it was possible based on the contract - into cash-flow. Even though there were obviously many other factors on the spectrum, which couldn't have been influenced by our decisionmaking, Qlik helped a lot during this uncertain period.

      How has it helped my organization?

      The solution helped handle the high cancellation rate in the hotel management and slowly rearrange to the normal, pre-crisis level of bookings. Parallel it forced the company to figure out new plans to boost the new reservations, and since the outcomes of these ideas could have been translated into data, we had a chance to measure and visualize them with Qlik Sense, helping us select the best methods in the long term and turn off the ideas that didn't function as well as it was planned before.

      What is most valuable?

      Unique data visualizations created based on - among others - customer reviews and hands-on experience. Qlik is an experienced company in the Business Intelligence / Data visualization area, that doesn't necessarily mean it is the best solution, however, based on my personal experience it is much more complex than Power BI and Tableau as I've had some things to do with these two concurrent softwares. Even though you need to learn a programming language similar to SQL to bring out the most of it, it's totally worth it.

      What needs improvement?

      Even though a huge set of learning material is available, anyone starting his/her journey on learning the software doesn't even know where to start it. The so-called Continous Classroom service is not cheap, but there are many free tutorials, they are not sorted or enlisted adequately though. 

      Moreover, I'd personally be delighted with a hover function over the certain buttons in an app, I'm sure it will soon be a part of the package like many other ideas coming directly from customers and developers.

      For how long have I used the solution?

      More than 1 year.

      What do I think about the stability of the solution?

      The enterprise version is stable, the desktop version was a bit messy, but only a couple of times.

      How are customer service and technical support?

      Technical support could be better, but we don't need to contact them so often.

      Which solution did I use previously and why did I switch?

      We previously used Tableau and Power BI, I switched companies, not solutions, but I'm personally happy with Qlik Sense due to its complexity compared to the others.

      How was the initial setup?

      A 3rd party company created the first apps then we learned the programming language by ourselves and based on the created apps.

      What about the implementation team?

      We implemented with a highly expertised vendor team.

      What was our ROI?

      ROI cannot be exactly measured, but I'm sure it's worth it.

      What's my experience with pricing, setup cost, and licensing?

      A 3rd party company to create the first apps could be useful, if affordable.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Other
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Head BI SBU at a tech services company with 11-50 employees
      Consultant
      Leaderboard
      Drag and drop feature, and extension capabilities derived from the Qlik API are key
      Pros and Cons
      • "Takes the super features of QlikView ETL capabilities to a whole new level with its new drag and drop feature, and extension capabilities derived from the robust Qlik API."
      • "For a deployment scenario, Qlik Sense is also very easy to use. I can start development from any platform, on-premise or cloud, and continue from where I left off."

        How has it helped my organization?

        As a Qlik consultant, I have been using QlikView to design management dashboards but with Qlik Sense it offers more.

        What is most valuable?

        This is amazing product takes the super features of QlikView ETL capabilities to a whole new level with its new drag and drop feature, and extension capabilities derived from the robust Qlik API.

        What needs improvement?

        None at the moment. Qlik Sense for me combines the power of QlikView and the ease of use of Tableau.

        For how long have I used the solution?

        One to three years.

        What do I think about the stability of the solution?

        No stability issues at the moment.

        What do I think about the scalability of the solution?

        Just like QlikView, Qlik Sense has developed best practices to hasten and manage BI projects.

        How is customer service and technical support?

        The Qlik community is very vibrant and you find or get answers to most issues to get you started.

        How was the initial setup?

        With Qlik Sense, setup is pretty straightforward. For personal use, the desktop version is absolutely free, and you can share visualizations with others and to a personal cloud space, though limited with storage space.

        For a deployment scenario, Qlik Sense is also very easy to use. I can start development from any platform, on-premise or cloud, and continue from            where I left off.

        What's my experience with pricing, setup cost, and licensing?

        Qlik Sense pricing and licensing is like that of QlikView. It's on the high side for a small company, but it’s competitive among its peers. Use of licenses (referred to as tokens) is a bit confusing. There is a login access pass for infrequent or anonymous access.

        Which other solutions did I evaluate?

        As a consultant in the area of business intelligence and data analytics, I have had to personally evaluate Qlik Sense against other self-service BI tools such as Tableau, Power BI, and MicroStrategy.

        What other advice do I have?

        Invest in memory and RAM for the PC or server you intend to use Qlik Sense on. Ensure you have all the necessary resources and connectors installed for proprietary databases as well, if you are keen on some form of integration to web/projects.

        Disclosure: My company has a business relationship with this vendor other than being a customer: Qlik Partner.
        PeerSpot user
        PeerSpot user
        Manager Global IT Architecture at a transportation company with 10,001+ employees
        Real User
        Provides self-Service use of the desktop version with the ability to port applications into the server environment
        Pros and Cons
        • "Self-service use of the desktop version with the ability to port applications into the server environment."
        • "Ability for the administrator to approve Community Sheets in the QMC and then move them into base sheets."

        What is most valuable?

        Self-service use of the desktop version with the ability to port applications into the server environment.

        How has it helped my organization?

        Much more information is now available when meeting with vendors to discuss issues and trends.

        What needs improvement?

        Ability for the administrator to approve Community Sheets in the QMC and then move them into base sheets.

        For how long have I used the solution?

        We have used this solution for approximately 16 months.

        What was my experience with deployment of the solution?

        There were no deployment issues. It was easy to install with good on-line directions.

        What do I think about the stability of the solution?

        There were stability issues. The former synchronized persistence failed and caused database corruption.

        What do I think about the scalability of the solution?

        There are no scalability issues. RIM nodes are easy to add and performance monitoring is built into QMC.

        How are customer service and technical support?

        Customer Service:

        There is good customer service. There are no issues and they are very responsive.

        Technical Support:

        Technical support is decent. There is a lot of passing around to other other technicians for escalation.

        Which solution did I use previously and why did I switch?

        We did not use a previous solution.

        How was the initial setup?

        The initial setup was not complex. Just make sure to understand the architecture and use the online server planning tools.

        What about the implementation team?

        We used an in-house team, although the server architecture was planned with the Qlik architecture team.

        What's my experience with pricing, setup cost, and licensing?

        Understand the break over price point for switching to the Enterprise license.

        Which other solutions did I evaluate?

        We evaluated Tableau, Power BI, and Lumira.

        What other advice do I have?

        Utilize the resources Qlik has online. The white papers, support site, and training are all very good and worth the effort.

        Disclosure: I am a real user, and this review is based on my own experience and opinions.
        PeerSpot user
        PeerSpot user
        IT Manager at a reseller with 51-200 employees
        Real User
        You can build a very nice dashboard and/or report very quickly, even if your data is scattered between different files or even platforms.
        Pros and Cons
        • "You can build a very nice dashboard and/or report very quickly."
        • "Qlik has a fast learning curve due to great online training resources (Qlik continuous classroom), but those are lacking the advance features like building extensions and using the API."

        What is most valuable?

        Rapid Development is the most valuable feature to my humble opinion. You can build a very nice dashboard and/or report very quickly (simple reports can be ready in a matter of minutes!) even if your data is scattered between different files or even platform (excels, DB, etc.)

        How has it helped my organization?

        1. Managed to aggregate data from several separate legacy and cloud systems into one dashboard to validate expected correlation and insights.

        2. Managed to save valuable time to managers by building automated quarterly report, which serve them in the business plan meetings with their reps.

        What needs improvement?

        1. Qlik Sense (as for ver 3.1) is still missing some key functionality that Qlikview has.

        2. Qlik has a fast learning curve due to great online training resources (Qlik continuous classroom), but those are lacking the advance features like building extensions and using the API.

        For how long have I used the solution?

        QlikView - 2 years

        QlikSense - 1 year

        What was my experience with deployment of the solution?

        Was not involved in the deployment of the tools.

        What do I think about the stability of the solution?

        Not with the Qlik server.

        I did found out that our daily backup process fail to backup QVW files from the desktop.

        What do I think about the scalability of the solution?

        No

        How are customer service and technical support?

        Customer Service:

        Cannot rate since I hadn't used it yet.

        Technical Support:

        Technical support is very good due to the large active community.

        Most of the technical advise which I implemented came from posts of members in the community.

        Which solution did I use previously and why did I switch?

        No, I didn't use any other solution previously.

        How was the initial setup?

        I was only involved in the setup of the desktop edition tools, and they are straightforward.

        What about the implementation team?

        Used mixed teams. The vendor employees are very experienced and professionals.

        What's my experience with pricing, setup cost, and licensing?

        If you have users that don't need/want to do self-service analytics (which is the main advantage of Qlik Sense), consider buying less licenses for Qlik Sense and instead by a license for Nprinting tool (also a product of Qlik) which can be used to build and automatically send periodical reports extracted directly from the solution you already developed in QlikView.

        Which other solutions did I evaluate?

        No, I wasn't on the team who did the evaluation.

        What other advice do I have?

        Qlik is using what they call "Associative Model". While this is what give Qlik one of its benefits and for you (the developer/user) the ease of building rapid dashboard and reports, Make sure you truly understand this "Associative Model" before you are stepping into the role of building the data model for the solution.

        Disclosure: I am a real user, and this review is based on my own experience and opinions.
        PeerSpot user
        reviewer1412682 - PeerSpot reviewer
        Data Management Specialist at Marsh Limited
        Real User
        Modern and intuitive user interface that makes designing dashboards quick to do
        Pros and Cons
        • "Qlik Sense has a modern look and feel and a very intuitive UI, so non-technical users find it very user friendly."
        • "The on-demand report generation button in Qlik Sense currently doesn't work if NPrinting requires Okta verification, which our company uses."

        What is our primary use case?

        I work in the Data Solutions team at Marsh (Insurance company). We build Qlik Sense dashboards for Client Executives in the Specialties team, tailored to their requirements.

        The Client Executives can view their client's portfolio over several years and also see how Marsh is performing in the space. These visualizations help them with client and insurer meetings.

        Currently, it is being used for new client wins, client retention, negotiating with insurers, providing time efficiencies, and providing consistency in presentations.

        How has it helped my organization?

        Qlik Sense has a modern look and feel and a very intuitive UI, so non-technical users find it very user friendly.

        Our team has been able to deliver some very complex analytics that was possible only due to the powerful back-end functionalities and availability of extensions.

        The NPrinting functionality has also been very helpful for us, as it can deliver canned reports. It has saved a lot of hours for our business users.

        Dashboards we built on Qlik Sense have helped with new client wins, client retention, negotiating with insurers, providing time efficiencies, and providing consistency in presentations.

        What is most valuable?

        The time required to build a dashboard is very good, as it only takes a couple of hours to build a basic dashboard. We use this basic dashboard in our Client Executive meetings where we then start the ideation process and consolidate requirements for the final dashboard. We are able to show the Client Executives the art of possible, which helps them understand what can be done.

        It has helped us immensely with Data and Digital Literacy. Business users now understand the importance of data and data of good quality!

        What needs improvement?

        Several things can be improved, including:

        1. Ability to add and customize reference lines (average, linear regression, etc.) on all charts.
        2. There are features of QlikView that have still not come to Qlik Sense. These include "Always one value selected", option buttons, and checkboxes with extended functionalities in the Qlik bundle. I am currently using an external plug-in for this, but its performance is poor.
        3. Legends for charts that are being colored using a formula.
        4. Ease to add company color palette to Qlik Sense dashboard.
        5. The on-demand report generation button in Qlik Sense currently doesn't work if NPrinting requires Okta verification, which our company uses. So, we are not able to deliver this to our business users. This is a very powerful functionality and we want to use it!

        For how long have I used the solution?

        I have been using Qlik Sense for more than two years. Prior to that, I have also used QlikView for one year.

        Which deployment model are you using for this solution?

        On-premises
        Disclosure: I am a real user, and this review is based on my own experience and opinions.
        PeerSpot user
        Buyer's Guide
        Download our free Qlik Sense Report and get advice and tips from experienced pros sharing their opinions.
        Updated: November 2024
        Buyer's Guide
        Download our free Qlik Sense Report and get advice and tips from experienced pros sharing their opinions.