trade balance dashboard

This was the first full project I have completed in one of my Power Bi courses.

What is trade balance?
It is an economic term that represents the imports and exports of goods between the
countries. We say that a country's trade balance is favourable when it exports (sells to other countries) more than it imports (buys from other countries).

The main point we have analyzed are:

• Whether the Brazilian trade balance is favourable or in deficit.

• What are Brazil's main exports in values and volume

• Which countries buy most from Brazil and what do they buy

• Which countries do Brazil import most products and what do they import from them

• The import history of the last 5 years

• Display the values in Dollar(U$$) and in Brazilian Real (BRL)

Data sources: 

The database was obtained from public information available at http://www.mdic.gov.br/

Dollar daily rate was obtained through an API provided by Brazil Central Bank - https://dadosabertos.bcb.gov.br/dataset/dolar-americano-usd-todos-os-boletins-diarios/resource/ae69aa94-4194-45a6-8bae-12904af7e176

Be aware!!

If you are having an issue while you are running this report in pages 4 and 6, this is caused because the range date selected. Try filtering to reduce the amount of data displayed.  The database contains 5 years of transactions, so you might need further resorces to run it.

The course provided by DATAB - https://databinteligencia.com.br/