Tag Archives: QlikView

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!

Fast And Simple Geo-Visualisation With Qlik Sense

Qlik Sense Geo-VisualisationIt is increasingly important to maintain a constant overview of company-relevant data, particularly in the time of big data, but that does not make it easier. As a result, modern business intelligence solutions have become indispensable for companies in making the respective information as clear and coherent as possible.

The data discovery software Qlik Sense with its integrated geo-functions allows data to be evaluated and displayed, even for different geographical zones. It can, for instance, show you which regions in Germany sell a product particularly well, or if you were able to increase turnover internationally with an individual product in the past year. Qlik Sense offers various possibilities to visually display the relevant data on a map, and allows analyses and comparisons to be carried out.

Qlik Sense Geo-Visualisation - Sales in Germany
Qlik Sense Geo-Visualisation – Sales in Germany

This makes it possible for regional sales figures to be pictured on a map in the form of different coloured areas. In addition, the respective data can also be displayed on uploaded maps as circles of various sizes. Qlik Sense offers a diverse range of interaction options. Map scaling can be carried out by swiping, panning or scrolling (depending on the device being used).

Qlik Sense Geo-Visualisation - Area and Point Visualisation
Qlik Sense Geo-Visualisation – Area and Point Visualisation

In addition, you can focus on a specific area in just a few clicks, letting you take a closer look at selected information. A number of different selection possibilities are available to the user (marking, clicking, lasso and legends selection) to limit the examined data.

The pre-integrated mapbox background function can be used for geo-visualisation in Qlik Sense. Users can also add maps from external providers. Aside from additional maps, these also offer other expansions for more complex geo-visualisations. You will receive an overview of possible functionalities of external providers in a separate blog.

Qlik Releases Qlik Sense 3.0

Qlik Sense 3.0As already announced at this year’s Qonnections in Orlando, BI solutions provider Qlik has now released the new version of its data visualization platform Qlik Sense. Alongside various improvements and bug fixes, Qlik Sense 3.0 offers many new user features.

Qlik Sense Version 3.0 provides the following new functions, among others:

  • New Qlik DataMarket packages
    Qlik Sense 3.0 has new DataMarket sets, including data on the population of India, Canada, and more.
  • Language expansion and choice of reading order
    The Business Intelligence platform is now available in four additional languages: Polish, Turkish, Korean and traditional Chinese. You can also change the reading direction in a Qlik Sense app to “right-to-left”.
  • Visual searching in Smart Search
    Smart Search lets you search through visualizations now. Results are returned in a gallery that lists out those visualizations in which the search terms were found. Clicking in the gallery brings you directly to the desired visualization.
  • Widget expansion for apps
    Qlik Sense apps can now be equipped with a new object type: widgets. Typically, these are customized KPI objects, diagram visualizations, tables and sheet navigation objects. Widgets are kept very simple in design and function, and can be created in the Widget Editor (part of the Dev Hub) without deep knowledge of development.
  • New visual data preparation
    The new visual data preparation lets you graphically integrate and analyse data by drag & drop. The various tables and datasets are displayed as bubbles that can be visually linked and related with one another. No expert knowledge of data modelling is required.
  • Time-aware charts
    Qlik Sense 3.0 lets you add a continuous timescale along the x-axis to a line chart, to provide a complete and accurate view of time-based data. This scale represents an entire period of time (including intervals without data) in a consistent dimension, and allows the user to zoom in to any point.
  • Installing Qlik Connector with Qlik Sense
    Qlik REST Connector 1.1, QlikSalesforce Connector 14.0 and QLIK ODBC Connectors Package 1.1 are now installed with Qlik Sense. This way, data can be loaded especially efficiently into a Qlik Sense app from REST data sources and SalesForce datasets. It has also been made much easier to integrate ODBC data sources.

In addition to all this, the new platform features many bug fixes and technical improvements. Watch the following video to find out more about the above features and discover other new functions.

What's New in Qlik Sense 3.0 Video

Simultaneously to Qlik Sense 3.0, Qlik has also released the new version of its reporting tool Qlik NPrinting 17.1 and the fourth service release for QlikView 12. All three products are already available. Qlik Sense 3.0 and NPrinting 17.1 are also compatible with each other.

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!