Tag Archives: BI

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.

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!

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.

QlikView Scripting for Dynamics NAV

Although modern self service Business Intelligence solutions make it way easier for end users to create own analyses and reports, and even if they are much faster and more flexible to implement than using traditional BI tools, the development of relevant data models as a basis for further evaluations still requires a certain kind of “expert knowledge”.

Even for IT professionals the previous processing and integration of data sources, especially from complex ERP systems such as Microsoft Dynamics NAV, does often involve tedious and time-consuming effort.

The Qlik connector “NAVdiscovery Toolbox” was developed specifically for these requirements: both the integration of QlikView and Qlik Sense into Dynamics NAV can be realized easily and comfortably with NAVdiscovery.

NAVdiscovery does not provide ready-made script templates as do other connector solutions. Rather, the Qlik data model can be automatically generated from the respective NAV environment with its own script generator.

This way, users can work to create LOAD scripts in the known surfaces of their ERP software – and the technical design of the data model takes place within the usual data structures and business logic.

With NAVdiscovery, the desired tables and fields within Dynamics NAV can directly be selected, automatically renamed and connected. Also the export of option values into readable text and the assignment of relational linked tables is done automatically.
For IT, NAVdiscovery allows to create individual, reusable script templates for Microsoft Dynamics NAV, and also provides convenient options regarding management and backup in the development process.

QlikView Scripting

For more information about the capabilities of the NAVdiscovery script generator, see navdiscovery.com

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