Editing & Planning in Qlik®

Editing & Planning in Qlik®

Qlik users often lack the ability to edit and plan data directly in QlikView or Qlik Sense. The company INFORM GmbH recognized the need and use of such an extension and developed Write!. With the help of this extension, it is possible to edit data directly in QlikView or Qlik Sense. This way, data can be corrected directly on-the-fly in the applications, or missing data can easily be added. In addition, complex plans can now be created in Qlik.

Editing in the Qlik interface is possible without having to integrate additional data sources such as Excel or CSV files. It can be used in the QlikView Desktop App as well as in the QlikView web view or in Qlik Sense. The data editing takes place here via any desired HTML objects, such as check boxes, dropdown boxes, calendars or even simple free text.

The data storage can take place in two variants. In the simple version, the data from Qlik is automatically stored in external files such as Qlik’s own database format (QVD). In the second variant, data storage takes place in XML or CSV files. Furthermore, Write! offers the market a unique write-back functionality, which provides the ability to restore the manipulated files to any source database. Indeed, it does not matter which database type it is; even playing back in SAP is possible.

In order to meet the specific needs of our customers and prospective clients regarding their Business Intelligence solutions, we rely on a network of strategic partnerships. As a result, we have decided to partner with INFORM GmbH. This gives us the opportunity to easily implement this extension, both in existing Qlik-based analysis and reporting tools as well as in new Qlik projects.

More informations about Write!Edit
More informations about Write!Plan

Review of the “Qlik Consulting Days 2018”

Review of the “Qlik Consulting Days 2018”

The Business Intelligence world of Qlik keeps moving and constantly inspires by virtue of its technical innovations. In order to present these possibilities, the software company Qlik availed itself of opportunity to reach further clients at the Consulting Days from 20 to 21 June 2018 in Düsseldorf, Germany.

The participants experienced two exciting days of events and discovered the new products for 2018, which Qlik offers with its Data Analytics Platform and the patented Qlik Associative Engine. The current release simplifies the creation of suitable visualizations, given the analysis of the data already during the loading process, and recommendations are accordingly made to the user in the course of appropriate visualizations, as based on the content and the field names. Qlik has now become even stronger with the multi-cloud function, and it thus takes the decisive step in a multi-cloud analysis solution.

In addition to these functions and innovations, there were also other interesting lectures on innovative Business Intelligence opportunities at the Consulting Days. Moreover, Qlik partners took the stage and presented the possibility of planning in Qlik-based applications as well as editing data. Among them was a further nice-to-have with a view to the future, namely a voice search, which will provide users with a substantial work relief.

As Qlik Solution Provider, we participated with great interest in this event and are pleased to offer our customers added value for their data analysis.

Qlik® supports in digital revolution – customer event at Meusburger in Wolfurt

Qlik® supports in digital revolution – customer event at Meusburger in Wolfurt

Digitization currently represents a major challenge for almost every company – at the same time, it also offers them enormously beneficial opportunities. Meusburger Georg GmbH & Co KG has demonstrated that the chances of the digital revolution can be utilized, cleverly and efficiently, by employing the right IT strategy and applying the Business Intelligence Suite Qlik®. The primary areas of application include sales, controlling, production, purchasing and WBI Knowledge Management, for example, among many other sectors.

On 1 March 2018,  we organised an event at our customer Meusburger in Wolfurt to discuss the topic of Digital Revolution in Companies. We presented BI practical applications. Thereby, we brought together various companies which are facing the challenge of digitization.

The participants enjoyed an exciting event with a mixture of specialist and practical lectures, rounded off by a factory tour. Moreover, the Meusburger Group also presented it’s WBI Knowledge Management and demonstrated  the user-friendly, pragmatic method of better integrating valuable knowledge into a company.

Review of the QLIK “Visualize Your World 2017”

Review of the QLIK “Visualize Your World 2017”

Given the increasing importance of digitalization and the associated utilization of big data, Qlik organized the annual Visualize Your World in Mainz on 18 October 2017, and this event was very well received with over 900 registrations. As a long-time partner of Qlik, ppmc ag also participated in this event, and it is now reviewing the stimulating discussions which took place in the context of proven BI round tables and informative lectures.

The focus of this great event encompassed Qlik Sense solutions, which easily create flexible, interactive visualizations and make valuable decisions. As a result, truly amazing data relationships are discovered, and the potential of the data is fully exploited.

ppmc ag returned home with new impulses and exciting topics, and it is motivated to optimize the data world of companies with its fresh and formidable knowledge.

Fast data analysis for offset printing

Fast data analysis for offset printing

IT-Zoom, the specialist magazine for business solutions, IT technologies and applications, reports on the use of business intelligence software in offset printing in Schwarzach (AT) in the December issue 2016.

The Schwarzach offset printing company specializes in the production and finishing of fine-grained cartons and labels. To evaluate production data, an olap-based solution has been used so far, which, however, no longer met the company’s increased requirements regarding processing speed and user convenience.
“On the one hand, the process was cumbersome,” explains Arno Amann from Controlling and Project Management at Offsetdruckerei Schwarzach GmbH. “On the other hand, the data access to the live systems took a long time.”
The printing company was therefore looking for a powerful BI solution, which allows data from all required source systems to be retrieved and linked in an automated manner. This includes the ERP system Proalpha, its own operating data acquisition system and a bearing control system for the high-rack warehouse. When searching for the right solution, the printing company received the to recommendation to take a look at the software QlikView of the provider Qlik more closely. “We have seen them in operation at a company in our region and were quickly sure that the solution is right for us.” The uncomplicated linkability of different data sources as well as the creation and adaptation of analysis have convinced us. The storage-based technology of the BI solution allows the consolidation of relevant data from different sources in one application. The BI project placed the printing company in the hands of ppmc ag. The IT service provider is a certified QlikView provider and has already carried out numerous projects in the Vorarlberg region. The proximity of the provider is also appreciated. “I had the opportunity to look over the shoulder of the expert and learn how to use the new BI software. Today, I make 90% self-sufficient customization or customization of applications. The service provider supports me with very complex requirements “, says Amann. Within four weeks the implementation of the new solution, the creation of the data model and the provision of a first analysis application were carried out.

Numerous application areas
In the meantime, four applications have been put into productive use by ten employees in the production, sales, purchasing, logistics, finance and controlling divisions. To control production, key figures such as throughput, efficiency, reject rate and quality rate are generated and analysed. Sales and sales analysis are available on sales platforms according to criteria such as “representatives” or “customers”. A further application includes evaluations of the inventories according to turnover frequency, number of parking spaces, delivery delay, delivery reliability, etc. Within the framework of cost accounting, the BI software is used for analysis of operating document and cost carrier forms. “Every 15 minutes I get an overview of the most important performance indicators, incoming orders, order balances, stock and revenues. This keeps me quickly updated at the current status” says Amann.

Every month, inventory analysis and production numbers are communicated to management in all reporting departments, as well as ad-hoc evaluations on special topics such as risk assessments and in-depth analysis. The offset printing company is benefiting from the faster data provision, as Amann confirms: “In the past, our inventory analysis took two hours before we had a result. With the new software, the current data is loaded overnight, the next day the information is available by click. “In addition, data from any system can be evaluated in one platform. Furthermore, the drill-down / drill-through functionalities can be analysed in more detail. In the next project steps, the existing applications will be expanded further. In addition, a complete management dashboard is planned, which includes the most important figures as well as the last two years for comparison purposes.

Facts
Business area: Approximately 25,000 tonnes of carton and paper are processed per year on the company’s seven printing presses
Company’s export share: 70%
Foundation: 1913
Location: Schwarzach / Austria
Employees: 335
www.offset.at

When knowledge comes automatically

When knowledge comes automatically

The magazine MM Maschinenmarkt reports in the issue 1/2017 about the use of business intelligence software in the company of the standards manufacturer Meusburger at the headquarters in Wolfurt (Austria). Intelligent analysis software at Meusburger takes over the automated collection, transmission and provision of relevant company data. Business intelligence software thus facilitates the internal knowledge management.

At Meusburger counts besides the classic production factors, labour, capital and soil also knowledge management. This knowledge encompassing various topics is systematically collected, distributed, further developed and secured. This means that all employees in the company can be provided with the information they need to successfully manage tasks. For this purpose, people are linked with organization and technology. Key figures, analysis and reports are generated automatically from the ERP, MES and CRM systems of the company via business intelligence systems.

Personalized dashboards
Employees from all departments can access all data relevant to them without prior knowledge of self-service procedures. This information is flexibly analysed and manifold visualized.

Project realization by Qlik partner ppmc ag
At Meusburger, the data discovery solution from QlikView is in use. The BI project was implemented by the Qlik partner ppmc ag. The specialist supervised a professional project realization from the creation of the data model through implementation and application development up to user training.

The times of manual data collection are over
Within a few weeks, a first application was used productively for sales. Analysis of sales and revenue were mapped according to criteria such as region, customer and article including previous year comparisons as well as success measurements of new product actions.

Evaluation of machine data
QlikView is also used in other departments of Meusburger, for example for the evaluation of machine data. In the case of power deviations, the management level can be entered and drilled down to every individual machine. In addition, the BI solution is able to map complex production numbers around topics such as occupancy times, availability, effectiveness and quality rate.

Use in human resources as well as in IT
The personnel department analysis and consolidates QlikView working hours and also the IT benefits from the BI solution.

Qlik Nprinting to provide reports
Centrally generated key figures and analysis as well as weekly reports are provided via Qlik Npriniting. The tool allows easy and quick drag & drop visually appealing QlikView reports and their provision or distribution as PDF or as HTML file.

Conclusion
With the tool as well as the partner ppmc ag, Meusburger sees itself perfectly equipped for the future and will in the future implement existing and new applications for business areas with Qlik solutions.

About Meusburger
The company was founded in 1964 as a one-man business by Georg Meusburger. Today, Meusburger is regarded as a market leader in high-precision mold bases. In addition to its headquarters, the company has sales offices in Turkey, China, USA, Mexico and India and employs more than 1000 people.

The potential of data

The potential of data

At the beginning of 2017, the newspaper “Metall” published a report of business intelligence using the example of two well-known companies in the metal sector. One of them is the family-owned company Meusburger Georg GmbH & Co KG, headquartered in Wolfurt (Vorarlberg). Meusburger is a specialist in high-precision norms with more than 1000 employees. At Meusburger, self-service BI with QlikView is used. The project was implemented and supervised by certified Qlik Solution Provider ppmc ag.

Around 80,000 different articles from the workshop supplies are delivered to far beyond 15,000 customers all over the world. Qlik’s BI solution now allows data to be aggregated to individual machine groups and in turn to departments and high-level areas. Performance deviations are instantly recognizable and do not have to be verified in a time-consuming manner in Excel for each machine as before.

Conclusion: Despite the increasing flood of data, it is possible with Business Intelligence to recognize connections to make correct decisions promptly.

Simple monitoring of working times

Simple monitoring of working times

Violations of working hours and related penalties are a current issue for many employers who are responsible for compliance with working time regulations. Infringements of the maximum working hours are punishable and are subject to more and more control by the authorities and sanctioned with very high fines. To ensure that this does not happen at all, ppmc ag offers the ideal solution or addition to your time management system with the new Business Intelligence Tool ppmc|spot|staff. Time-consuming, working time analyses and reports are a thing of the past with ppmc|spot|staff. Within seconds, and in any location, the user can quickly and instantly recognize all the questions pertaining to human resource management, including the need to make quick decisions and act quickly.

Advantages at a glance

  • Combine all data via interfaces from your programs
  • Visual and meaningful presentation of ad-hoc analysis
  • Fast implementation of the program, very easy in the application
  • Application of the program is possible via any browser
  • Access to current data and data archive
  • Generate and distribute reports in different file formats
Plastverarbeiter-Portal reports about qlik-projects of plaston ag

Plastverarbeiter-Portal reports about qlik-projects of plaston ag

In the September issue, the Plastverarbeiter is currently reporting on business intelligence software in plastics processing. An example of a successful implementation is a Qlik-based solution, which was implemented by the certified Qlik Solution Provider ppmc ag for Plaston AG. To meet its own quality and efficiency requirements for products and processes, Plaston wanted to improve its reporting system. Plaston therefore sought a business intelligence solution that met all analysis and reporting requirements. The data base should include information from the Manufacturing Execution System (MES) T.I.G. as well as data from the enterprise resource planning system (ERP) Microsoft Dynamics.
The software comes from the MES provider Qlik and for the realization of the project, Plaston took the software developers ppmc ag on board.

Systems of intelligence – ppmc conducts a workshop at poesis consulting

Systems of intelligence – ppmc conducts a workshop at poesis consulting

Wolfgang Praschnig, CEO of ppmc ag, presented the latest application examples and implementation possibilities offered by the Business Intelligence Software Qlik on the 22nd of September 2017 within the “Get Digital Transformation Done” event series hosted by the poesis consulting GmbH.
Numerous management participants from executive and supervisory boards of well-known Vorarlberg large companies such as Alpla, VKW / Illwerke, Julius Blum, Zumtobel / Tridonic were informed about the topic “Systems of Intelligence” within the framework of the poesis series of events. Wolfgang Praschnig explained the approach of a BI solution for a ski resort and its implementation using the application software Qlik. Based on a further use case, the use of Qlik was introduced and explained in the sales control of Meusburger.
In addition to these utilization possibilities, the participants could learn a great deal about the potentials of self-BI and BA when they were integrated into company processes. A fast analysis of Facebook traffic on 10 PCs was particularly impressive for the participants on PCs and tablets. Wolfgang Praschnig demonstrated how to use Qlik applications to access social media data free of charge and without the knowledge of others.