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.
"With QlikView, we can easily bring together all relevant information on one interface and are more quickly and, most significantly, more comprehensively informed." - Beat Zuberbühler, head of management support, ASGA pension fund
The ASGA pension fund, with approximately 9,500 member companies and more than 76,000 insured members, is the largest independent business pension fund in Switzerland. Since 1962, the company has been committed to the professional pension scheme of small and medium enterprises from trade, industry, commerce and the service sector. The businesses are attended to by 70 employees at four locations. Services range from individual solutions for BVG obligatory insurance to comprehensive non-obligatory pension and disability and accident.
Departments: management, sales, controlling
Region: St.Gallen, Switzerland
System environment: Application: WinPKS, DW/BI: SQL-Server, Database: SQL-Server, Hardware: HP ProLiant DL380
Implemented technology: QlikView
Project duration: 8 weeks
In order to support the internal business consultant in controlling the sales force, a particular kind of reporting was required. Rather than entrust this to "hard programming" from the core software supplier, Beat Zuberbühler, head of management support for the ASGA pension fund, remembered a live demo presentation of business discovery solution QlikView. "This reporting requirement was, from my point of view, ideal for being implemented with QlikView," said Zuberbühler. "At the same time, we decided to expand this pilot project to management and distribution analyses."
Previously, data for relevant reports had to be read separately from a central application and the accounts payable system and then merged and analysed manually.
Zuberbühler initially became aware of QlikView because of the technological base that allows the combination of different data sources on one interface. QlikView uses a main memory-based approach. In addition, the BI solution has an inference engine that automatically creates associations between data. Data is compressed to up to 10 percent of its original size to optimise processor performance.
Secondly, the self-service BI approach was very persuasive: this enables users to examine their data freely, so they are no longer limited to following a predefined path of questions. At the same time, the color-coded interfaces and mouse click control are very convenient to use, even for operators without in-depth IT knowledge
Only eight weeks are required from the beginning of a project to going live. The pension fund is professionally supported by the Informatec Ltd.liab.Co. application - and the company can easily make GUI adjustments in-house - a significant factor in terms of cost efficiency. Currently, 20 employees from management, sales and controlling use QlikView for the reporting of some 27 million records from WinPKS. With the broker-reporting it is possible to check, among other things, whether there are discrepancies between commission calculations and actual disbursement. Insurance contracts are also displayed according to the distribution channel, company, industry code etc.
In addition, there are analyses of active account development and actuarial reserves as well as stock development according to factors such as age or professional group. The area manager particularly appreciates the graphical display options. At a glance, the core information is recognisable among the mass of available data.
A positive secondary effect is the improved data quality: faulty records in the source systems can be directly identified and corrected.
Qlik Expertise Financials Services
QlikView reports have also become established as an important source of information for our customers: for them, the transparent information on age structures is an important added value, for example with regard to decisions on changes in social benefits or in planning the recruitment of new staff.
Businesses particularly benefitted in the area of consulting for corporate clients and sales partners. "Previously, consultants had to search for the relevant information in various departments" said the head of management support.
In future, the CRM system of ASGA will be linked to QlikView. Moreover, integrated viewing of total tenders is planned.
Download Success Story ASGA (PDF)
Our basic principle is that we are a safe fund. Our acceptance criteria for new customers are very strict," explains Zuberbühler. "Thus it is of vital importance for us to know precisely what age group the insured belong to and which professional branch they are from. With QlikView, we have the valid information at our fingertips and can make decisions much more quickly." – Beat Zuberbühler, head of management support, ASGA pension fund
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