Our spin-off for business planning and simulation with Jedox.
Get real-time insights into your web and cloud-based data sources - now with the free Premium Qlik Web Connectors!
Benefit from our expertise and from the official Qlik training materials - only by us.
"For the first time we were able, without manual intervention, to retrieve expecetd revenue or to see whether we had remained within budget." – Fabian Gfeller, CIO, Packimpex Ltd.
Packimpex develops customised, innovative relocation solutions for international companies and private clients. The relocation service providor, which was founded in 1977, is represented by ten subsidiaries in the whole of Switzerland as well as one in Germany and employs around 300 people. Over 60 percent of the Swiss top 100 companies are among the clients of the Thörishaus / Berne-based company. These are looked after in the areas of relocation, international removals, temporary accommodation and immigration.
It belongs to the business philosophy of Packimpex to increase through the ongoing development of IT solutions and other technologies continuously their effectiveness and their added value for the stakeholders.
Department: Sales and Financial Accounting
Data sources: Jet Reports from Mictrosoft Dynamics, CRM industry software Moveware, Crystal Reports
Implemented technology: QlikView
Project duration: 4 weeks
Previously, Packimpex used Jet Reports for the evaluation of financial figures such as revenue, expected revenue, and cash flow from Microsoft Dynamics NAV. Data from the CRM industry software Moveware, used for order data collection and invoicing, were analysed by Crystal Reports. Evaluations of clients across several countries or individual companies were virtually impossible, because the data was stored in such a deeply segmented manner that it could no longer be merged.
“Just connecting an order with financial accounting was a sisyphean task,” explains Fabian Gfeller, Head of IT, Packimpex Ltd. “The manual effort was enormous, which is why the reports were not created daily but weekly, monthly or even on a quarterly basis only. We wanted more timeliness, transparency and to be able to prepare analyses and reports more easily. Furthermore, it was important to make evaluations available to more people. We wanted the new solution to stand out for its ease of use.”
The relocation service provider wanted to increase the transparency and efficiency of their business information and processes by means of a business intelligence solution. A company-wide management reporting system was to be introduced, in which all client-related subjects could be displayed on a daily basis with updated data from all source systems.
As part of a detailed evaluation phase, the relocation specialist tested various solutions. Among others, Packimpex saw a live demonstration of QlikView in action at a major Swiss energy company - and was impressed.
“We liked the simple connectibility to any data source, the easy manageability and high user comfort so much that we wanted to test, in the context of a seeing-is-believing workshop, whether QlikView was also the solution for our reporting requirements,” explains the IT manager.
When it came to choosing a partner, Packimpex also trusted the positive experience of the energy company and contracted Informatec for the implementation of the SIB workshops. The specialists in advice and needs-oriented implementation of business intelligence solutions, with headquarters in Muttenz, could put their skills to the test with the implementation of a challenging task: In order to increase data quality, a data model was to be developed which established client-corporate connections across all source systems.
And Informatec passed the test with flying colours, as Gfeller confirmed: “Within a few hours they linked data from the order and accounting software through an order number. For the first time we were able, without manual intervention, to assign revenue for clients or client groups, to retrieve expected revenue or to see whether we had remained within budget. And we could already see that automatic analysis on revenue and contracts was also possible on various levels. For example at a total client level, for individual contracts with a client, per client location, per sales staff, etc. “
In the further course of the project the QlikView expert continued to impress with her expert financial knowledge, rapid incorporation of industry specifics and high reaction speed to new or changed requirements: Informatec favours agile project management with the scrum method. Through short consecutive development cycles and a focus on the essential key features, the necessary flexibility to respond to changes in requirements is guaranteed, while still remaining efficient. Moreover, plus points were awarded for keeping within the planned budget.
Within weeks, the sales analysis application could go into production. Meanwhile, the QlikView dashboard creates three further analysis areas: These include an initiation application for the evaluation of data from quote-to-order. How many jobs were bid on, how many were won? How many orders come in per day? What kind of orders? Which business unit is affected? These are typical questions that can be answered with the dashboard at your fingertips.
Also available are analyses of online client questionnaires based on CSS data from an external database. “One of our top corporate objectives is client satisfaction. With the new QlikView application, it is now very easy for us to see whether we also comply with our own quality standards and where we might need to get back on track – moreover per client, per company and per employee,” explained Gfeller.
Regarding quality, in the claim application damage incurred when moving is also analysed. “If we find, for example, that a particular partner makes repeated claims, we can point this out to partners and take joint corrective measures,” says the IT manager. In connection with claim-reporting, Packimpex could also uncover potential for internal training and specifically provide this.
About 25 employees now use the QlikView dashboard and they are all very satisfied, as the IT manager confirmed: “We are getting very positive feedback from the around 25 current users - both in terms of ease of use and the newfound information transparency, as well as the time savings.”
The creation of client feedback reports used to take five hours and due to their complexity were implemented only on a quarterly basis. With QlikView, these reports can now be accessed daily within one minute. In addition, a detailed in-depth analysis is possible down to the level of single days, locations, individual people, companies and scores.
The effort spent on initiations and claim reports, previously only available on a monthly basis, fell from 30 minutes or two hours to one minute.
In addition, the BI solution has been made multi-client capable, so that it can also be used by the German subsidiary in Eschbach and the partner company Hello Switzerland AG - operator of the eponymous relocation information platform.
In the future, the QlikView dashboarding will be expanded. New applications developments in the field of operations are planned, as well as the expansion of existing applications.
Download Success Story (PDF)
“One of our top corporate objectives is client satisfaction. With the new QlikView application, it is now very easy for us to see whether we also comply with our own quality standards and where we might need to get back on track – moreover per client, per company and per employee“
- Fabian Gfeller, Head of IT, Packimpex Ltd.
We support discerning SME clients, using innovative business intelligence solutions, to find sound answers to business-related issues and so make the right decisions for safe and reliable company management.
iVIEW BI-PLATFORM TECHNOLOGIES