← All cases

Data Enlights · Public sector, nature and forest management

A Fabric data platform for Agentschap Natuur en Bos

The Flemish nature and forest agency moved its reporting to a lakehouse in Microsoft Fabric, with dbt and Power BI.

  • Public sector
  • Environment
  • Data platform
  • Dashboards & BI
Client
SectorPublic sector, nature and forest management
CategoryData Enlights
StatusOngoing, with new domains added release by release
Self-service BIon one governed data platform

The problem

Data sat in on-premise SQL Server databases and SharePoint behind a legacy SSIS data warehouse, and older reports used logic that was hard to trace and sometimes inconsistent.

The solution

A bronze/silver/gold lakehouse in Microsoft Fabric, fed through a secured data gateway. Transformations live in dbt with version control and documentation, and Power BI star schemas serve self-service reporting.

The outcome

One documented platform for several domains, released through CI/CD, with rebuilt reports whose numbers trace back to agreed rules, old errors corrected and far less manual reporting.

70,000+ haof nature and forest managed by the agency
6data domains, from nature management and hunting to flooding
10+new enforcement concepts in the reports

The full story

  1. Where it started

    ANB has about 750 employees and manages more than 70,000 hectares of nature and forest. Its reporting covers nature management, hunting, fires, flooding, animal observations and operational applications, all on top of an ageing warehouse.

  2. The platform

    On-premise SQL Server and SharePoint connect to Fabric through a secured gateway. dbt holds the transformation layers as modular, version-controlled SQL with documented business logic, and Power BI semantic models turn them into star schemas. Releases run through CI/CD with Azure DevOps and GitHub.

  3. Rules made explicit

    Instead of copying the legacy logic, every business rule was agreed with the agency. That exposed errors in old reports: targets of sub-areas were averaged instead of summed. Where protected zones overlap, each zone keeps its full area, but the overlap now counts only once in the total.

  4. Reports on top

    Enforcement reporting, on hunting, fires and protected species among others, was rebuilt and extended with more than ten new concepts, such as warnings, inspection reports and seizures. The hunting-permit reports and the report that compares nature-management targets with the area actually managed were rebuilt too. Reports that used to be pulled together by hand are now generated automatically.

Tech

Microsoft FabricdbtPower BISQL ServerData GatewayAzure DevOpsGitHub
Facing something similar?We would shape your version around your own data.

Ask Pai

Ask Pai about this case

Pai is an AI. It only knows what is written on this page.

Baby Pai · AIHi, I'm Baby Pai, an AI assistant. Ask me about the Agentschap Natuur & Bos (ANB) case.

Pai is an AI. Answers come from this case page. Don't share sensitive data.

Chats are kept for 30 days unless you switch that off in Privacy and choices.