Lightning Tools Data Viewer vs. QlikView

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Lightning Tools Data Viewer
Score 9.1 out of 10
Mid-Size Companies (51-1,000 employees)
The Data Viewer provides data visualization in the form of reports or charts that can be created and customized to suit a business's needs. Silos of data exist in most organizations and yet contain valuable insights into how well the organization is performing and where action is needed. Those silos often include Microsoft Excel workbooks, Microsoft SQL Azure databases, On-Premises data sources accessible through OData or Business Connectivity Services and even SharePoint Lists. These data…
$1,250
per year per installation
QlikView
Score 8.1 out of 10
N/A
QlikView® is Qlik®’s original BI offering designed primarily for shared business intelligence reports and data visualizations. It offers guided exploration and discovery, collaborative analytics for sharing insight, and agile development and deployment.N/A
Pricing
Lightning Tools Data ViewerQlikView
Editions & Modules
Data Viewer OnPrem
$1,000
per year Per installation, 1 x WFE
Data Viewer Online
$1,250
per year per installation
Data Viewer OnPrem Enterprise Edition
POA
per year Per installation, 4+ WFE
Data Viewer Online Enterprise Edition
POA
per year per installation
QlikView
Custom
per user
Offerings
Pricing Offerings
Lightning Tools Data ViewerQlikView
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional DetailsPrices stated are minimum per installation for "stock" products. Enterprise editions can be amended to suit business needs if deemed necessary, additional costs incurred and TBD. All packages include free technical support. Free upgrades available to latest versions of tool as they are released. (online version)On an perpetual license basis, based on server plus number of users. Contact vendor for pricing.
More Pricing Information
Community Pulse
Lightning Tools Data ViewerQlikView
Top Pros

No answers on this topic

Top Cons

No answers on this topic

Features
Lightning Tools Data ViewerQlikView
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Lightning Tools Data Viewer
9.1
1 Ratings
8% above category average
QlikView
8.0
67 Ratings
2% below category average
Customizable dashboards9.11 Ratings8.065 Ratings
Report Formatting Templates9.11 Ratings8.059 Ratings
Pixel Perfect reports00 Ratings8.049 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Lightning Tools Data Viewer
8.2
1 Ratings
3% above category average
QlikView
8.3
66 Ratings
3% above category average
Drill-down analysis6.41 Ratings9.065 Ratings
Formatting capabilities9.11 Ratings7.066 Ratings
Report sharing and collaboration9.11 Ratings9.061 Ratings
Integration with R or other statistical packages00 Ratings8.336 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Lightning Tools Data Viewer
3.6
1 Ratings
77% below category average
QlikView
7.3
57 Ratings
10% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)3.61 Ratings7.754 Ratings
Location Analytics / Geographic Visualization00 Ratings7.546 Ratings
Predictive Analytics00 Ratings6.85 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Lightning Tools Data Viewer
-
Ratings
QlikView
7.9
61 Ratings
5% below category average
Publish to Web00 Ratings8.048 Ratings
Publish to PDF00 Ratings9.056 Ratings
Report Versioning00 Ratings7.542 Ratings
Report Delivery Scheduling00 Ratings7.347 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Lightning Tools Data Viewer
-
Ratings
QlikView
8.2
59 Ratings
4% below category average
Multi-User Support (named login)00 Ratings8.558 Ratings
Role-Based Security Model00 Ratings8.054 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.054 Ratings
Report-Level Access Control00 Ratings8.52 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Lightning Tools Data Viewer
-
Ratings
QlikView
8.0
47 Ratings
0% below category average
Responsive Design for Web Access00 Ratings8.044 Ratings
Mobile Application00 Ratings9.028 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.038 Ratings
Best Alternatives
Lightning Tools Data ViewerQlikView
Small Businesses
Cyfe
Cyfe
Score 8.8 out of 10
Cyfe
Cyfe
Score 8.8 out of 10
Medium-sized Companies
Mathematica
Mathematica
Score 8.2 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Sigma
Sigma
Score 9.3 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Lightning Tools Data ViewerQlikView
Likelihood to Recommend
9.1
(1 ratings)
8.5
(87 ratings)
Likelihood to Renew
-
(0 ratings)
8.8
(29 ratings)
Usability
-
(0 ratings)
8.2
(14 ratings)
Availability
-
(0 ratings)
9.8
(4 ratings)
Performance
-
(0 ratings)
8.6
(4 ratings)
Support Rating
-
(0 ratings)
3.3
(15 ratings)
Online Training
-
(0 ratings)
8.0
(3 ratings)
Implementation Rating
-
(0 ratings)
7.4
(13 ratings)
Product Scalability
-
(0 ratings)
8.9
(2 ratings)
User Testimonials
Lightning Tools Data ViewerQlikView
Likelihood to Recommend
Lightning Tools
Lightning Tools Data Viewer is well suited for re-surfacing data and customizing its look and feel.
Read full review
Qlik
Sales data validations have helped manage our justifications in the past, especially with regard to new product development and new business introduction. It has also been helpful in identifying trends with business impact and direction specific to quarter and monthly sales from ERP data as well as decisions to purchase equipment of staffing based on run rates and product demand.
One thing that can get out of hand is data output - if you aren't careful in your query, you may be overloaded with data dumps and drown in the amount of info you have to filter through. This is a user caution, not a comment on the software itself.
Read full review
Pros
Lightning Tools
  • Shows Lists created on different sites to be seen and controlled on another site in a Tenant
  • Allows selection of layouts and coloring way beyond what other programs do.
  • Easy to learn and very functional.
Read full review
Qlik
  • QlikView has a simple, relational data model that's REALLY fast. Filtering and changing data is dead simple results are almost immediately available.
  • The free version of Qlikview is almost completely featured, so you roll a pro-level product out to an entire department for really cheap.
  • QlikView is really flexible--if you can imagine it, you can build it.
Read full review
Cons
Lightning Tools
  • Data Viewer has a graph feature that is old school flat design. We loved the In House real 3D graph Lightning Tools program.
Read full review
Qlik
  • We found that QlikView can be a bit slow in supporting some forms of encryption. It is web-based and we needed to upgrade all of our server to not support the older SSL and TLS 1 protocols, only support TLS 1.2 and TLS 1.3. However, QlikView could not run with TLS 1.2 and TLS 1.3. We had to wait over six months to get a version that would handle the newer TLS versions.
  • There are so many options with QlikView that you can get lost when developing a visualization. There are still items I have not yet figured out, such as labeling a graph with the name of a selected detail item.
  • QlikView works by pulling the data it is going to use for visualization into its database. I am a security reviewer and I need to make certain that PII and PHI is not pulled by QlikView for a visualization, otherwise this could become a reportable indecent.
Read full review
Likelihood to Renew
Lightning Tools
No answers on this topic
Qlik
Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.
Read full review
Usability
Lightning Tools
No answers on this topic
Qlik
QlikView is very easy to implement. The installation is very straight forward. QlikView has several different data connectors that can connect to different data sources very smoothly. The user interface to build the reports is very easy to understand. This helps to have a smaller learning curve. Something very helpful is that QlikView is a browser application for the end users. So, you don't need to install any applications on the user's computer.
Read full review
Reliability and Availability
Lightning Tools
No answers on this topic
Qlik
We have not had any downtime issues with the product nor uncovered any significant bugs
Read full review
Performance
Lightning Tools
No answers on this topic
Qlik
It is not a SAAS product.
Read full review
Support Rating
Lightning Tools
No answers on this topic
Qlik
My experience with the Qlik support team has been somewhat limited, but every interaction I have had with them has been very professional and I received a response quickly. Typically if there is a technical issue, our IT team will follow up. My inquiries are specific to product functionality, and Qlik has been very helpful in clarifying any questions I might have.
Read full review
In-Person Training
Lightning Tools
No answers on this topic
Qlik
My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
Read full review
Online Training
Lightning Tools
No answers on this topic
Qlik
Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
Read full review
Implementation Rating
Lightning Tools
No answers on this topic
Qlik
"Implementation" can mean a few things... so I'm not sure that this is the answer you want.... but here it goes: To me, implementation means: "Is the user interface intuitive and can I produce meaningful reports with ease?" On that score, I'd say YES. The amount of training required was minimal and the results were powerful. The desktop implementation is a simple, "blank" interface just waiting for your creativity. The pre-populated templates give you a reasonable start to any project -- and a good set of objects to "play around with" if you're just getting started. Finally, note that the "implementation" I used was baked into QuickBooks 2016 Enterprise -- called "Advanced Reporting"..... That integration makes it ultra useful and simple.
Read full review
Alternatives Considered
Lightning Tools
Lightning Tools Data Viewer is much easier and more powerful than Infowise similar viewer in their lineup. In this case, we use Data Viewer over the one offered by Infowise.
Read full review
Qlik
The only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau
Read full review
Return on Investment
Lightning Tools
  • It allows us to do things that would take a great deal more time to duplicate in SharePoint
  • It cuts down on ugly looking built in SP list layouts
  • Users find it easy to access, thus this product is more productive
Read full review
Qlik
  • You can use the free desktop version to do a lot of reporting and analysis work more quickly so the ROI is huge
  • QlikView is great at finding outliers such as data entry errors
  • QlikView is great at helping you quickly discover new insights about your business that can prompt you to take action that can immediately affect your cash flow.
Read full review
ScreenShots

Lightning Tools Data Viewer Screenshots

Screenshot of DISPLAYING EXTERNAL DATA WITHIN SHAREPOINT OR MICROSOFT TEAMS
The Data Viewer Client Side Web Part can be configured by Business Users within a few minutes to display Line of Business Data from Data Sources such as Excel,  SQL Azure, Business Connectivity Services, OData and SharePoint Lists.  Connections to an organizations data such as Customer Relationship Management Systems, Accounting Systems, or Custom Databases can be connected, giving business users a live up-to-date view of business information within the context of their SharePoint Team Sites or Microsoft Teams Tabs.Screenshot of HIGHLIGHTING KEY BUSINESS DATA (NO CODE)
Conditional formatting can be used to highlight key business data. Overdue Tasks, Low Stock, Currency Exchange Rates, Sales Revenue are examples of data to highlight visually allowing for a quick reaction time. Key Financial Indicators and Key Performance Indicators can be configured with a simple dialog and no need to write any code. Choose colours, icons or data bars to highlight key data.Screenshot of SELECTING AND STYLING ICONS
Icons can be chosen as part of the conditional formatting to make data stand out. The Office 365 Fabric icons can be selected and styled and applied to cell values. Pepper pots, Smileys, Envelopes and more icons are available. There are hundreds of options to choose from to highlight data that needs to be acted upon.Screenshot of DATA VIEWER CAN BE A GRID OF DATA OR A CHART IN SHAREPOINT OR MICROSOFT TEAMS
The Data Viewer can be used within Microsoft SharePoint Modern Sites or Microsoft Teams Tabs as a Grid of Data with styling or as a Chart which can be configured. The Charting Feature allows for Pie, Donut, Column, Line, Area, and Scatter Charts which can all be configured and displayed in 2D or 3D.Screenshot of TREEMAPS
summary information can be displayed within a TreeMap next to the detail. Users will be able to see trends, and how the business is performing  using the TreeMap view of data.Screenshot of CHARTS AND GAUGES
The Data Viewer is used to represent data in multiple ways using Gauges, TreeMaps, Multiple Series Charts, and Pie Charts.

QlikView Screenshots

Screenshot of QlikView Sales DashboardScreenshot of QlikView on all devicesScreenshot of QlikView using mobile touch screen