Overview
What is QlikView?
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.
Qlik: Useful and Handy BI Tool
Quick overview of QlikView
QlikView is a great tool for any firm, highly recommend
Perfect for data visualizations at the organization or department level
Own your information with Qlik Technology!
Banking with QlikView
It helps represent and simplify by using their …
Great tool but expensive
QlikView user review
QlickView for Big Data gathering and solution
QlikView comes to ease data analysis for higher management
Great analysis software for your report and dashboard needs!
QlikView: Decent BI tool
Better than some, less expensive than most.
A great product that is easy to use, but it does have some slight issues with integration as well being too expensive
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Customizable dashboards (62)8.585%
- Drill-down analysis (62)8.181%
- Report sharing and collaboration (59)8.181%
- Formatting capabilities (63)7.575%
Pricing
QlikView
Custom
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
QlikView Presentation HD
Qlikview Online Training - Qlikview Free Demo Video - Bigclasses
QlikView Tutorials for Beginners | QlikView Demo | Free Qlikview Training
QlikView for iPad
QlikView & Google Maps - Real Estate Demo
QlikView Export & Import Document Layout XML
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 8.8Pixel Perfect reports(47) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 8.5Customizable dashboards(62) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 7.5Report Formatting Templates(57) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 8.1Drill-down analysis(62) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 7.5Formatting capabilities(63) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 8.3Integration with R or other statistical packages(36) Ratings
Integration with the open-source R predictive modeling environment.
- 8.1Report sharing and collaboration(59) Ratings
Report sharing and collaboration is the ability to easily share reports with others.
Report Output and Scheduling
Ability to schedule and manager report output.
- 8.4Publish to Web(47) Ratings
- 8.2Publish to PDF(54) Ratings
- 7.8Report Versioning(40) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 7.3Report Delivery Scheduling(47) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
Data Discovery and Visualization
Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.
- 8.1Pre-built visualization formats (heatmaps, scatter plots etc.)(51) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
- 8Location Analytics / Geographic Visualization(44) Ratings
Location analytics is the visualization of geographical or spatial data.
- 6.8Predictive Analytics(5) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.
Access Control and Security
Access control means being able to determine who has access to which data.
- 7.2Multi-User Support (named login)(56) Ratings
Named model access means that users have access based on name and password.
- 8.2Role-Based Security Model(52) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 8.1Multiple Access Permission Levels (Create, Read, Delete)(51) Ratings
Multiple access permission levels means that different levels of users have different rights.
Mobile Capabilities
Support for mobile devices like smartphones and tablets.
- 7.9Responsive Design for Web Access(42) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 7.6Mobile Application(27) Ratings
A dedicated app for iOS and/or Android.
- 7.3Dashboard / Report / Visualization Interactivity on Mobile(36) Ratings
In-app dashboard reports and data visualization.
Product Details
- About
- Competitors
- Tech Details
- Downloadables
- FAQs
What is QlikView?
QlikView, Qlik’s classic analytics solution, aims to revolutionize how organizations use data, boasting an intuitive visual discovery that put business intelligence in the hands of more people than ever. Qlik Sense, the vendor's next-generation analytics platform, supports the full range of modern analytics use cases at enterprise scale by combining the Associative Engine with Cognitive Engine driving augmented intelligence, plus a scalable, governed cloud architecture.
As businesses modernize operational processes including BI, Qlik Sense is provided by the vendor as a way forward. Through the Qlik Analytics Modernization Program, QlikView users can adopt Qlik Sense at their own pace for a small uplift on their annual maintenance rate -- which Qlik states will expand the enterprise's analytic possibilities while reducing the total cost of ownership for BI.
QlikView Features
BI Platform Features
- Supported: Administration via Windows App
- Supported: Administration via MacOS App
- Supported: Administration via Web Interface
- Supported: Live Connection to External Data
- Supported: Snapshot of External Data
- Supported: In-memory data model
- Supported: OLAP (Pre-processed cube representation)
- Supported: ROLAP (SQL-layer querying)
- Supported: Multi-Data Source Reporting (Blending)
- Supported: Data warehouse / dictionary layer
- Supported: ETL Capability
- Supported: ETL Scheduler
Supported Data Sources Features
- Supported: MS Excel Workbooks
- Supported: Text Files (CSV, etc)
- Supported: Oracle
- Supported: MS SQL Server
- Supported: IBM DB2
- Supported: Postgres
- Supported: MySQL
- Supported: ODBC
- Supported: Cloudera Hadoop
- Supported: Hortonworks Hadoop
- Supported: EMC Greenplum
- Supported: IBM Netezza
- Supported: HP Vertica
- Supported: ParAccel
- Supported: SAP Hana
- Supported: Teradata
- Supported: Sage 500
- Supported: Salesforce
- Supported: SAP
- Supported: Google Analytics
BI Standard Reporting Features
- Supported: Pixel Perfect reports
- Supported: Customizable dashboards
- Supported: Report Formatting Templates
Ad-hoc Reporting Features
- Supported: Drill-down analysis
- Supported: Formatting capabilities
- Supported: Integration with R or other statistical packages
- Supported: Report sharing and collaboration
Report Output and Scheduling Features
- Supported: Publish to Web
- Supported: Publish to PDF
- Supported: Output Raw Supporting Data
- Supported: Report Versioning
- Supported: Report Delivery Scheduling
Data Discovery and Visualization Features
- Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
- Supported: Location Analytics / Geographic Visualization
- Supported: Support for Machine Learning models
- Supported: Pattern Recognition and Data Mining
- Supported: Integration with R or other statistical packages
Access Control and Security Features
- Supported: Multi-User Support (named login)
- Supported: Role-Based Security Model
- Supported: Multiple Access Permission Levels (Create, Read, Delete)
- Supported: Report-Level Access Control
- Supported: Table-Level Access Control (BI-layer)
- Supported: Field-Level Access Control (BI-layer)
Mobile Capabilities Features
- Supported: Responsive Design for Web Access
- Supported: Mobile Application
- Supported: Dashboard / Report / Visualization Interactivity on Mobile
QlikView Screenshots
QlikView Videos
QlikView Competitors
QlikView Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Mac |
Mobile Application | Apple iOS, Android, Windows Phone, Blackberry, Mobile Web |
Supported Countries | Americas, EMEA, APAC |
QlikView Downloadables
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(792)Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
QlikView has proven to be a versatile and valuable tool for various use cases across different industries. Users have built reporting and dashboards based on accounting and operations data, allowing non-experts to explore data and identify potential prospects and targeted populations. With QlikView, the entire company has relied on data to inform their decisions, providing a flexible report builder that is used across multiple departments. The Sales team has utilized QlikView to track and identify hot leads, understand buying patterns, and analyze the sales life cycle.
Moreover, QlikView has been successfully implemented in the education sector at a university, where dashboards were developed for different entities within the institution. It has consolidated various data sources and systems, allowing users to view reports and filter data for reporting purposes. By organizing data from different systems that would not communicate with each other, QlikView addressed the issue of having to look in multiple places for similar data. In addition, it has provided granular information about SKUs and sales to enable informed decision-making on promotions in the marketing department.
Furthermore, QlikView has been instrumental in addressing business intelligence needs for customers across various domains such as marketing, finance, selling data, HR management, projects management, financial management, and R&D. The software allows key users within organizations to access highly-interactive analytics applications and dashboards that provide different points of view on the same data. It has also served as an enterprise analytics solution by creating dashboards containing HR, payroll, finance, training, and other data, reducing ad hoc reports and increasing communication and awareness. Moreover, QlikView's ability to visualize data quality management dashboards empowers business users, management, and executives to make decisions based on real-time changes.
Additionally, QlikView has supported ETL processes by ensuring data integrity between disparate product sources while identifying data gaps. Its capabilities extend beyond reporting needs as it generates C-Level reports and day-to-day operations reports, providing valuable insights across multiple levels of management. As a business intelligence tool, it has been successfully utilized to analyze and create reports from large datasets such as NIH clinical trial data, showcasing its ability to handle complex joins and produce clean reports.
Overall, QlikView is lauded for its speed, ease of use, and intuitive dashboards that allow users to navigate their data effectively. Customers have also relied on QlikView during tough times to identify and save money that would otherwise be wasted without resorting to layoffs. Its adaptability, performance
High Speed and Agility: Users have consistently praised QlikView for its high speed and agility in data visualization, with many stating that the software allows them to quickly navigate from a high-level view to granular details. This speed and agility enhance the overall data visualization experience, making it efficient and seamless.
Intuitive Data Exploration: The associative search feature in QlikView has received high praise from users for its intuitive and efficient data exploration capabilities. Many reviewers appreciate that it eliminates the need for predefined drill paths, allowing them to visually explore the data and go anywhere they want without restrictions. This feature greatly enhances their ability to analyze data effectively.
Powerful Data Loading Capabilities: Users highly regard the data loading capabilities of QlikView, considering it a powerful platform that can be extended and incorporated into web pages. The ability to integrate with the R open-source engine and build custom extensions adds to its versatility and usability. Several reviewers have mentioned this as a key strength of QlikView.
Confusing User Interface: Some users have expressed frustration with the software's user interface, stating that it is confusing and hinders their ability to perform tasks efficiently. They feel that the design or layout of the interface is not user-friendly.
Unhelpful Customer Support: Several users have voiced their dissatisfaction with the customer support provided by the software. They have found the support team to be unhelpful in addressing their concerns or providing timely assistance when needed.
Recurring Error 429: A common issue reported by multiple users is encountering recurring error messages with status code 429 while using the software. This has caused inconvenience and has disrupted their workflow on numerous occasions.
Based on user reviews, users commonly recommend the following for Qlik View:
- Spend time researching the true power of the tool and learning from other users' innovations in the online community.
- Get trained and utilize the support and assistance provided by Qlik View to make sure that the program is being used to its full capabilities.
- Have a designated code writer to make the processes of deployment easier and more proficient.
These recommendations highlight the importance of exploring the tool's capabilities, leveraging available resources, and making informed decisions to optimize the usage of Qlik View for complex businesses.
Attribute Ratings
- 8.8Likelihood to Renew29 ratings
- 9.8Availability4 ratings
- 8.6Performance4 ratings
- 8.2Usability14 ratings
- 3.4Support Rating15 ratings
- 8Online Training3 ratings
- 7.4Implementation Rating13 ratings
- 8.9Product Scalability2 ratings
- 8.7Data Visualization3 ratings
- 7.8Data Sources43 ratings
- 7.8Data Sharing and Collaboration43 ratings
Reviews
(51-75 of 83)Qlikview review
Pros: Good data connection Flexible Easy to use
Cons: Lack visual appeal in its default mode; Inconsistent behaviour when stretched capability
- Layers
- Customisable
- Integration of ETL
- Transition in visualisation
- Story telling
- Geo mapping as standard
Why QlikView? - Review
- Graphics-enabled presentations, graphic manipulation
- Highly interactive applications, dashboards and reports.
- Extracts data from sources such as Oracle, SAP, Salesforce, SQL Server and Excel
- It's intuitive, fast, simple and easy to use
- In essence QlikView helps users understand consolidating complex data, simplifying data visualization, and providing real-time access to analytics.
- Business intelligence can create QlikView extensions, design business apps, and manage data definitions, this needs to be simplified and a bit more accessible.
- Lack of single, easy manageable and scalable security model limits areas of applicability for QlikView. Currently, in order to manage user access rights one should set them up in various places.
When to use Qlikview and when to go with a competitor
- Dashboards can be created easily with basic programming skills. A typical business analyst will not require a developer once the underlying data model is in place.
- Qlikview can be used as a web based application allowing users to access dashboards anywhere permissions allow.
- Qlikview provides a variety of pre-built objects that gives designers flexibility to represent data in multiple ways.
- Qlikview has its own database and management system. Developers are required to build a new data model to get data into Qlikview.
- Qlikview's web application requires significant memory and processing power from the browser. Complex dashboards can crash your browser if you're running too many things at once.
- Qlikview dashboards look relatively outdated.
Review angel!
- Good graphs which help users to analyze well, if presented and explained properly.
- API is a plus..for example, GPS which is very useful in the real estate world.
- Good data visualization.
- It would be good if there was an option to display on top of the pies in the 3D pie chart. Users always ask for it.
- 3D charts display could be improved.
Pretty @#$% Awesome
- QlikView, because of the way it stores everything in RAM, is extremely fast.
- QlikView allows you to explore relationships between data elements that might otherwise be overlooked.
- It has a very sophisticated, robust programming "language" and allows for virtually unlimited customization.
- While powerful, the syntax of the commands, particularly with respect to dollar-sign expansion and set analysis, can be exceedingly arcane. I can't even remember right off hand how many different duties the dollar-sign is involved in, but it seems like they could have figured out a way to make it a little less confusing. On the other hand, mastery of set analysis, advanced aggregation, and dollar-sign expansion is what separates the men from the boys.
- I'd personally like to see a wider variety of built-in chart types.
Still in love, after 12 years of use!
We used QlikView to analyze Sales, and then Profit Margins, and then Excess and Obsolete Inventories, and then transportation costs, and so on and so forth. within 5 years, QlikView become a valuable business tool on every desk in the company.
Since then, the technology world around us had changed a lot - our computers are now using 64-bit operating systems, and a nifty laptop is now more powerful than the most powerful server back in the days. The capabilities of business software had changed as well. Today, QlikView is not a niche tool anymore, it's a flagman tool in the market of Data Discovery (Qlik likes to call the same term Business Discovery). However, the core value remains largely the same:
With QlikView, we can load large amounts of data and build beautiful and insightful visualizations with an unmatched speed. Using the recent advances in technology, we can empower our users to navigate their data in the most liberating and powerful way.
I won't be the first to state that modern companies collect, store and process vast amounts of data. BI tools are trying to help people make sense of that data, and QlikView is by far my favorite tool for this task. We think that we know our business. However, the "million dollar" question is what we don't know about our business? For me and many of my customers, QlikView has become an eye opener, in the way it helped companies realize how much they don't know about their business:
- As a manufacturer, do you know what products are truly profitable and to what extent, considering all the customer programs, allowances, chargebacks etc?
- Do you know what products in your inventory are turning fast and what products are sitting there for years?
- Do you know your true service levels with your customers, and how they are trending in time, and what are the possible reasons might be?
- Do you know if vendor payment terms are consistent across your corporation, or do you lose money on various unfavorable payment terms?
- Do you know how your customers are paying you? Do they comply to your payment terms? Are you paying them chargebacks while they are being late on their commitments?
- Do you know if your employees follow your travel policy, and how much does it cost you when they don't?
All of those questions have one thing in common - if you don't know the answer, you are likely to be wasting money that could be saved.
When things are getting tough, companies tend to resort to layoffs and tough decisions... With the help of QlikView and advanced business analytics, we can find money in a haystack of data and help companies get better without necessarily laying people off. There is a lot of money wasted in the process, and QlikView is an excellent tool that can help us find it, save it and put it back to work.
- QlikView is extremely effective in its ETL capability. In comparison to Tableau and other modern tools, QlikView has the best data loading capabilities, making it extremely easy to load data from multiple disjointed data sources and build a cohesive data model that supports your needs.
- Flexibility. With QlikView, making changes to an existing application is extremely easy. Since we don't need to mess with multi-dimensional cubes, developing and changing data models and visualizations is easy and fast
- Quick learning curve. It's very easy to get educated and become proficient on QlikView. New developers become productive after just a few days, and then continue learning more advanced techniques while already delivering value to their companies.
- Deploying and managing QlikView in a huge environment, with many servers, many locations and many users, can be still challenging. The management tools are very good for managing one or a few servers. When the environment needs to scale up by a lot, the management and monitoring tools may not be as efficient.
- you need to load data from multiple sources
- develop actionable dashboards with information aggregated at multiple levels
- help people focus on issues that matter most
- enable Data Discovery by users, with minimal dependency on IT resources.
QlikView is less recommended when:
- loading high-frequency real-time data for real-time reporting
- Associations between disparate sources.
- Entities that are NOT used/NOT associated (although supposed to be).
- N-LOOKUP/hierarchical data visualization (example: hierarchically organized Operational codes, prices, business conditions and busn programs).
- Makes good compression of data for up to 100 Mln transactional rows (I have compared head-to-head with SSAS cubes=not indexed). QLV works faster. Give QLV at least 32 Gig of RAM on 64 bit architecture, you will see the instant response for many millions of transactions, with instant grouping and counters.
- Data extraction from sources is separated from graphical part. This means you can provide ETL part (extract/periodical extract from sources) separately, and populate QVD (intermediate compressed format for all users). All users will connect their QLV reports to this QVD format, thus NEVER loading/affecting the (OLTP/DW) source at all.
- GUI interface is simple enough. Copying of the controls is simple. Filter selections, made in the controls by user, are saved by default/reproduced on QLW report closing/reopening. In other words, user keeps his/her specific business context. "Current Selections" (a simple GUI control) allows to visualize the business context.
- Actions/Triggers (on a document/tab or user level) allow to pre-populate user filter selections.
- Outrageous marketing: all QLV manuals start with the words; "Lets take a flat file as Data Source". Information is NOT supposed to be kept in Flat files. This is written in the Chapter 1 of any Introduction to Data Processing text book in the world.
- QLV first mentions of the POSSIBILITY of the connection to relational DB on the page 200 of the QLV manual(!). In fact, the Relational Data base source is the "second class citizen" in QLV. You have to go into data extraction Script, instead of just specifying OLE DB or ODBC as a data source!
- Qlikview sales people could answer the simple question: does QLV work against relational DB- yes or no? Their answer was: "The question is too technical". The company clearly does not understand how to position its (absolutely wonderful) product. As a BACKEND data discovery and analysys product.
- They will NEVER EVER use the word: "Relational DB Source" and "Powerful ETL capabilities" in their marketing. It is 100% concentrated on GUI part/interface and their QVD (compressed proprietary format) storage. NOT on real-life data extraction from real DB source. That is a shame, Marketing department does not understand their target audience.
- QLV help files are rudimentary, do not give good examples on actual DB data extraction and analysis. They might have done it on example of Microsoft Sample Databases - this was never done.
- You can specify the % of RAM memory consumed by QLV. On reaching this percentage, QLV, unfortunately, becomes unresponsive. Abort (of the running script) does not work well. Modality of the script window and of help files is not chosen correctly. QLV may hang and crush on large data.
- Existence of duplicates, data gaps, missing data.
- ETL delivery (validation/direct comparison, driven by hash values on source and target).
- Operational processes with multiple (disjointed/independent) sources.
- Flat and XML file comparison.
However, to go beyond, you will need to introduce meaningful composite keys, hash values for columns being compared, review case sensitivity of the values, analyze for cross joins/absence of relationship for some of the entities.
Click to view! No waiting in Qlikview.
- One of the main strengths I always bring up is the associative technology, which is the Green-Gray-White concept. This Qlikview functionality brings more intuitiveness to the applications in a very natural and efficient way.
- In-memory technology brings very quick and easy switching between field value selections, since ALL the data is stored in the RAM. Information is already available on click. This is very advantageous particularly for customers not very fond of the usual 'enter parameters, run report and wait 5 mins or so'.
- Ease of design and development. Qlikview can be as simple as creating reports in Excel, with minimal training, but at the same time seasoned developers can utilize technical and complex functionalities to bring out the most efficient methods and deliver difficult requirements.
- Availability for a mobile and tablet version of the application without additional development required. Everything is done by the server.
- Qlikview can be used 'on top' of other BI tools, much like Excel is usually used as the final presentation for reports.
- In-memory technology requires large amounts of RAM, and real-time data availability is not possible. Data is only limited to the last reload or refresh of the application.
- A corporate complaint I always hear: Expensive Licenses. Perhaps this can be remedied by having more variations.
- Not really a weakness, but for non-technical users looking to develop applications, a level of familiarity of proper data modeling and design techniques are needed to ensure information accuracy.
- Client is only available for Microsoft Windows systems, so development is only limited to that. Nonetheless the users may access the application using any platform with a web browser.
Choosing the Right BI Reporting Platform
- Fast - everything is in memory so it moves away from the traditional logistics of reading data from disc.
- Interface is fast to develop. Once a thoughtful data model is setup. The frontend development is fast and allows a RAD environment.
- The server itself is easy to maintain. Maintenance is low and does not need a typical "sys admin" to manage this reporting server
- Visualization - Graphically beautiful and provides that "bells and whistle" factor
- The relationship of how data models are put together in QlikView - it requires good level of technical understanding how models are put together. If they had an ERD like framework when opening up an existing dashboard it would be helpful.
- The licensing model QlikView employs financially does not make sense for growing small companies.
- The support of AJAX technology is not up to par with its predecessor, IE plugin. They could do much better job implementing the same features in IE plugin over to AJAX users. The migration will be much simpler since AJAX will be the standard under Qlikview's new future versions.
QlikView ReView
- Works quickly with large datasets - I have created 20+ applications with my current company and previous company, all on average with 30 million + unique rows in the core billing table, and have yet to have any significant performance depreciation.
- Data Visualization - Easy to create detailed and adaptable reports that can meet any departments need
- Developer friendly - Supports SQL well, can create elegant data models/schema only using SQL (though it is encourages to use QV's native language)
- High price point - while we would love to use QlikView for all reporting at my current company, it is far to expensive to but licenses for non-managers
- Can only develop via application (as opposed to using an online client) - I believe they intend to eliminate the application and have everything be web based, however currently that is not the case. Many other BI tools allow online development.
- Users do not have the ability to easily create ad hoc reports - while as a developer I can create an application that allows users to make ad hoc reports, there is no functionality to do this natively (or in a relatively easy way).
1) Licenses aren't cheap, I would not recommend QlikView for basic reports that can be done in other (cheaper) tools such as SSRS.
2) If the report is basic (just display a few tables with some headers) I'd recommend a simpler tool such as SSRS or automated email of a csv daily (using SQL + .NET).
3) Similar to above, if the underlying data model isn't too complicated, using QlikView can be overkill.
a magical tool that changes your world of data
- QlikView is a very useful tool for errors in the data set(data discovery)
- Useful for the data analysis for data from different sources
- You can easily create custom groups for different dimensions that are critical for business purposes.
- Syntax check for set analysis
- Some more integrated charts for front end
- More tutorials for QMC and server management
QlikView Review
- Many Different Visual Display Options, ie, charts, graphs, data tables
- Filtering and Manipulation is extremely easy. You can potentially filter or group by any field in your load statement.
- You can have many iterations of the same data shown on one tab, or have many tabs.
- Cloning existing tabs or charts is easy and fast
- A Load Builder (Similar to a query builder) would be a nice feature
- Provide distribution capability w/in Small Business Server
- Better Selection box controls. Make it easier to do AND / OR filters without coding.
User Review of QlikView
- ETL! QlikView is the simplest product that not only provides great visuals for UI but it also handles complex ETL.
- Easy to implement. We have successfully installed QlikView server and desktop within one week with a fully functional dashboard published for end users.
- DATA DISCOVERY! The green/white/grey is such a powerful tool. The first thing I do when II arrive onsite with a client is connect to their data and jump right into the data. The grey is the most valuable. I can see what is NOT relating to my selections. This is not possible, so far, in any other business discovery tool.
- Set Analysis! Qlikview's set analysis allows me to calculate from the very basic to the super complex expressions. It does not take long to learn either.
- QLIK COMMUNITY! The community consists of master users and Qlik employees and basic to new users. It is a huge resource for all users and allows you to get answers quickly then copy script and/or dashboards so no need to recreate the wheel.
- ITS FREE forever and fully functional. You just cannot open licensed applications. What a great marketing tool. QlikSense will be free forever with the ability to share your applications! Just gets better.
- Licensing model could be easier to understand. It is not bad, but takes a while for the clients to understand it. QlikSense will have a greatly improved licensing model from what I hear.
- QlikSense is covering for all the requested Qlik11 improvements. I think the 2 products will compliment each other.
review
- Easily view complex data with visual charts
- Daily updates gave sales numbers to people who needed them quickly
- Access to data via other sources like SAS
- Export function that is easier to use and less time consuming
QlikView 4 Healthcare
- Serves as an in-memory data warehouse.
- High level of usability for the end user.
- Expressor acquisition enables a high level of data governance.
- Pricing model difficult to understand.
- Report and dashboard development takes longer than expected, especially if there are many data sources.
Highly flexible but requires discipline.
- QlikView does an excellent job of evolving with an organization as it can move faster than an organization thinks. As clients work with their data, their business understanding grows.
- QlikView ETL capability can be used to create a rapid-prototyping space to lower the risk associated with making changes to an ETL process by using it's native QVD file format as a temporary substitute for virtual data warhouse tables. When these stabilize, the client can integrate them into the ETL process without unnecessary time pressure.
- Application development is highly flexible. This pairs well with an agile methodology allowing for requirements to necessarily flex as the client evolves. If done well, it generates high user acceptability levels.
- QlikView provides excellent time to value in that dashboards can be created and deployed quickly. The product has a fully functional scripting language to support all ETL functionality in addition to a fully flexible interface design capability. The ETL piece can be used to quickly bridge gaps in the data.
- Ideal state processes can be created by deploying mulitple QlikView files to work together.
- Architecture is highly flexible allowing architects to design in constraints at appropriate points to control scope creep.
- Simulateous development is difficult as development goes on in one qvw file. There is no check-in/check-out functionality to protect against changes being overwritten. There are third party products that can bridge this gap.
- It can be too flexible in that an inexperienced team can fall victim to user whims. This happens when developers implement changes without an appropriate methodolology.
- It's not a true platform solution. Integrating with single sign-on solutions as an example, is unnecessarily difficult.
- QlikView's achilles heel is RAM. Handling "big data" requires complex, multi-tiered architectures spanning across several applications to maintain performance.
Qlikview works great with SAP
- QlikView's SAP connector makes extracting data from SAP extremely simple.
- The finished dashboards are easy to use. Most users intuitively "get it" within a few seconds and require very minimal training.
- QlikView is strictly a reporting tool. It does not allow the users to create data. It would be helpful if they added functionality that allowed users to manipulate budget or forecast data directly from the dashboard.
- By default all data presented in an application is consistent with the current selection. If you've select '2014' ; 'Ohio' ; 'Large Widgets' then you can easily present that data by Part, Customer, Rep, or any other field in the data model. Click on any field to drill into the results. Users comfortable with Excel/Access will have no problem quickly getting to this point.
- To view 2014 vs 2013 or 'Ohio' as a % of the total this requires something Qlikview calls Set Analysis. Set Analysis works well, but it's complicated. You'll want someone with a strong IT background assisting with the development.
Powerful Product, Great Online Support Community
- Qlikview has an excellent online community support. This was probably the best part of buying the project. I had never worked in BI before purchasing Qlikview but after a short one-week class, I was up and running. Whenever I got stuck, I reviewed previous posts or posted a question myself. The questions were almost always answered within a couple of hours. The fantastic community really helped me learn the product.
- Qlikview is a great product and very powerful. It is not always easy learning all the formulas but for those who know it, it can do almost anything you want a BI tool to do. It is fantastic at integrating multiple sources of information.
- Qlikview provides a lot of free demo dashboards which are fantastic to learn from. They are open so you can see exactly how they were designed behind the scene. The variety of boards are a great strawman or baseline to use for almost any BI initiative that people take on.
- The formula for harder BI analytics is neither intuitive or easy to learn. It really helps if you have some kind of SQL background. I really wish there were more out-of-the-box options that we can customize.
- It may be more of a server issue but it can take hours to run a single query.
- You have to define a lot of parameters for almost anything you create so the tool forces you to spend a lot of time selecting different options. I wish they had good pre-defined templates for layouts for us to choose from.
QlikView's THE BEST OPPORTUNITY
- Modèle associative : mes monsieur vous ne savais pas à quel point je suis fortement intégrer sur la solution Qlik ainsi que d'autre et je n'ai jamais trouver un outil autre que Qlik qui permet de tel association entre les données, cela ma permis dans 90% des projets de trouver des association cachées entre mes données et ma fait apprendre beaucoup d'information dont je n'ai jamais penser. [Associative Model - I can’t stress enough how strong QlickView integrates with other solutions. It has allowed me in 90% of my projects to find hidden relations between my data and discover information I would have never thought about.]
- La flexibilité de son interface graphique, je suis libre de faire et un intégrer sur mon dashboard tous ce que je veux sans limitation ou des modèles pré-configuré et limité. [The flexibility of its GUI – I can integrate on my dashboard all the data that I want without limitation or pre-configured and/or limited models.]
- La technologie In-memory bien sur avec sa combinaison avec le modèle assiciative [The In-memory technology combined with the with Associative Model]
- QlikView nous permet de s’en-passer d'un outil d'ETL pour construire notre modèle de données (Data Model), il met à notre disposition toute une interface dédiée. [QlikView allows us to pass on the usage of an ETL tool to build our data model (Data Model). It includes a dedicated interface.]
- Possibilité d'intégrer du VB Script et Java Script, c'était un rêve avant pour les data-miner de disposer d'un outil BI puissant dont il peuvent intégrer directement leur algorithme et regarder le résultat directement implémenté dans les graphique (il intégré R déjà) [Ability to integrate and data mine VB Script and Java Script. QlikView can integrate their algorithm and look at the results directly within the graph (it integrated R already)]
- Interface d'ETL plus interactive et flexible [Its ETL interface could be more interactive and flexible]
- Interface de communication directe avec R et SPSS [Its direct communication interface with R and SPSS]
- Plus de connecteurs à disposition des développeurs [More connectors could be made available to developers]
- Pourquoi le QvSource est payant !!!??? [Why is QvSource a paying service!??]
- QlikView Next sera une grande catastrophe s'il n’intègre pas tous les interfaces de QlikView 11 (je crois que c'est déjà le cas !!) [QlikView Next will be a great disaster if it does not include all the interfaces from QlikView 11 (I believe this is already the case!)]
[QlikView can meet all the users’ needs as long as you know how to use it to fully leverage its complete set of features. Don’t hesitate to leverage the Qlik Community to learn the issues that others have faced and how they’ve solved them so that you don’t repeat the same mistakes.]
Qlikview, and advantage.
- Qlikview provides a layer between traditional database querying and end user data mining. It makes it easy when searching through data to find relationships and insights.
- Adhoc & Static reporting are a limitation as the tool leans towards dynamic data sorting.
- Generates reports quickly, if the joins are not too complex. If you need a quick Excel report, this works great.
- Lots of flexibility when it comes to developing applications, including basic charts and graphs
- Great at taking "data snapshots" and generating reports in that frozen moment in time. Also easy to update reports by updating the data set
- There is a significant learning curve, in my opinion. A user needs to be highly versed in database management, including SQL. A non-technical user will struggle mightily especially if they don't truly understand their data
- You probably need a dedicated specialist on the team to take full advantage of the software. Complex analytics start appearing rather quickly in our field.
- Qlikview can do automatic joins in a flat file structure. This may or may not be a good feature.
Try QlikView, you'll be amazed!
- Let me start out by saying that I'm very impressed at how easy the tool is to use, and how simple an architecture it has that is easily understandable and can be learned quickly.
- As opposed to many BI products out there that require a huge investment in the "learning curve", QlikView is very intuitive and can be learned quickly. This is a huge positive.
- The one feature that really impressed me is the ability of this product to accurately aggregate "facts" at different levels of granularity. Not many developers, even experienced are aware of this or even look into this. I've used other products where you need to struggle or at least think quite a bit about how to model the solution for various scenarios so the aggregation doesn't break. With QlikView, its amazingly simple. I didn't even have to think about it! I simply established the proper joins among the tables and that's it. It knows how to perform the aggregation without inflating the numbers on the report.
- The GUI of course, is just "common sense". Easy to navigate.
- The only suggestion I've for QlikView is to improve the ability of the "straight table" object so it can provide sub-totals and groups. Based on my current experience, there doesn't seem to be a straightforward way to do this.
- Provide a GUI interface for scripting as opposed to the code one needs to write currently.
QlikView
- QlikView AQL technique automatically joins tables which helps for easy development of QlikView applications
- QlikView Dashboard is easy to operate by the end users. They do not need any special training or IT knowledge for working with QlikView reports
- In built Memory is the biggest advantage of QlikView for handling huge amounts of data with ease
- Optimizing the data and storing it into QVD is an added advantage of QlikView
- Sometimes hangs when working with a pretty huge amount of data
- Set Analysis syntaxes should be more user friendly
Dynamic Queries on QlikView
We mainly adress the business problems such as performance and activity reporting.
- Activity and Sales performance reporting
- Fast and dynamic data presentation
- Customization/personalization features such as bookmarking
- Our biggest challence is the end user training. Most of the available training content is targeting either developers or power users.
- Static reporting module is not as flexible as an Excel report when it comes to formatting
- Expensive pricing for individual and shared session certificates
Success with QlikView
- Great Visualization
- Supports Agile development
- Allows discovery of bad data and anomalies
- Easier application of Security at the row and column levels
- Browser agnostic