Back to Projects

ComexStat ParanáCase Study

Dashboard of Paraná exports and imports from MDIC/ComexStat data — consolidated view of state foreign trade by production chain.

Business Intelligence
2025
Paraná, Brazil
View live site avnergomes.github.io/comexstat-parana

Project Overview

MDIC's ComexStat is the official source of Brazilian foreign trade data. At the state level it's underused because the NCM (commodity code) granularity hides the production-chain story — soybean exports, for instance, are split across dozens of NCM codes that need to be rolled up to be useful.

This dashboard maps every NCM code to a production chain, joins exports and imports to Paraná's chain taxonomy, and surfaces the flows with sankey diagrams and time series. It is the first place in Paraná government you can open one tab and see the state's trade balance by chain.

Development Stages

  • ComexStat/MDIC data pipeline (Python + ETL)
  • NCM to production chain mapping (curated taxonomy)
  • Trade flow visualisations and country-level maps

Tech Stack

React ComexStat API D3.js Sankey Python

Outcome

Consolidated view of Paraná foreign trade by production chain — used by the state's commercial promotion team for trade missions.