Tag Archives: Qlik Sense

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!

Qlik Sense: New features with the February release

Qlik Sense February 2019The February version of the data visualization software Qlik Sense has arrived! With the new release Qlik reacts to the wishes of many users with new features.

After the big success of the Dashboard Bundle provided in the November version, Qlik now adds a new Visualization Bundle. The comprehensive package includes seven more visualization types that were previously only available as Qlik Extensions via the open source community. For upcoming releases, Qlik has announced a continuation of its enhancement package strategy. In addition, users can look forward to an improved user interface – also in the mobile area – as well as new advanced authoring features.

New Visualization Bundle

With the new visualization package, Qlik Sense February 2019 again offers several new diagram types, which greatly expand the possibilities of data visualization:

  1. Funnel chart – to display the progression of a measure over different stages.
  2. Sankey chart – shows measures as a flow and how they are divided into categories (single- or multi-level).
  3. Radar chart – shows a measure distributed over a polar chart with two category dimensions (one for the axes and one for areas).
  4. Heat Map – represents a matrix of color values with two dimensions and a measure.
  5. Multi KPI Object – equips standard KPI objects with more customization options.
  6. Word Cloud – highlights the most common occurrences in text dimensions.
  7. Network chart – shows a diagram with dimensions for nodes, parents and measures.
Visualization Bundle in Qlik Sense February 2019
New visualization types in Qlik Sense February 2019 (Source: Qlik)

Improved user interface

Qlik Sense February 2019 has also been optimized in terms of user experience. For example, the navigation within apps has been simplified by using the “Single Page Application Flow” to switch between data preparation, analysis and data storytelling with just one single click, without having to open new tabs or browser windows.

Advanced authoring features

With the February version, the advanced authoring features will also be further expanded. For example, the new “Share Button” allows the sharing of insights and explicit selections / filters via a direct link. The expression editor has also been equipped with a new dollar sign expansion functionality to evaluate calculation results and thus reduce the risk of syntax errors.

More mobility with Qlik Sense

The version Qlik Sense February 2019 was also improved in terms of mobility. The Qlik Sense Mobile App is now also available for Android devices. The iOS version now also supports mashups. Furthermore, the functions in the EMM (Enterprise Mobile Management) area have been expanded by the support of the fast-growing EMM platform Microsoft Intune. The new Zimperium integration will provide more mobile security in the future.

You can also find a summary of “What’s New” for Qlik Sense February 2019 on YouTube:

Qlik Sense February 2019 - What's New

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

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

New concept, new location: prisma invites to Business Day 2018

prisma Business Day 2018prisma informatik invites you to its annual business day – this year with a new venue and concept.

On October 25th at the Sportpark Ronhof in Fuerth it is all about “Smart processes – valuable data – modern infrastructure”. In addition to some keynotes on the developments of Microsoft, prisma & Co., our new concept includes an open information and communication forum to inform about various topics at numerous information booths, network and hold deepening talks.

Topics will include Modern Workplace (Office 365, Infrastructure etc.), Qlik (Data Visualizations & Reports, D365discovery etc.), Microsoft Dynamics (NAV Development, NAV Finance & Controlling, Document Management etc.) and certain industry lines. Our partner DocuWare will also be available, as well as the speakers Eduard Dell and Guus Krabbenborg.

Eduard Dell, as regional lead of the QBS DACH organization, supports partners such as prisma in creating and developing their business with Microsoft – especially in the area of “Microsoft Business Applications”. At the Business Day Eduard will highlight the roadmaps of the Dynamics product lines.

Guus Krabbenborg is well-known in the Microsoft world as a particularly inspiring speaker, trainer, consultant and blogger. In his creative and inspiring performances, Guus speaks like no other about changes and possibilities in an increasingly digitizing world.

At our “Meet & Greet” on the previous evening (October 24th), Guus will already introduce you to the upcoming day with an exciting impulse speech an our experts will also be available for initial discussions.

Information can also be found in our latest press release. Registrations are open, please click  here to join the prisma Business Day 2018.

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

Soccer World Cup 2018: Choose your champion by using the new Qlik app

Soccer World Cup 2018 - Qlik Sense AppThis years FIFA World Cup is just around the corner. An app of BI provider Qlik allows a forecast of the tournament course based on historical data. Choose your champion!

Starting today the balls of the Soccer World Cup will be kicked off again – this time in Russia. If you can‘t wait for the matches, you can meanwhile use a new Qlik Sense app, which has been especially prepared to calculate all possible results for the World Cup in advance. On this end, BI vendor Qlik has compiled the results of past tournaments as well as the FIFA and Elo rankings. On the base of this data, the winning odds of each team were finally evaluated and visualized.

With the Qlik Sense app you can run through all possible pairings within the various tournament groups. Each score is then supplemented with a chart and some key information (e.g. shots on goal). Based on this data, users can decide for themselves, which teams will be virtually advanced to the next round.

The web-based Qlik World Cup app can be used for free – even on smartphones and tablets.