Back to Projects

Land Prices Dashboard — ParanáCase Study

Interactive dashboard for historical land price analysis in Paraná, built from public DERAL data with a full ETL pipeline and geographic layer integration.

Business Intelligence
2025
Paraná, Brazil
View live site avnergomes.github.io/precos-de-terras

Project Overview

DERAL (Paraná's department of rural economy) publishes a monthly land price report as a series of PDFs. Anyone trying to look at the historical series has to parse the PDFs by hand. This dashboard reverses that — it ingests every release, normalises the categories, joins them to territorial polygons, and surfaces the time series with regional filters.

The dashboard is fully open-source on GitHub; the data product is the PDF pipeline plus the React dashboard on top of it.

Development Stages

  • PDF parsing and data extraction pipeline (Python + pdfplumber)
  • Data standardisation and JSON generation
  • GeoJSON territorial mapping integration
  • Interactive React dashboard with regional and temporal filters

Tech Stack

Python React Vite GeoJSON ETL Pipeline

Outcome

Scattered PDF reports transformed into a queryable data product with territorial filtering and historical price visualisation.