Tag Archives: QlikView

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.

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

Creating and sharing reports with Qlik NPrinting

Appealing reports can be generated and automatically distributed quickly and easily using the Qlik NPrinting reporting platform – in various formats via different channels. The add-on sources the required data and analyses for the adaptable reports from QlikView and Qlik Sense.

Qlik NPrinting uses QlikView and Qlik Sense as a data source and therefore accesses patterns and QlikView or Qlik Sense elements which the required reports are finally based on. Thanks to complete Microsoft Office Integration suitable report templates can be created in the native Office environment.

Report Designer in Qlik NPrinting
Report Designer in Qlik NPrinting

The reports can be produced in various standard formats, such as PDF, Excel, Word, PowerPoint or HTML and distributed accordingly – at a scheduled time or whenever they are requested by individual users.

Final Report in Qlik NPrinting
Final Report in Qlik NPrinting

They are distributed, e.g. by email or a transfer drive, but mainly through a centralized distribution system, the web-based NPrinting NewsStand Portal, which ensures that the reports are reaching their user extremely easy and fast. The user can finally subscribe to the required reports from a computer or mobile end device or have the available reports displayed or download them. As a result, the correct information always reaches the right recipient at the required time.

Qlik NPrinting NewsStand
Qlik NPrinting NewsStand

Qlik NPrinting also guarantees optimized flexibility, control and security through multi-engine scalability. Role-based security at app level ensures at the same time that administrators, developers and recipients only receive access to information that they are authorized for and is relevant to them.

Would you also like to create, schedule and automatically distribute reports quickly and easily using Qlik NPrinting? Contact us or visit our website for more detailed information about Qlik NPrinting in combination with QlikView and Qlik Sense!