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