Tag Archives: QlikView

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!

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.

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.

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.

Get rid of the data garbage!

Data garbageData, which is maintained conscientiously and always up-to-date, is indispensable for a frictionless running of many business processes in a company. Especially clean master data forms the backbone for a functioning everyday business. Although high data quality is becoming more and more relevant, especially in times of digitalization and big data, many companies, are still neglecting the issue of data cleansing.

Most of the time, this is due to the lack of time and personnel for a continuous monitoring of the internal and external data. Thereby, company data can definitely be called an economic asset nowadays. In most cases, by using a system for many years, more and more information, which is not even needed in the end, is collected. The result is an inconsistent database, which makes the structures more and more complex. This unnecessary waste of data interferes with daily business by significantly decreasing productivity and performance in a company and making important processes more complicated.

Data consolidation with Business Intelligence tools

With the help of an extensive data analysis, inconsistent or even wrong data can quickly be identified and corrected. Experience has shown that the early use of a flexible business intelligence solution – in addition to the subsequent use as a classic BI tool – to eliminate databases, which are faulty or no longer needed in your own system, will pay off. An external solution, such as QlikView und Qlik Sense, which was implemented on time, can, for example, serve as an optimal analysis tool.

Especially during the introduction of a new business software or the update to a newer version of the used system, checking and cleaning the existing databases is recommended before the migration of the data. Thus, unimportant old burdens are not transferred to the new, still clean system and will not interfere the handling of daily business processes in the future. On top of that, the available information can be used as a solid basis for efficient business decisions. So, free yourself from this useless data waste – we would be glad to help you!

Comprehensive geo-evaluations with NPGeoMap

A lot of business data in a company have a geographic relation and are therefore suitable for an analytical evaluation. With the products of business intelligence provider Qlik, the potential of this data can be clearly recognised and exploited. The special Qlik extension NPGeoMap also offers additional tools and possibilities for analysing geographic company data.

For example, NPGeoMap cannot only answer questions about “how”, but also questions about “where” even more efficiently: Which locations generate the most sales? Where are the customers with the highest buying power? In which regions could the sale of a product be particularly enhanced with the last advertising campaign?

The extension is not only suitable for classic sales analyses. Thanks to its intelligent data management, it also offers optimal performance even with large data quantities and can display information in four levels as areas and points or as a combination of both. NPGeoMap also enables the evaluation of visualisation of more complex geographic questions. Maps of the most important countries are already included in the extension and do not require an additional server installation. Individual maps – for example sales areas that are relevant to the company – can also be generated by means of further additional tools.

NPGeoMap offers the user various visualisation options to display the geographic data. They can be displayed in many different layers – for example, as polygons (areas) on background maps like GoogleMaps, BingMaps or OpenStreetMaps, as markers (points), great circles or even charts. The following display options are particularly efficient. Continue reading Comprehensive geo-evaluations with NPGeoMap

IT-Expo 2017 at Zurich: prisma informatik presents user-friendly Self-Service BI with Qlik

IT-ExpoOn April 5th and 6th the IT-Expo opens its doors in Zurich. prisma informatik will be exhibiting at the Swiss Fair for Business Software, Security and Document Solutions.

The IT-Expo at Zurich is regarded as the leading trade fair for IT industry in Switzerland. In addition to the exhibition, it offers a comprehensive lecture program, panel discussions and practical examples. Parallel to IT-Expo, additional trade fairs in the fields of online and dialogue marketing, e-business and human resource management take place, which gives visitors the opportunity to dive into various aspects of digitalization.

As a certified Qlik partner, prisma informatik offers comprehensive insights into the world of Self-Service BI and Visual Analytics with Qlik products – especially in connection with the ERP system Microsoft Dynamics NAV – to visitors of the IT-Expo. With the intuitive QlikView and Qlik Sense solutions and their link to various data sources (e.g. ERP and CRM systems) the relationships between the connected data can be examined particularly well and can be used, for example, for future business decisions. Even in complex ERP environments with individualized structures, the Qlik solutions can be integrated permanently. The integration of Qlik and Dynamics NAV is realized very quick and easy thanks to the certified NAVdiscovery Toolbox from prisma informatik. In addition, each other data source (e.g. Microsoft Dynamics CRM) can be linked to QlikView and Qlik Sense via NAVdiscovery.

For further information on the successful use of Self-Service BI and our products and solutions, refer to our press release or meet us on April 5th or 6th, 2017 at the IT-Expo at Zurich, booth C.19 in hall 1. To arrange a personal meeting please call +49 911 23980550.