Tag Archives: Qlik Sense

Offline Data Analysis with the Qlik Sense Mobile App

With the June release of its data visualization platform Qlik Sense, BI vendor Qlik introduced many new features. In addition to a revised release cycle and new features in the range of data preparation, visualization and predictive analytics, the new Qlik Sense Mobile App has been launched. The app is currently only available for iPads, but will be released for iPhones in February.

The native Mobile App for iOS provides full access to any Qlik Sense Enterprise environment and the respective apps. The powerful features of the QIX engine, such as the associative search, run directly on the iPad and remain fully preserved.

Using the app and doing associative data analysis is also available in offline mode. As the QIX engine runs locally on the iPad, a network connection is not necessary. After setting up the Mobile App and downloading the desired Qlik Sense apps, they can be used offline (e.g. in flight mode or if no Wi-Fi connection is available).

Qlik Sense Mobile App
Information box about the online / offline mode of the apps.
Qlik Sense Mobile App
Filtering for dowloaded apps and apps, which are still available for download.

Qlik launches Qlik Sense November 2017

Around two months since the last release in September, Qlik has introduced the latest version of its data visualization solution Qlik Sense November 2017.

The improvements and updates of the new release mainly relate to visualization options, the adding of data, as well as navigation within the apps. The most important new features and add-ons include the following:

Improved visualization
The visualizations of Qlik Sense November 2017 have been improved and extended. Among other things, users are now able to scroll horizontally in a table, vary bubble sizes and use an expression to set the color of distribution charts and box plot diagrams. Moreover, data can be added and refreshed in the sheet editor without having to switch to Data Manager.

Manual adding of data
In Qlik Sense November data can be manually entered in Data Manager. Manual entry allows data to be added directly into a table editor and subsequently as a table to Data Manager.

Details dialog in Data Manager
A details dialog now views the sequence of changes performed on selected tables and fields. This allows the user to directly identify the source of the table or field, the current changes and transformations that have been made, as well as the order in which they have been applied.

Keyboard navigation in Qlik Sense apps
It is now possible to navigate by using the keyboard within the app overview page and the Qlik Sense toolbar.

The following video provides a short overview of the listed and some additional new features in Qlik Sense November 2017:

Qlik Sense November 2017

Alongside launching the new Qlik Sense version, Qlik also introduced the November releases of its QlikView and Qlik NPrinting solutions, which predominantly contain technical improvements.

Qlik publishes Qlik Sense September 2017 and Qlik NPrinting September 2017

Recently BI vendor Qlik announced its new release strategy: starting now, a major-release will be launched five times a year. In addition to continuous releases of Qlik Sense, there will be different focuses on other products of the BI portfolio.

After the release of “Qlik Sense June 2017” last June, Qlik now published “Qlik Sense September 2017”. At the same time, the reporting platform Qlik NPrinting features a new version and some – partly long-awaited – capabilities and improvements.

The Qlik Sense September 2017 release also includes some interesting features and extensions, for example:

New Qlik Sense Mobile App
The new Qlik Sense Mobile App for iOS devices is now available at Apple Enterprise Store. Using the app, you can download Qlik Sense evaluations locally and use them on the iPad. The powerful features of the QIX engine, such as the Associative Search, run directly on the iPad and remain fully preserved.

Qlik Sense September 2017 Mobile App
Source: Qlik

Waterfall Charts
Using the new waterfall chart, users can now illustrate how an initial value is influenced by intermediate positive and negative values. For example, they can show positive and negative contributions of different accounts in an income statement.

Qlik Sense September 2017 Mobile App
Source: Qlik

Box Plot and Pivot
In addition, the box plot diagram, which was introduced in the June version, was equipped with more detailed selection options. Pivot tables also received new format options.

Color Selection
The color picker in Qlik Sense September 2017 now shows the five most recently chosen colors.

Improved Data Manager
Improvements of the data manager give the possibility to perform continuous transformations on tables and fields.

Qlik NPrinting September 2017 (NPrinting 17.5)

  • Report Cycles
    A separate report file can now be added for each combination of one or more dimension values.
  • Report Export and Import
    It is now possible to export a report to a compressed file and import it into another Qlik NPrinting installation (for example, to transfer a report from a test to a productive environment).
  • Object filters for Qlik Sense Charts
    With Qlik NPrinting September 2017, a filter can now be applied to a single object (e.g. a chart) without placing the filter on objects in the report. On the other hand, filtering an object can be blocked.

In addition to these and other new features, Qlik Sense September 2017 and NPrinting September 2017 also contain numerous bug fixes. The following video shows the most important innovations of Qlik Sense September 2017:

In addition to these and other new features, Qlik Sense September 2017 and NPrinting September 2017 also contain numerous bug fixes. The following video shows the most important innovations of Qlik Sense September 2017.

Living data with Qlik Data Storytelling

The visualization of company data, for example in graphics and charts, can enormously simplify and improve the analysis and gaining knowledge. If the respective evaluations are expected to be shared and presented with others, the data can even be combined into a real story and thereby be brought to life.

Data Storytelling connects selected data, puts it in a specific context, emphasizes special elements and wakes up the audiences’ emotions. This is a major factor in understanding and convincing data. It is also important for the presenter to adapt the narrated data history to the respective knowledge and requirements of the audience, for example different departments.

Often, it is also adequate to focus on single important information or the presentation of summarized results ideally drawn on a particular scenario or enriched with different hypotheses. For example, by showing and explaining possible developments to your employees, so they can be enabled into the respective situation better and make the right decisions faster and easier.

Additional emotions can result in the elucidation of potential consequences when choosing a wrong alternative. Therefore, the trick is to catch the audience – not only in a professional, but also in an emotional way – by selecting the right data and numbers, packaged in convincing pictures and graphics.

Bring data to life with Qlik

For an all-round efficient Data Storytelling the use of a supporting Business Intelligence solution is recommended. The BI-Software Qlik Sense already offers an integrated Data Storytelling tool, that allows you to combine different analysis-, reporting- and presentation technics. A special mechanism for making static snapshots of your favored data, which can be put together to an appropriate story on slides, is provided. The static snapshots can be arranged with different effects and the attention of the audience will be channeled on specific information.

For more interactivity, it is also possible to access the source (e.g. the corresponding live data) of the static snapshots during the presentation. Another possibility for more interactivity is the integration of worksheets into the slides. For more information about the Qlik Data Storytelling tool, watch the following video:

Qlik Data Storytelling

 

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!

Qlik publishes new release “Qlik Sense June 2017”

Qlik Sense June 2017BI provider Qlik has published a new release of Qlik Sense. The latest version contains various interesting features such as better charts and visualization options, advanced analytics functions, an iOS client, visual data profiling and more. The version is named “Qlik Sense June 2017” in line with the new release cycle announced by Qlik.

Already at this year’s Qonnections, Qlik announced that in future new software releases of equal weight and scope will be published every ten weeks – signifying an end to major and minor releases. To clarify this, they replaced the numerical name with a description containing the month and year of the respective release. Qlik Sense 4.0 thus became Qlik Sense June 2017. The new cloud-like release cycle and changed versioning should significantly simplify upgrading to higher versions.

New features for data processing and visualization

Qlik Sense June 2017 contains various new features, particularly in data processing and visualization options. Users, among other things, benefit from improved data preparation and provision without complex scripting. With visual data profiling Qlik Sense June 2017, e.g., supports better understanding data from the get go by automatically generating visualizations for the distribution of data already when loading. Furthermore Data binning allows for the grouping of numeric data (by size etc.) to better analyze relevant information. Using a new type of table concatenation, table views with different fields and field names can additionally be connected. This makes it possible to concatenate differently created data sets (e.g., from different organizations). The data preparation functions are introduced in the next What’s New video:

Qlik Sense June 2017 - Data Preparation

Continue reading Qlik publishes new release “Qlik Sense June 2017”

Take control of your financial operations using Qlik Sense Enterprise

Qlik FinancialsQlik’s diverse business intelligence solutions enable you to easily and efficiently evaluate and visualize enterprise data from all sectors. Users in finance departments can also benefit from the comprehensive functions of Qlik Sense Enterprise.

For example, Qlik Sense Enterprise can help business managers and their finance departments obtain a better overview of their operational and financial processes through its dynamic prognoses and analyses optimization apps. The applications extract and link basic data from different sources. The update frequency is hereby freely configurable regardless of whether you are using an ERP system, Excel files, or access to Web APIs. With Qlik, you are no longer limited to partial analyses that are hinged to query-based solutions. Qlik’s associative model enables you to create visualizations of all your data and hence identify previously unidentified interrelationships.

Diverse application possibilities in the finance sector

Important application areas in the finance sector include data quality improvement for accurate calculation of key parameters, fast plausibility checks for ERP booking routines, and the creation of interactive company reports. Data evaluation and visualization of interrelationships using Qlik Sense Enterprise therefore contribute towards better financial planning, cash flow optimization and ultimately better results. Unlike other resource-intensive, inconsistent budgeting solutions, Qlik Sense Enterprise also enables users without advanced technical skills to compile reliable financial analyses and reports thanks to its ease of use and self-service functions. Below are some of the options and advantages provided by Qlik Sense Enterprise:

  • “What if” analysis
    Allows managers to test different prognosis scenarios and budgets as well as to evaluate the impact of possible results.
  • Comparative analysis
    Allows users to compare different budget allocations, resources and cost estimates.
  • Fast integration of multiple data sources
    Creates a comprehensive overview of planning and budgeting data from various data sources.
  • Collaboration and annotations
    Enables optimized group decisions through interactive sessions and comments on modification of functional delays.
  • Comprehensive partner network
    Best possible budgeting and planning applications of different partners – tailored to specific business requirements.

Its numerous functions and the ability to connect multiple data sources make Qlik Sense Enterprise the ideal basis for controlling different financial processes. Qlik Sense Enterprise provides efficient support for tasks such as financial forecasting and analysis, cost and risk management, validation of sales and profitability indicators, investment analysis, cash flow and balance sheet management, etc.

The following video shows 10 use cases of Qlik Sense Enterprise in the finance sector:

Qlik Finance Toolkit

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.