From fragmented systems to a unified data warehouse and management reporting

CHALLENGE

Analytics at Hoolekandeteenused was largely Excel-based, with data scattered across multiple software systems. There was no shared data platform or single source of truth for understanding business performance. As a result, producing analytics was labour-intensive and prone to errors, while day-to-day management reporting depended heavily on a small number of individual experts.

SOLUTION

During the project, we built a cloud-based data platform with a Snowflake data warehouse, Tableau reporting and open-source ETL tools including Pentaho, Kestra, Airbyte and dbt. This approach allowed the organisation to start with a lower initial investment and scale the platform gradually as its needs evolved.

RESULTS

Today, key datasets are consolidated in the data warehouse and ready to support a wide range of analytical needs. The organisation now has a single source of truth, bringing together data from systems and sources across the business. An in-house Tableau user base has been trained to handle day-to-day analytics needs independently, from building new reports to creating dashboards. Beyond the core user group, Tableau has also become a natural part of everyday decision-making, with a wider group of employees using it to find answers for themselves.