Skip to content

Case State Treasury

Reports reinvented – the State Treasury deployed the Power BI solution

The State Treasury generates public statistics for its website on topics such as government lending and the national debt. Working with Digia, the State Treasury updated its old reporting solution to Power BI to make data easier to update and combine.

 

The State Treasury is a multidisciplinary government agency under the administrative umbrella of the Ministry of Finance. It is responsible for a large part of the financing of the Finnish State on a centralised basis, providing Group services connected with the economy and personnel of State agencies, handling State accounting and accident-related reimbursements, and granting military disability and criminal injury compensation to citizens.

When the State Treasury updated its website, it also sought to modernise the statistical reporting solution on its public website to make the data easier to update and combine. It also wanted to give the reports a fresh new look and make the website more user-friendly and interactive.

The project to modernise the reporting system began in the summer of 2018 with a proof of concept, which enabled the functionality of the actual idea to be tested with the aim of locating any issues that needed to be addressed. The actual reports were completed and published in the spring of 2019.

The selected solution was Power BI running on Microsoft’s Azure cloud services. Power BI is used to generate statistics for the State Treasury’s website on government lending, interest subsidies and State guarantees, as well as the national debt on the valtionvelka.fi website.

The statistical data is retrieved from data warehouses by timed batch jobs. One of the data sources is the HALTI data warehouse implemented by Digia. The reports are realised by embedding Power BI reports directly into the reporting website.

Information is provided in live reports from the reporting service, and users can interactively apply their own filters and selections. The reports are provided in three languages (Finnish, Swedish and English) based on the website language selected by the user. The reports satisfy the State Treasury’s duty of service, as users can download data directly from the reports.

What we did

What we used

  • Microsoft Power BI