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

 

Microsoft 365: New Cloud-Bundles officially available

Microsoft 365 Cloud BundlesAs already announced on this years’ „Inspire“ partner conference, Microsoft has now released the Enterprise version of its new cloud service package Microsoft 365. The Business Edition can currently be tested in a public preview.

The new bundles combine different cloud-based Microsoft services. It is possible to provide the user with a modern, intelligence and safe workplace now. In order to meet the requirements of different companies, from small companies to large corporations, the packages are available in two different models.

The Enterprise Bundle includes the Enterprise versions of Office 365, Windows 10 and Enterprise Mobility + Security (EMS) for larger companies and supports the employees by modern technologies (e.g. Machine Learning and Artificial Intelligence) and an extensive choice of apps and services. These not only increase the creativity and flexibility, but also improve the communication between individual users and teams as well as the IT- and security structure within the company. Microsoft 365 Enterprise is already completely available.

On the other hand, Microsoft 365 Business was produced for smaller and medium-sized companies and includes Office 365 Business Premium and security- and management capabilities for Office apps and Windows 10 devices. In addition, it offers the possibility to upgrade to Windows 10 professional. Users will be offered a complete suite of productivity and security applications, which will also help to relieve the IT department. Moreover, it offers employees, customers and business partners the possibility to connect with each other and allow them to work at every optional place and device – always protected by special security precautions. You can now test the business version of Microsoft 365 in a public preview, the full version will be available in autumn 2017.

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!

Microsoft Dynamics NAV 2017 – liquidity planning

Only companies that keep constant track of their funds can plan ahead and guarantee their capacity to pay. Here, constant monitoring of solvency development is particularly important. Microsoft Dynamics NAV offers the required tools.

Careful cash flow planning, also integrated into Microsoft Dynamics NAV, is necessary to correctly control and analyze cash flows in a company. This software draws all relevant information from various business areas (e.g. purchase and sales) and uses it as a basis for forecasts on all incomes and cost for a set period. One large advantage of cash flow planning is the inclusion of target figures such as posted orders. As the information used is real-time, it can be traded quickly as needed. This does not properly work in isolated financial accounting, as here only logged values are available.

Dynamics NAV 2017 Cash Flow
Cash Flow Planning in Microsoft Dynamics NAV 2017

With the 2017 version of Microsoft Dynamics NAV, two new areas have been added to the cash flow functions – areas that also play an important role in planning:

  • The projects or project incomes
  • The VAT settlement (more detailed, the determination of VAT payable amounts)

It is now also possible to manually enter neutral incomes and cost. In this way, amounts outside of Dynamics NAV can be considered as well.

Dynamics NAV 2017 Cash Flow
Includable origin types in Cash Flow Planning

At first use of the cash flow tool, from version 2017 upwards, users are additionally assisted by a configuration assistant. This guides them through the necessary parameters, allowing users to define these by themselves.

Relevance of high availability on the rise

High AvailabilityIn times of growing digitalization, it is almost impossible for companies to operate without Internet availability and the right business software. Therefore it is very serious when a network component or even the entire IT infrastructure goes down. Even short downtimes can result in high costs and annoyed customers – another reason to tackle the topic of high availability in one’s own company.

The importance of high availability has already been deeply rooted in the corporate awareness of large companies. Small and mid-sized companies, however, still often put the topic into cold storage due to time and costs. A big mistake, considering that longer network and database downtimes can, in critical cases, even threaten the continued existence of companies. The aim is to keep systems available even if one or more components relevant to the company go down. Only after it is already too late and components of the infrastructure are already down, most companies usually first realize the importance of high availability. However, not only sudden failures of the systems or individual components, but also planned downtimes, for example in the case of necessary maintenance work, should be considered.

Different levels of high availability

A system can only be classified as highly available if it manages to achieve more than 99.9% availability in 24/7 operation. Downtime is thus reduced to less than 8.5 hours over the course of year. Adding further decimal places subsequently increases availability. According to this, an availability of 99.9999 % means a much shorter downtime of around 32 seconds in a year. This classification form also serves as a benchmark for highly available systems on the IT market.

Continue reading Relevance of high availability on the rise

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”

Time for change: When an update of your ERP system is necessary

ERP UpdateFor many companies, the use of an ERP system has become an indispensable element for managing business processes. At the latest when a company grows or its requirements change, current software functions may not be sufficient, making an update or even a change of system necessary.

An ERP system provides a business and employees with optimum support across several corporate divisions. In most cases, the desired processes are facilitated by acquiring a software whose corresponding functions are most in line with existing corporate and user requirements. Yet many companies think that the functions, which were implemented in the beginning, become insufficient over time due to growth and structural or technological changes and therefore need to be adapted accordingly. Before the ERP system application becomes too complex due to excessive technological customization and causes a reduction in productivity, it is recommended to update to a newer, improved, and more comprehensive version.

Technological change requires action

Global economic and technological IT-developments are increasing rapidly, and factors such as digitalization and the ever-growing amounts of data that need to be processed are major challenges to technology and business processes. Many recent ERP systems, for example Microsoft Dynamics NAV, are already offering a variety of features, as well as interfaces with significantly improved user experience software, which means working with the respective system is easier, faster, and more convenient than it was a few years ago. The systems provide the user with an unmatched degree of scalability and enable access to the desired data from any mobile device or location by means of Web, Tablet, and Phone Client – a particular advantage for field staff, warehouse employees, or those working in manufacturing. Therefore, ensuring that their in-house ERP systems can keep pace with these developments is important for modern, small and medium-sized businesses.

Moreover, most companies are faced with continuous change themselves. Company growth and even strategical or structural changes can be decisive when it comes to the need for new functions and updates in order to continue to be able to meet market and customer requirements.

In general, an ERP system should always be able to map all the business processes required by the respective company in their entirety. Depending on its technical and functional specifications, not all software is automatically suitable for every business. It is necessary to ensure that the desired processes and functions are in place when purchasing the system. However, if these have changed or become more enhanced over the years, action is required.

Better act sooner than later

Regardless of whether the implemented ERP system was the wrong choice for the company or whether the requirements simply changed over time: if an ERP update or change is necessary, it is important to act quickly. The more time passes, the more the costs incurred by using an outdated system, as well as the costs of a change or an update, will increase – a problem which can ultimately be prevented by implementing a new solution. Many modern ERP systems run automated updates, which means that expensive and time-consuming upgrades are redundant. The software basically grows with the newest developments and technologies.

Are you planning to change your ERP landscape as well? Our consultants will be happy to assist you. You can also find out what you should consider when choosing an ERP system by reading our blog.

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

Microsoft Dynamics NAV 2017 – New Features for Developers

Microsoft Dynamics NAV 2017Since last October, users have been benefiting from the many new features introduced by the latest release of Microsoft Dynamics NAV. But there are also several enhancements for developers to discover in the 2017 version.

One of the most important changes is the expansion to options for creating extensions, whose basic functionality was introduced back in the 2016 release. Developers are now able to utilise the remaining object types (Reports, XMLPorts and Queries), which the extensions now usefully make available for creating more comprehensive solutions. Thanks to the new extensions, enhancements can now be built for Dynamics NAV without making changes to the platform’s standard objects. This simplifies the update process in particular, since the base system can be updated and the extension layer is then updated automatically from the service tier. Extensions can also be easily removed again without trace. In addition, extensions from NAV 2017 onwards can now include report templates, table content, permission sets, add-ins and much more besides.

In the next Dynamics NAV version (codename “Tenerife”), developers will also be able to draw on an in-client designer and the Visual Studio Code development platform for creating their extensions. Since last December, the new tools can already be tested by downloading a public Developer Preview.

With the new “application areas”, Dynamics NAV 2017 also makes things simpler for developers when modifying the user experience to the specific application requirements of the individual user. Administrators can now assign sets defined by a developer to application areas, so that the end users only see elements of the user interface that they actually require in order to complete their various tasks.

prisma informatik