Category Archives: Business Intelligence

Qonnections 2019: Qlik increasingly relies on Multi-Cloud and Augmented Intelligence

QlikAt its annual customer and partner event Qonnections, BI provider Qlik announced, among other things, the further expansion of its Multi-Cloud and Augmented Intelligence offering. Thus Data Literacy in companies will be further increased and supported in the best possible way.

Qlik therefore continues to pursue the approach of “3rd Generation BI” – a combination of integrated analysis functions, the use of Augmented Intelligence and Data Democratization. Data should be able to be used anywhere in any company and made available via extensive (cloud) options. Human intuition and machine intelligence should go hand in hand via integrated analysis functions. The relevant extensions were already partially implemented with the April releases and will continue to be published with the coming June versions.

Extensive and flexible deployment options

The last version of Qlik Sense Enterprise, which was released in April, can therefore be fully deployed in the Qlik Cloud Services environment as part of Qlik’s multi-cloud framework. A deployment via Kubernetes in a public or private cloud is also possible. Some new functions also simplify the management of users, content and licenses in different environments (e.g. Microsoft Azure and Google Cloud platform).

Continue reading Qonnections 2019: Qlik increasingly relies on Multi-Cloud and Augmented Intelligence

New features in Qlik Sense and NPrinting with the Qlik April versions

Qlik SenseSpring is here and comes with the new releases of BI provider Qlik. The new versions include cross-product innovations as well as new features and improvements for the visualization software Qlik Sense.

In addition to some advances in the multi-cloud-architecture, the introduction of the new AI offering Associative Insights and an optimization of the dual-use-option of QlikView and Qlik Sense, the April release wave also offers some new functionalities for Qlik Sense and NPrinting.

Improved Multi-Cloud-Deployment

With its April releases, Qlik introduces new Enterprise SaaS deployment capabilities that give customers more flexibility on their journey into the cloud. Among other things, users will be able to deploy Qlik Sense via hosted cloud services as well as their own cloud infrastructure (via “Qlik Sense on Kubernetes”). All deployment options – including Qlik Sense Enterprise for Windows – can be used cohesively within a multi-cloud-framework.

Qlik Sense Enterprise Deployment Options
Qlik Sense Enterprise Deployment Options (Source: Qlik)

Continue reading New features in Qlik Sense and NPrinting with the Qlik April versions

prisma informatik publishes NAVdiscovery 2.01

With the NAVdiscovery Toolbox developed by prisma informatik, the BI solutions Qlik Sense and QlikView can be quickly and easily linked with Dynamics NAV or Dynamics 365 Business Central as well as Dynamics CRM and many other data sources. The release of the new version 2.01 NAVdiscovery includes some new features.

The new functions in NAVdiscovery 2.01 concern in particular the grouping function and the task administration. In addition, the release contains new features regarding the SQL SELECT statement, the option to generate NAV links automatically and a new test mode.

Scheduler (Automated Task Management)
By setting up recurring tasks, NAVdiscovery processes (e.g. Full Back-up, Qlik Script Export, updating grouping elements) can now be executed cyclically and automatically.

Automated Task Management with NAVdiscovery 2.01
Automated Task Management with NAVdiscovery 2.01

Double Grouping
Two tables can now be combined as data source in a grouping.

Automatically Generated NAV Links
In each exported NAV table, a corresponding NAV link is generated by the NAVdiscovery Export. Data records can be selected directly from Qlik.

Automatically generated NAV Links in NAVdiscovery 2.01
Automatically generated NAV Links in NAVdiscovery 2.01

Editing the SQL SELECT Statement
NAVdiscovery 2.01 enables the processing of the SQL SELECT statement for queries on SQL level and the direct selection of the data on database level.

Test Mode
By activating the test mode (test of “where”-condition and “select”-command) it is possible to test loading conditions without changing the original query.

New Test Mode in NAVdiscovery 2.01
New Test Mode in NAVdiscovery 2.01

Neutral Grouping
By using group elements, you can create your own table in NAV with individual, self-defined contents and use it for grouping functions in NAVdiscovery.

NAVdiscovery 2.01 is available for Dynamics NAV 2016 and newer versions. In addition to the new version of the Management Suite, we are planning to release further connectors for Qlik Sense with the Dynamics 365 product family in the next weeks. We will keep you up to date!

Have a flexible and secure start into the cloud with the new Qlik Sense Multi Cloud

Qlik Sense Multi CloudMore and more companies are moving data and applications to public and private clouds to take advantage of scalable data storage and processing. At the same time, there is still a need for local data storage and processing, for example for legacy systems or due to security and compliance regulations.

To address these challenges, Qlik Sense is offering new ways to deploy a multi-cloud architecture since one of its latest releases.

With the new deployment package “Qlik Sense Enterprise for Elastic”, Qlik Sense installations can be flexibly distributed, consumed and managed across a wide range of environments – whether in the cloud or locally. The architecture can be easily and flexibly adapted at any time – depending on how business requirements change over time.

The multi-cloud capabilities were developed to provide users with a unified platform that is easily and economically scalable, irrespective of the different local and cloud infrastructures. Accordingly, all users have a single, common license and login in all environments to make access easy and seamless.

Customers can benefit from the multi-cloud features since the release of Qlik Sense Enterprise June 2018.

Qlik releases Qlik Sense November 2018

The Qlik Sense story continues – the last release of 2018 is again filled with numerous innovations and cool features. For the first time, the product’s engine includes Qlik Machine Learning capabilities. So there is a lot to expect in this area in 2019. The following shows an overview of the November release highlights:

Qlik Sense November 2018

Dashboard Extension Bundle

By the Dashboard Extension Bundle, the first standard integrated extensions made their way into Qlik Sense. The feature can optionally be installed during the update. By choosing this option, you will find five new extensions in “Custom Objects”, which are now officially delivered with Qlik Sense and fully supported.

  • With the “Date Range Picker” you can select a single date or a range of dates from a calendar.
  • The “Navigation Buttons” can be used to define selections and actions for the entire app.
  • Using the “Tab Container” several tabs can be created within a Qlik Sense object in order to be able to display different visualizations or analysis views compressed for a selection.
  • A “Show/Hide Container” extension helps to display several visualizations in an object depending on the current selection criteria.
  • The “Variable Input” extension allows you to specify values for selections using buttons, drop-down menus and text input fields.

Continue reading Qlik releases Qlik Sense November 2018

QlikView November 2018 – What`s New

BI provider Qlik has provided the November release of its data analysis software QlikView. The new version features some exciting new features and improvements.

Some of the highlights of the new and updated features of QlikView include:

Support to create and schedule files in QlikView Publisher

The new version of QlikView Publisher includes the “File Exists” task among the supporting tasks. This new supporting option can be used to trigger another task following the creation of a file. This is especially useful when the system creates files at irregular time schedules and is used to improve file creation and scheduling. A “File Exists” task completes successfully even when the corresponding file is not found, but does not trigger the following task in this case.

New Log File for QVS Engine Performance

A new QVS Engine log file is now available in QlikView November 2018 for optimized troubleshooting and document design. Because the Engine log file creates a large amount of log data, it is disabled by default and can be enabled for a limited period of time. The generated log contains DocId, ObjectId, ObjectType, NetRAM and PeakRAM, which show the user which objects in the app require the highest RAM capacity.

Separate Reload Performance Protocol

Special new log files now provide information about task performance in a separate form. Until now, this information could be found in the task logs. The new arrangement of the log files makes it easier to reload the performance analysis and keep record which documents consume the most resources.

Improved QlikView Script Loading Process

QlikView November 2018 provides the ability to load complete tables from an SSE-plug-in by making a single request in the QlikView load script.

Custom settings in the configuration files listed in the QMC

The new QlikView version makes it possible to display all “non-default settings” applied to the respective QlikView deployment directly in the menu of the QlikView Management Console (QMC). The displayed list can be used to document all custom configurations and thus provides an ideal basis to update or migrate the respective QlikView installation.

In addition to the new functions listed, the new QlikView version includes other new features such as support for .NET Framework 4.7.2 and the implementation of the Skia graphics library to enhance app visualizations. The following video provides an overview of the QlikView November 2018 highlights:

QlikView November 2018 - What's New

 

Qlik NPrinting: New features with the fall release

NPrinting September 2018Within the scope of the recently launched Qlik release wave, which optimized the data visualization platform Qlik Sense again, NPrinting has been equipped with new functions, too.

The most important new features of the latest NPrinting version include the following areas:

Password protection
Since the September release, NPrinting has a password protection. It is possible to protect reports with both “read” and “read & write” passwords. Passwords can be set at report, publish task or user level. The preview in the Printing Newsstand is accordingly disabled for password protected reports.

Macros in Excel reports
Concerning the creation of Excel reports, it is now possible to integrate Visual Basic macros into reports and publish them in *.xlsm format.

Cookies
According to the new data protection guidelines, NPrinting cookies will be deleted immediately after session logout.

In addition, the latest version of NPrinting also contains numerous improvements relating to performance and stability.

Comprehensive analyses through multiple data sources

IQlik Multiple Data Sourcesn many companies, clean data are the base of important business processes. Analyzed data is essential – especially for new insights or as a decision-making aid. Because these data don’t come from a single internal source any longer, the possibility of integrating external data sources should always be considered at choosing data analysis software.

The storage of company data has gone through a major change in the recent years. In particular, the cloud movement into many companies means that information is no longer stored at a central location, but is obtained from multiple sources. Companies often base decisions on efficiency and go for various cloud models.

But the increased storage options pose a particular challenge to analytics tools, as all relevant data from the various sources must be put together without much effort. The best way to do this is to move away from data silos. Instead, the analysis software should extend across all data sources without having to migrate the data required for evaluation to a central location via various infrastructure barriers.

The various information formats are also important. It should be possible to include external social media data from the cloud in the analyses also as classics like Excel. Open APIs or other connectors can be helpful, as they allow the various sources, whether on-premise or cloud, to be linked to each other without any problems.

The user-friendliness of the software should also not be underrated. The combination of data should be flexible, scalable and simple in order to prevent user mistakes in data analysis and to be able to provide the required data as quickly as possible.

Qlik Sense September 2018 – What’s New

Qlik Sense September 2018It’s time again – Qlik has released a new version of its data visualization solution Qlik Sense. Since the last release in June, a lot has happened.

After the positive feedback regarding the Insight Advisor, which supports the user with analysis and diagram suggestions since June, Qlik remains focused on its Cognitive Engine and Augmented Intelligence for Qlik Sense September 2018. In addition, the new release delivers some “QlikView like” features and more. General highlights of Qlik Sense September 2018 include:

Enhanced Advanced Authoring Features

The Qlik Sense September Release offers some additional functionalities in the area of Advanced Authoring. This simplifies the creation of sophisticated data layouts while accelerating application development due to its high user-friendliness. The improvements of the Expression Editor (e.g. restructured function categorizations and improved search functions) and the visualization control (e.g. conditional show/hide in pivot tables and customizable master measures) are helpful. In addition, you can now open apps by using a default bookmark with a predefined selection state.

New Mapping Features

In addition, the new Qlik Sense version offers enhanced mapping capabilities. For example, the release has a new map layer that depends on the density of the mapped points. The new “Density Map Layer” is a multicolor gradient background where the color intensity varies depending on the weight and closeness of the points.

Improved backend workflow, stability and performance

Qlik Sense September 2018 also removes several previous limitations of the Qlik Management Console (QMC) and allows, for example, to move multiple apps between different streams. In addition, the open source front-end framework has been updated to version 1.6.9 to ensure better performance and stability.

Enhanced connectivity

With the new release, Qlik has further expanded its connectivity options with Microsoft Azure DB and Jira connectors. The necessary security within the integrated connector to Presto is also provided by an extension of LDAP authentication. Large enterprise environments benefit from AirWatch EMM security for mobile access to Qlik Sense Enterprise.

An overview of the listed and other new features of Qlik Sense September 2018 is also available on YouTube:

Qlik Sense September 2018 - What's New

Qlik Sense June 2018 – What’s New

Qlik Sense June 2018BI vendor Qlik continues to pursue its proven release cycle, launching Qlik Sense June 2018, the latest version of its data visualization software.

In addition to a new Insight Advisor and enhanced hub publishing capabilities, the new release includes visualization enhancements and five new connectors. Feature Highlights in Qlik Sense June 2018 include:

Generate insights with the new Insight Advisor
Qlik Sense June 2018 has been extended with a new Insight Advisor. The Advisor uses Qlik’s Cognitive Engine to suggest charts to users based on insights from existing and new data. The user can then use them to augment existing visualizations.

Advanced features for app publishing from the hub
The new Qlik Sense version provides enhanced capabilities to manage apps through the hub. For example, apps that have already been published can be duplicated, modified, and then re-published in the same stream as the original app. Published apps can now be found in a dedicated section.

Filtering data from files
With Qlik Sense June 2018 you can create filtering conditions for the field contents in files. These are automatically applied to the script when data is loaded into the Data Manager.

New possibilities for visualizations
The release also offers some new features to create and edit visualizations. For example, the property panel now offers a number of alternative charts to complement the original chart suggestions. At the same place it is possible to switch dimensions and measures by simply drag and drop. In addition, Qlik Sense June 2018 provides the ability to show and hide specific columns in a straight table. The mini graph used for scrolling can be deactivated for line, bar and combo charts.

Qlik Sense June 2018 offers even more new features. In addition to five new Qlik connectors (PrestoDB, Apache Drill, Apache Phoenix, Apache Spark, and MongoDB), the release features enhanced accessibility, new line layers in map charts and enhanced capabilities for the Expression Editor and App sheets. An overview of the listed and many other interesting new features of Qlik Sense June 2018 is also available in the following video:

Qlik Sense June 2018 Video