Back to Customer cases

Automated financial reporting in Power BI

dental serum

No items found.

Dentalum was growing rapidly and needed a more efficient way to manage its internal financial reporting. We created an automated Power BI solution with daily data retrieval from Fortnox - complete with interactive income statement and permission-controlled access for each clinic.

Automate your reportsLearn more about our Office templates

Dentalum is a Swedish dental care group that operates and develops dental clinics across the country. The company offers high-quality dental care, modern treatment methods and support to clinics to ensure both patient satisfaction and growth.

Sector

Health and medical care

Number of employees

1-25

Heading two

When Dentalum outgrew its manual reporting

Dentalum managed its financial reporting manually. It worked in the beginning, but as the company expanded with more clinics, the approach became too time-consuming and difficult to scale up.

Heading two

The need for an automated and scalable reporting flow

This growth created a clear need to replace manual procedures with a solution that could manage data efficiently - with real-time updates and the ability to track finances both centrally and by clinic.

Heading three

A Power BI solution with daily data collection and Fortnox integration

Rehngruppen developed an automated Power BI report that retrieves data daily from Fortnox via a customized data model. The report is visualized in Profitbase Financial Matrix and distributed via the DentalumLuppen app. Each clinic manager gets access to their own data through authorization control.

Heading four

An interactive report that provides insight, control and efficiency

Dentalum now has a modern and interactive reporting system that makes it easy to follow up on finances at all levels. Users can filter on companies, cost centers and periods, select key figures and export the income statement to Excel with one click. The result is a solution that saves time, provides better visibility and enables faster decisions - as the business continues to grow.

Before
After
No items found.
Customer cases

Automated financial reporting in Power BI

No items found.

Dentalum was growing rapidly and needed a more efficient way to manage its internal financial reporting. We created an automated Power BI solution with daily data retrieval from Fortnox - complete with interactive income statement and permission-controlled access for each clinic.

See picturesWatch the demoWatch videoSee more cases

Commission:

This growth created a clear need to replace manual procedures with a solution that could manage data efficiently - with real-time updates and the ability to track finances both centrally and by clinic.

Challenge:

Rehngruppen developed an automated Power BI report that retrieves data daily from Fortnox via a customized data model. The report is visualized in Profitbase Financial Matrix and distributed via the DentalumLuppen app. Each clinic manager gets access to their own data through authorization control.

Solution:

Dentalum now has a modern and interactive reporting system that makes it easy to follow up on finances at all levels. Users can filter on companies, cost centers and periods, select key figures and export the income statement to Excel with one click. The result is a solution that saves time, provides better visibility and enables faster decisions - as the business continues to grow.

Automated financial reporting for expansion

Over the past year, Dentalum has expanded significantly with more clinics. In line with this growth, the need for regular, detailed financial reporting has increased - both centrally and at clinic level. The previous manual handling needed to be replaced with a more scalable way of working.

Daily updates with integration to Fortnox

Dentalum's internal reporting was consolidated and automated with integration to Fortnox. Data is now updated daily in the Power BI report based on a specially developed data model. The report has been distributed via the Power BI app "DentalumLuppen", where each clinic manager has access to their own clinic's figures through authorization control.

Interactive report with flexible analysis

The report is built around the Profitbase Financial Matrix visualization. It allows users to filter by company, cost center and period, and to analyze at both the account and verification level. Users can also control which key figures are displayed and export the profit and loss statement to Excel with one click.

No items found.

Do you need tools to strengthen your brand?

Fill in the form or call 08-120 233 30

Thank you for your message. Your message has been sent
Oops! Something went wrong!

More customer cases