Overall Satisfaction with Qlik Sense
Qlik Sense is used by the Manufacturing Operations department for extracting data from various data sources for analysis. While we are still in the infant stage of using and exploring possibilities with this solution, we've already achieved significant productivity gains for the engineering teams, turning regular manual and cross oceanic data extraction processes into scheduled automatic data extraction.
- The drag and drop feature when creating reports is easy for end-users who do not have coding/programming knowledge.
- It is regularly updated with useful extensions that offer users more ways of presenting data for analysis.
- The Insight feature helps business users discover relationships between data, which otherwise have not been thought of.
- Most engineering folks use Excel to create pivot charts that show up to 3 nested dimensions. QlikSense seems to limit this to a maximum of 2 dimensions. It will be great if QlikSense can do all of what Excel can do with regards to charting capabilities and more.
- The objects for a reporting page seems to snap to the grid of the canvas. It would be useful for objects for a report to NOT snap to the grid, so that users can size or position the objects where they want them on the page.
- The color schemes that come with the charting function seem to be fixed. Those default color schemes available are atypical for the manufacturing industry, which normally uses a spectrum from Red to Green. Business users who do not have coding experience will have to depend on knowledgeable QlikSense developers to create the scheme for them. It would be good if QlikSense could include this color scheme as the default offering or provide a feature for user-defined color schemes that users can just pick off the color palette.
- It greatly improved the engineering team's productivity in data extraction and data preparation activities. What can only be executed manually when the engineers come to work can now be done while they are sleeping, and reports are ready when they step into the office. This helps the organization have faster Time To Decision Making.
- Increased hardware and service support (for app development and post app development) costs.
At the point of evaluation in 2016, my assessment is that both Power BI and Tableau still have high dependence on someone with IT, MES, and coding knowledge to create the reports. Qlik Sense's self-service report generation capability is what my Management team wants to pursue, so that data analysts can pull up required data and create the analytics and reports on their own. Qlik Sense fits just right into my Management team's direction.
Qlik Sense is very well suited where source data structures do not change over time. For example, the data tables in a database. When the data format/structures changes from time to time, for example, an engineer's Excel spreadsheet, it will be challenging to code an adaptive Qlik Sense app to accommodate the dynamic changes.