Tag Archives: BI Software

QlikView and Qlik Sense – Combined use

QlikView Qlik Sense Combined UseIn the summer of 2014, Swedish business intelligence company Qlik added the new self-service data visualization software Qlik Sense to its product range, which until then had comprised the BI platform QlikView. This release provided users with many new analysis and visualization capabilities, but also made them wonder which of the products was best suited to their company. In fact, QlikView and Qlik Sense can be easily used in parallel.

Before implementing a new Qlik product, however, it should be determined exactly what purposes the platform should serve and whether it might actually make the most sense to use both products combined. Many companies employing QlikView can already meet all daily requirements in terms of information gathering, analysis, evaluation and visualization with this software. But they may still be lacking certain functions that Qlik Sense Enterprise could offer, especially for power users.

The two products have their own strengths that, when combined, complement each other perfectly and can thus fulfill the needs of various user groups in a company. The leading data discovery platform QlikView, for example, is recommendable for developing and implementing detailed managed applications for comprehensive data analysis. The layout and design can be fine-tuned down to the last detail. This makes the software ideal for power users developing analytical environments for expert users.

Qlik Sense, on the other hand, generally offers better options for web development. It can furthermore be employed easily and intuitively by any user as a modern self-service data visualization application for creating and using interactive and intelligent visualizations. The platform’s smart searches and a drag & drop workflow make it especially comfortable to work with. Due to its responsive design, Qlik Sense is also ideal for use on mobile devices. Again, a good reason to be favored by power users, but also an important deciding factor for field staff, for example.

QlikView and Qlik Sense thus complement each another perfectly in terms of what they can be used for. Because they share a common technological basis (QIX engine), the two solutions can be implemented quickly and easily in combined operation – tailored precisely to the respective company’s needs.

Are you interested in a parallel implementation of QlikView and Qlik Sense? Contact us for more Information!

Qlik Sense 2.2 officially available

Qlik SenseAfter a long beta testing phase, users around the world can now officially benefit from the new functions and improvements of the business intelligence solution Qlik Sense 2.2.

The new features concern platform users and developers alike. Version 2.2 of the visualization software Qlik Sense includes the following features and improvements, among others:

Alternative dimensions and measures
Qlik Sense 2.2 allows the user to add alternative dimensions and figures to charts and graphs via the properties field. The diagrams remain easily accessible, with the data in them quickly and easily swappable. During data analysis, you can thus comfortably swap between different views of a visualization without having to directly edit governed objects.

Advanced data preparation
The new version of the software also makes it easier to prepare the data to be used in an improved data manager. Among other things, this allows you to split linked tables, rename fields and tables, and change the display format of date and time stamp fields.

Data export from pivot tables
Users can now easily export data from a pivot table into an Excel spreadsheet.

Qlik DataMarket
Qlik Sense 2.2 has furthermore expanded Qlik DataMarket with a number of records for global weather, currencies and the stock market. The user interface for data selection has also been revised. Licensed and free data sets are now kept in clearly marked categories. The data packets have also been sorted hierarchically to make selection easier.

Expanded printing and exporting capabilities
Stories and charts are now much better and easier to export to Excel and PowerPoint for printing out as a PDF.

Aside from these new features, Version 2.2 of the business intelligence software Qlik Sense includes many bug fixes and enhancements, which make working with the platform much smoother and more comfortable. Developers will certainly be glad of diverse other new features such as various new APIs and a Qlik Analytics plug-in for Visual Studio.

You can find out more about the most important features of Qlik Sense 2.2 in the following Video:

Qlik Sense 2.2 Presentation

QlikView 12 officially available

QlikView 12 ReleaseFor just a few hours now, QlikView 12, the latest version of one of the world’s leading Business Intelligence platforms, has been available on the market. Besides several innovations familiar from the beta version, the software now offers additional interesting functions.

Around two months after ending the beta test phase, Qlik has published the latest release of its proven analysis solution, QlikView 12. Even before the official release, users were able to get a first glance at several of the new features and extensions. The new features include the improved QIX Engine, extended touch functions, and a new online help portal including context-sensitive help pages to provide support during product use. Furthermore, the beta version already included optimisations pertaining to the security of external interfaces.

QlikView 12 Release New Features

Direct integration of Qlik DataMarket in QlikView has also been added to the official release of QlikView 12. The innovative, cloud-based data service provides users with access to a large collection of different data records in a variety of thematic areas, e.g. population numbers, currencies, and weather. The data that may be accessed and used directly from QlikView is partially freely available and partially subject to a charge.

Besides this, QlikView 12 includes a RESTful API Connector. This enables a seamless connection between QlikView and other web-based data sources that also possess a RESTful API Connector. For example, QlikView may be simply connected to social networks such as Facebook, Twitter, and LinkedIn, without the need to involve third-party providers or use other extensions.

More information about the innovations in QlikView 12 is also available to you in our blog at: QLIKVIEW 12: BETA VERSION NOW AVAILABLE TO CUSTOMERS and in the following video:

Whats New in QlikView 12

NAVdiscovery 2.0 – Toolbox Now Available For Qlik Sense

Among the numerous solution approaches in the area of Business Intelligence for Microsoft Dynamics NAV, external analysis systems like QlikView and Qlik Sense in particular represent a genuine, high-quality alternative. Because these independent solutions are connected from outside to the ERP system, additional sources can also be integrated without any problems. In this way, the Qlik platform offers the option to combine and consolidate the most diverse systems.

With the newly released version of NAVdiscovery 2.0, the QlikView and Qlik Sense business intelligence solutions may now be easily and conveniently connected to and managed with Dynamics NAV, Dynamics CRM, and numerous other data sources.

Qlik Sense Integration Dynamics NAV Dynamics CRMScript Builder for Qlik Sense
Using the expanded NAVdiscovery Script Builder, the data models for QlikView and Qlik Sense may be produced directly from the individual NAV environment. The desired information can be directly selected, renamed and connected full-automatically. This way, the respective LOAD scripts may easily be created at the press of a button for QlikView, Qlik Sense, or both analysis solutions.

Connector Dynamics NAV Dynamics CRM QlikView Qlik SenseDirect integration for Qlik Sense
In addition, any evaluation and analysis views of both Qlik products may be integrated directly into the interfaces of Dynamics NAV or Dynamics CRM using NAVdiscovery Integration. The systems’ evaluation options may therefore be easily expanded with much more, and relevant key indicators are available at every possible position. The QlikView and Qlik Sense elements to be displayed may easily be configured and changed via the NAVdiscovery menu.

Multiple Data Sources Integration Qlik Sense Dynamics NAV Dynamics CRM Cloud ExcelManagement of multiple data sources
With NAVdiscovery 2.0, integration and management of multiple data sources has also been added. An agile QVD concept enables any other data sources to be integrated and consolidated in addition to Dynamics NAV. This makes the implementation of diverse usage scenarios like easy operation of multiple NAV clients or the integration of Dynamics CRM and other data sources flexible.

NAVdiscovery 2.0 live at Convergence Europe 2015
From the 30th of November to the 2nd December, prisma informatik will present the new release of the NAVdiscovery Toolbox within the context of Microsoft Convergence Europe. This event qualifies as a meeting point for the Microsoft Business Community and warmly welcomes all of its partners, customers, and interested parties again this year.

To arrange a meeting, simply send an e-mail to vertrieb@prisma-informatik.de or contact us by calling 0049 911 239 805 – 77. If you will not be visiting Convergence personally, then we would be delighted to keep you up to date via our Twitter account.

QlikView 12: Beta version now available to customers

QlikView 12 ReleaseThe Beta version of the upcoming product release QlikView 12 is now available to existing Qlik customers. They have the opportunity to test the software until the 25 September and provide feedback to Qlik.

With QlikView various innovations and improvements are awaiting customers, concerning QlikView Desktop, QlikView Server, QlikView Publisher and QlikView Workbench. The following features can be tested in the currently available Beta version:

  • QIX Engine
    QlikView 12 is designed on the basis of the same QIX Engine as Qlik Sense. This allows users to benefit from several improvements, which will above all improve the performance of many applications (in particular those with large tables).
  • Security
    The new version also contains security optimisations, which among other things affect the product’s external interfaces. The improvements will not necessarily be noticed by end users and have no influence on performance and program sequences.
  • New online help
    An online help portal provides users with immediate support in case of problems and questions. Help pages can be accessed on a context-sensitive basis directly from the application, and have a similar format to the help portal for Qlik Sense.
  • Improved touch functionalities
    Additionally, QlikView 12 now offers the possibility of using all functionalities that are executable in the web client via keyboard and mouse (e.g. create, edit and move objects, change properties, use the scrollbar) via the touchscreen of mobile end devices, too.

From now until the 25 September, partners and existing customers can test the Beta version of QlikView 12 and direct their feedback to Qlik.

Qlik Sense 2.0 is available

Last week, Qlik announced the official release of Qlik Sense 2.0, the first major release of its data visualization solution. The features included in the new release focus largely on improved possibilities regarding access, loading and processing data.

The new features mainly include:

  • Qlik DataMarket
    The new, cloud-based data service provides the ability to integrate external databases, including demographic information, currencies, economic indicators or weather information directly out of Qlik Sense 2.0. The data sets include both a free and a paid offering.

Qlik Sense 2.0 Release new features Data Market

  • Smart Data Load
    The data load and the automatic, intelligent identification of key relationships in data models have been further improved. Thus, connecting and processing data from different sources has been further simplified – even for non-technical users.
  • Smart Data Compression
    Large amounts of data can now processed and presented even better. New algorithms and visualizations allow meaningful summary even of billions of individual data points.
  • Printing and exporting PDFs
    It is now possible to export worksheets directly from Qlik Sense out as a PDF. The export settings can be customized.

Qlik Sense 2.0 Release printing exporting PDF

  • Additional improvements
    Furthermore, various improvements in terms of usability and the overall look and feel have been made. This includes optimized SmartSearch functionality (also on mobile devices), as well as improved visualization options and features concerning the map objects, KPI objects and pivot tables

The name “Qlik Sense” stands for the whole product family, including Qlik Sense Enterprise, Qlik Sense desktop and Qlik Sense cloud.

The launch of the further announced new products is planned for July this year. The new development environment “Qlik Analytics Platform” is scheduled for 01 July 2015.

Qlik provides a brief video overview oft he new features in Qlik Sense 2.0:

Qlik Sense 2.0 Release features overview

Direct integration of QlikView & Qlik Sense into Microsoft Dynamics NAV

To establish efficient analysis and reporting processes, meanwhile more and more companies implement flexible, external tools and take advantage of the many benefits and opportunities offered by the modern self-service BI platforms compared to traditional business intelligence systems.

Nevertheless, even after having acquired an external analysis tool, certain reporting options within the ERP system are still required, for example for displaying relevant key performance indicators (KPI).

As Qlik partner especially for Dynamics NAV, prisma informatik GmbH provides a convenient and fast connection of the ERP system and the Qlik solutions with the help of the NAVdiscovery Toolbox. Both, the connection of QlikView as well as Qlik Sense, can be implemented much easier in comparison to standard procedures with NAVdiscovery.

With the help of Dynamics NAV Integration, any evaluation and analysis views can be integrated directly and interactively into the surface of the ERP system. The Qlik components can be embedded on any desired level into Dynamics NAV. The present analysis capabilities within the ERP system can thereby be easily complemented.

QlikView Microsoft Dynamics NAV Integration Scripting Template

By integrating the Qlik solutions, there are almost unlimited evaluation possibilities available in Microsoft Dynamics NAV. Each user can retrieve the relevant information without support from the IT department. Basically, data can be investigated in many directions and independently evaluated – the user is not restricted to pre-built analysis options. Furthermore, with Qlik Sense, there are additional simple ways for creating visualizations, reports and dashboards by dragging and dropping.

Overall, the deep integration of the self-service BI components into Microsoft Dynamics NAV offers numerous benefits, which can be used and customized according to business requirement. The Qlik objects to be displayed can thereby be configured and changed easily via the NAVdiscovery menu.

NAVdiscovery QlikView Qlik Sense Dynamics NAV Connector Integration Template

For more information about the possibilities of NAVdiscovery integration, please have a look on https://www.navdiscovery.com/features/

Seeing is believing – please contact us for a free online demonstration on the possibilities of the NAVdiscovery Toolbox!


Easy generation of QlikView and Qlik Sense data models out of Dynamics NAV

Since powerful analysis and reporting tools are becoming more and more indispensable in today’s business world, many companies count on BI solutions which promise users considerable time and cost savings in addition to the easy use.

Despite the diverse and innovative analysis options offered by the modern platforms, the generation of the necessary data models for later evaluation entails laborious and time-consuming effort, even for IT specialists.

Particularly data structures, which are not yet available in the desired form in the existing source data (such as Microsoft Dynamics NAV), often have to be processed first extensively, before they can be used for later analysis in QlikView and Qlik Sense.

Examples herefor can be simple applications such as cluster analysis (customer, item) according to different criteria, or even more complex business reports such as balance sheets and income statements (P&L). The mapping of account schedules from Dynamics NAV in QlikView and Qlik Sense into dynamic pivot tables is also a common requirement.

For these applications, the grouping function of the NAVdiscovery Toolbox provides the ability to create analysis views of any data structure from the master data of the ERP system. In this way, individual evaluation structures can be defined, independent of the existing NAV database. The freely selectable structures require no additional field or table extensions and can be created in unlimited hierarchy levels. The setup of the evaluation structures is carried out directly in Dynamics NAV – within the usual data structures and business logic.

QlikView Dynamics NAV Connector Scripting Template NAVdiscovery

This results in almost unlimited options for the design of evaluations. At the same time, the dimensions of the groups can be changed at any time or be used as a template for new evaluations.

The NAVdiscovery Toolbox already contains templates for the most frequently used evaluation structures in Microsoft Dynamics NAV, which can be extended, adapted and reused flexibly.

For more information on the options of the grouping feature, please have a look at https://www.navdiscovery.com/features/

Seeing is believing – don’t hesitate to contact us for a free online demo on the possibilities of the NAVdiscovery Toolbox!

Qlik Sense Enterprise 2.0

Qlik Sense Enterprise 2.0 Qlik Analytics Platform Qlik DataMarket Qlik CloudAt this year’s global partner summit, BI software vendor Qlik announced not only the first major release for Qlik Sense, but also previewed of a number of other new products in the course of this year. Thus, Qlik is expanding its portfolio significantly and evolves from solution provider to platform vendor.

At the annual partner conference “Qonnections” last week in Dallas, Qlik announced the first major update of its data visualization solution called Qlik Sense Enterprise 2.0 to be released in June this year.

In a preview of the features included in the new version, amongst others, enhanced facilities for loading and processing data were presented. The new Smart Data Load function allows users to select from multiple data sources and combine them into one application. The new features also include improved visualization options and features concerning the map objects, KPI objects and pivot tables, as well as the possibility for an easy export of analysis views to PDF and PowerPoint. Moreover, the current Smart Search function will be further expanded.

In addition to the new version, a number of new products have been announced, which will significantly expand the portfolio:

The new Qlik Analytics platform will offer developers in the future many new opportunities for the creation of applications and web mashups. The Qlik Analytics platform is based on the patented QIX analysis engine and includes all available product APIs. By using the Qlik Analytics platform it will be possible in the future to comprehensively manage all components of the new Qlik family on a common basis. The Qlik Analytics Platform will be available as of June this year.

Qlik Sense Enterprise 2.0 Release Qlik Analytics Platform Qlik CloudSource: Doug Henschen

Also presented were new members of the Qlik Cloud family – the overarching term for the new, cloud-based services:

  • The Qlik Sense Cloud (so far in its beta version) is a free service, by means of which the own Qlik Sense applications can be shared with up to five other users. To access the shared content via the cloud, an installation of Qlik Sense is not necessarily required. Qlik Sense Cloud is available immediately. Additional feature enhancements are planned for the second half of 2015.
  •  Qlik DataMarket is a service that is best comparable with an app store for data. It allows easy access to a variety of external data sets (such as corporate demographic information, currencies, economic indicators, weather data) in the most diverse areas and levels of detail. Qlik DataMarket will be available for Qlik Sense as of June this year, for Qlik View in the second half of 2015.
  • With the help of Qlik Sense Charts analysis views can be embedded in interactive websites. The respective objects are automatically rendered and optimized for the device on which they are presented. Qlik Sense Charts (beta version) will be available as of June this year.

The next release of the proven analysis solution QlikView 12 was also announced for the second half of 2015. With this release, QlikView is going to be operated and developed on the same technical platform (QIX Engine) as Qlik Sense. In this way, QlikView customers benefit long-term from the improvements and investments made by the software producer.

With the new product portfolio, companies basically are offered more deployment options, freedom of choice and flexibility in the context of an integrated, scalable analysis solution. This way, Qlik is positioning itself for the future as a provider of an innovative and integrated, platform-based analysis solution that covers a wide range of application scenarios – scalable for companies of all sizes and requirements.

Business Intelligence: no self-service without expert knowledge

Self Service BIEfficient analysis and evaluation methods are essential in times of modern ERP systems. Many companies already benefit from so-called self-service business intelligence solutions and integrate the flexible tools of various kinds into their daily business. But being able to work independently with BI software usually also requires the consultation of an expert to begin with.

Resources and time are precious commodities in today’s fast-paced business world. In this context, the deployed software solutions are expected to make every day work more efficient and to simplify workflows. Above all, conventional analysis and reporting methods often involve considerable effort and cost. To prevent both, and to create more flexibility, many companies have chosen to use modern self-service business intelligence software in the past few years. In the near future, a further increase is to be expected in this area.

Innovative solutions enable users to work independently with corporate data, analyze it and eventually use it for relevant evaluations and reports without having to depend on assistance of the IT department. Because no extensive and continuous communication between end users and the IT department about requirements regarding evaluations to be made is no longer necessary, the expense in terms of time and personnel can be reduced significantly.

Despite the intuitive operating concept, self-service BI tools can often not be readily implemented: particularly for the processing and integration of necessary data sources, it is helpful to consult an expert for advice in advance. During implementation process, basic problems might occur, which often cannot be sufficiently solved with user skills.

For example, in order to determine the complexity and the data structures of modern What is an ERP system in full measure, and to be able to extract the required information and tables, profound understanding of the process, and system knowledge is required. To find and prepare the required data within these structures, service providers can rely in most cases on many years of experience in this field. Furthermore, an appropriate evaluation concept and best practice data models tailored to the specific requirements of the company should be developed before implementation of the self-service business intelligence solutions. Thus, it’s necessary to clarify in advance, what information and evaluations are required by the individual user.

The use of modern self-service business intelligence tools provides many advantages. In addition to the simple and intuitive interface which makes creating evaluations and reports for end users much faster and more efficient, especially the enormous cost, time and resource savings due to not having to depend on the IT department are important factors. However, it should always be considered that expert knowledge is indispensable when implementing a self-service BI solution in order to avoid the problems mentioned regarding data processing and interpretation.