Tag Archives: NAVdiscovery

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.

prisma informatik at the CeBIT 2017

prisma informatik at the CeBIT 2017At the end of March, visitors from all over the world will meet again at the CeBIT in Hanover. prisma informatik will present its certified BI and ERP solutions at the global event for digital business with Microsoft Dynamics NAV, QlikView and Qlik Sense once more.

Under the major topic “d!conomy – no limits”,  the CeBIT 2017 (March, 20th through 24th) is dominated by the latest technologies and their impact on society. In 2017 Japan has been announced as the official partner country.

At booth E16 in hall 5 prisma informatik will be showing how a company can boost its dormant information potential easily via Microsoft Dynamics – by the certified NAVdiscovery Toolbox. It links the BI products QlikView and Qlik Sense with Microsoft Dynamics NAV or each other data source (e.g. Dynamics CRM), enabling users to analyze data by themselves easily, with minimal technical preparation and without the support of the IT department. Based upon the individual issues, the systematic evaluation of business data can provide companies with a range of important insights in order to assess business opportunities and financial risks better.

We will be presenting our products and solutions from March, 20th through 24th at the CeBIT in Hanover, booth E16 in hall 5. Here visitors can also generally find out about the versatile possibilities of Self-Service BI, Data Discovery and Visual Analytics. For a personal appointment please call +49 911 23980550.

QlikView vs. Power BI

QlikView vs. Power BIThe products of provider Qlik have been among the market-leading solutions in the business intelligence sphere for years. With its analysis software Power BI, Microsoft would like to establish itself on the BI market as well. However, the product that is best suited to a company depends on the respective requirements placed to the tool. Qlik products and Power BI both come up with various advantages and disadvantages.

Although both solutions offer extensive opportunities for data assessment and generation of screenshots and dashboards, a closer look shows that there are significant differences.

Easy integration into the Microsoft environment

One of Power BI’s biggest strengths is its easy integration with other Microsoft products such as Dynamics NAV, Office 365 or SQL Server. If a company already works in a Microsoft environment, the necessary data sources (e.g. Excel tables or NAV data) can be connected particularly quickly and easily. In case of QlikView or Qlik Sense, integration with a source system such as Dynamics NAV is just as simple. The products also assimilate seamlessly into the Microsoft product portfolio. A connector such as prisma’s NAVdiscovery Toolbox can provide particular comfort while performing the connection.

Business Intelligence in the cloud – good or bad?

One should not be misled by the names given to the Power BI products. For instance, although there is a “Power BI Desktop”, this program edition is not suitable for professional use at companies due to its limitations with regard to deployment to other users and in capacity (1 GB). Rather, as a designer program, it can be used to create the assessments locally and publish them on Power BI, which is integrated in Office 365. Power BI is a purely cloud-based product and even the data to be analysed must be held available in a cloud storage space. However, the cloud-based technology of Power BI also gives rise to some advantages. For example, screenshots and dashboards created via the software’s mobile app can be shown directly on a mobile end device, allowing field service employees always to be kept up-to-date with the data.

Continue reading QlikView vs. Power BI

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.

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 http://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 http://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!