Author: BI Consultant – Linda Bell
Unraveling the hidden stories in your business.
So you may already be familiar with Business Intelligence software, what exactly makes Qlik different? The main factor that differentiates Qlik from other BI tools is its unique in memory, associative model. This feature can help you determine which attributes are common factors for success, as well as what is lacking in less successful areas.
Visualisations for faster interpretation
Both the QlikView and Qlik Sense solutions harness the power of the QIX engine and Qlik’s unique, in memory, associative model. The data associations in Qlik applications are managed in memory at the engine level, and not at the application level. Every data point in every field is associated with every other data point anywhere in the entire schema. The user experiences this through the green, grey and white colour associations within the visualisation. Green shows the values that you have selected, white are other fields within the data model that are associated with the selected values, and grey are values that are not associated with the current selection. This way you can, for example, see which products are sold in a selected store, but at the same time it is immediately clear which products are not sold in that store, allowing you to explore further and find out why.
Explore data freely
Both QlikView and Qlik Sense allow users to create their own visualisations based on the schema within the application. This means once you have a tried and tested data model, users are able to explore their data in a way that suits their specific needs, and they do not have to wait for a technical resource to be available to do development before they can get the results that they require. As they find the story within their data, they can follow the trail independently.
Discover and build your data story
Taking the ability for the user to explore independently even further, is the data story telling ability in Qlik Sense. As the user gains insights based on selections, they can screen shot these results, and put together a data story that can then be shared with other users. Data stories can cover several sheets showing multiple objects, including text objects where the user can enter their own observations. User selections are stored within the data story. A data story can be presented similar to a PowerPoint presentation, with the unique ability that the user can show the snapshot, and then drill back into the live application where the same selections will be applied, providing the user with the ability to explore further or answer further questions.
Another benefit for Qlik technology is NPrinting, an advanced reporting and distribution solution. Reports are developed using drag and drop methods where objects are taken from existing applications. Visualisations from multiple applications can be combined into one report and data can be filtered based on user requirements. NPrinting reports can be delivered in PDF format to users who do not have a Qlik license or token. Reports can be scheduled and delivered automatically via email or the portal. A secure, self-service news stand portal is available where users can subscribe to reports and view historical reports.
Optimise your files
A further differentiator for Qlik is the built in extract, transform, and load (ETL) capability. There is no need for an intermediate data warehouse due to Qlik’s ability to extract and transform data. Data can be stored in highly optimised qvd files which stores data at up to 90% compression. Creating qvd files means that the source system is only hit once to extract data, and all applications can make use of the qvd files for data access, with the additional benefit that all applications are reporting on a single consistent data source.
The BI tool of choice
There are stories hidden in your data. These stories can reveal what is going right in your business, as well as what is going wrong or what can be improved upon. Hidden trends and outliers can be identified and patterns and associations can be found.
Qlik provides a complete BI solution to consolidate, view and explore your data.
Have any questions about QlikView or Qlik Sense? Our consultants have years of experience in BI and data analytics, making us an IT partner of choice.
Want us to cover a particular topic? Leave a comment or email us at email@example.com.