accoTOOL
Free trial
← All cases
Customer case

PensionDanmark

For their real-estate and accounting department, PensionDanmark built a solution with Power BI and Accobat's planning tool accoPLANNING to handle budgeting and maintain master data.

They downloaded accoPLANNING on Microsoft AppSource and started the journey themselves, with support from Accobat.

800k
Members
23,000
Private & public companies
Feb 2023
Went live
100%
Excel removed from budgeting
Testimonial

Hear it from the team

In their words
Jacob Rønnow

“Having a common solution, where we do budgeting into Power BI with the writeback capability of accoPLANNING, is a very good fit for us.”

Jacob Rønnow
Head of Data & Analytics, Datahub
Stig Lauridsen

“I downloaded it from AppSource… it was a matter of a few hours, and then we were up and running and building on the solution.”

Stig Lauridsen
Senior BI Specialist, Datahub
Hung Huynh

“After the implementation of accoPLANNING, we have eliminated all Excel from our budgeting and reporting processes.”

Hung Huynh
Accounting Chief, Properties
About PensionDanmark

PensionDanmark is one of the largest European pension funds, 800,000 members across 23,000 private and public companies, all covered by collective agreements between 11 unions and 28 employers' associations.

Property. The property department, where accoPLANNING is used, invests in and develops housing for seniors, hotels, domiciles and more.

The challenge
  • Time-consuming, Excel-driven budgeting and forecasting
  • Project managers juggling many systems, actuals & master data in ERP, budgets in Excel, comments in Word/PowerPoint
The outcome
  • One system. Power BI + accoPLANNING, for budgeting, forecasting, commenting, master data and reporting
  • Manual processes removed, saving time
  • Real-time insight drives faster decisions
Representing PensionDanmark

Three views, one solution

See how accoPLANNING makes a difference for different stakeholders, from strategy to the technical build to daily use.

Top level
Jacob Rønnow
Head of Data & Analytics, Datahub
  • Worked with data & analytics since 1997
  • 15 years in pension
  • On Microsoft’s Executive Board for Data & AI in Denmark
Technical level
Stig Lauridsen
Senior BI Specialist, Datahub
  • 23 years in data & analytics
  • Works with Power BI and data warehousing
User level
Hung Huynh
Accounting Chief, Properties
  • Responsible for financial follow-up
  • Project management & property reporting
  • Solution owner and end user of accoPLANNING
Solution overview

From Navision to Power BI

Accounting data from Navision flows into a Data Delivery Platform and is made available in Power BI, connected with accoPLANNING.

Dynamics NAV
Accounting / ERP source
Data Delivery Platform
Azure SQL Database
Power BI + accoPLANNING
Report, plan & write back
Writeback returns plan data straight to the Azure SQL Database
Prerequisites
Access to and basic usage of Power BI
Azure SQL Database
Key features used
Audit log
Comments on budget need
Writeback
Show/hide per user
Drag and drop
Lock & version budgets
Multiple budget versions
SQL writeback authorization
Effects
Real-time update of planning data
Higher data quality
Immediate insight
Faster decisions
Master data updated in accoPLANNING
One tool for project follow-up
Saving time

Budgeting and reporting in one solution

PensionDanmark's main problem was two separate systems for maintaining budgets and comments, a headache for project leaders. accoPLANNING was introduced to solve budgeting and to maintain master data. Jacob Rønnow brought it to the CFO, they evaluated it together, requested a demo and trial, and shaped the features they needed with Accobat. They went live in February 2023. Their favourite functions: the writeback into the Azure SQL database, plus Comments and Audit, which let project leaders comment on the budget.

Approved on AppSource

PensionDanmark is a Microsoft house, running on Navision (NAV), with Power BI on the shelf. Getting accoPLANNING from AppSource was a great fit from a security and compliance point of view: easy to download and work with, and only a matter of a few hours before it was up and running.

accoPLANNING meets expectations

Their missing link was writeback, and accoPLANNING stands out because it is connected directly to Power BI. It was important that the tool had Power BI as its origin, not the other way around. Reporting is built in, and the approval functionality is a key feature. accoPLANNING met all their expectations, and if the success continues they plan to expand it to other areas.

Satisfied with Accobat's support

PensionDanmark valued the close dialogue with Accobat during implementation. As a local partner, Accobat was the obvious choice, and they couldn't find another solution that combined budgeting and reporting in the same interface with Power BI as the starting point.

Want to try accoPLANNING?

accoPLANNING for Power BI empowers business users with advanced planning, budgeting and forecasting, and database writeback.