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

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.
The full story
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.
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.
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.
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
Ask Pai
Ask Pai about this case
Pai is an AI. It only knows what is written on this page.
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.