Tryg is the biggest insurance company in Denmark and the second biggest in Northern Europe with 3,200 employees taking care of 2,55 million private persons and 140,000 companies (listed on Nasdaq OMX Copenhagen). Tryg‘s insurances include workers‘ compensation, motor, building, contents, transport, house, personal accident and health care. They mainly offer insurances through own sales and service channels and through business partners such as Nordea and Axa Corporate Solutions.
Tryg group puts emphasis on recognizing and comprehending business development processes across a broad and diverse range of areas. To ensure that, Tryg builds and constantly improves advanced planning and reporting models in Microsoft Excel and Access.
Retaining the Excel advantage with Jedox
The challenge was to meet the models’ requirements by performing complex manual processes. It took more than 6 weeks of intensive work to collect and prepare all necessary forecast data, and was further complicated by technical difficulties when trying to display current and future forecasts from three years ahead.
The deficits of Excel regarding budgeting and spreadsheet consolidation contained several risks that led to a bigger work load. Higher error ratio, inconsistent reports, nontransparent version tracking as well as missing accounts and audit trails profoundly complicated the enterprise planning process at Tryg. The spreadsheet-based system needed to be replaced with a professional software solution for planning, reporting, and analytics. In fall 2016, Tryg chose Jedox as their new enterprise planning platform to replace existing Excel/Access models. With the help of Jedox partner Qbit, they migrated all their data to the Jedox database.
Thanks to Jedox and Qbit, Tryg now benefits from integrated and dynamic enterprise planning, including rolling forecasts and time-independent forecasts, automated data integration and validation, as well as real-time consolidation of all reports.
Due to the variety of different insurance clients and cases, there is a multitude of different scenarios Tryg needs to be able to adjust their business to. For example, what needs to be done when there is an increase of burglary? What measures does Tryg need to take – initiating measures to reduce the number of burglaries or adjust the pricing? Anticipating the economic impact of those strategic decisions on the business is crucial.
Increasing reporting efficiency
The new Jedox system helps Tryg to forecast group performance by aligning management reporting with short and long-term business development and futureoriented strategic planning. This facilitates dialogue on the management level, supports confidence in the Group’s efforts and finally brings Tryg on the optimal path. Tryg’s planning and forecasting is measured using different KPI that are calculated and consolidated. The resulting unified forecast is fed by areas such as:
- Premium revenues
- Damage percentages
- Weather and climate conditions
- Initiatives and observations (expected development of craftsmen prices;
campaign efficiency & efficiency of investments and acquisitions in existing and new systems, products, and occupations)
- Expenses such as salaries, IT, etc., prescribing rolling forecasts and adjusting initiatives
- Allocating expenses (distribution of administrative / indirect costs, such as rent, IT, management fee by product and profit center)