Power BI dashboard for agricultural production analysis supporting institutional planning and municipal cooperation strategies.
VBP — Valor Bruto da Produção — is Paraná's official measure of the gross value of every commodity grown or raised in the state, broken down by 399 municipalities and 23 regional offices. The annual release was a static PDF that took planning teams hours to query; this dashboard makes it queryable in seconds.
I built the web scraper that ingests each year's release, a small ETL that resolves municipal identifier drift across years, and a Power BI front-end that lets the planning team filter by chain, region, and year. It now backs the early-stage feasibility step for cooperation terms with municipalities.
Decision support for priority production chains in Institutional Planning and Cooperation Terms with municipalities.