Trade in Europe

a9126030767 — Fri, 26 May 2023 08:59:58 GMT

How to transform huge tables from Eurostat to interesting analytics for everyone

In 4 pages you can find information about all trading developments in the TOP-10 European countries by GDP during 2015-2019 and answer the questions: who was the trade leader in this period, how this position was changing from year to year, what was the most or the less sellable and buyable cargo category, which transport was used the most for these or those cargo and a lot of others.

This project is based on a real task from a trading company. Made by the Business Intelligence Institute headed by Alex Kolokolov: design and analytics – Daria Filenkova, back-end – Alice Baklitskaya.

How to use the dashboard:

The navigation menu is made with bookmarks and appears by pressing the sing “menu” on the left upper corner. There are also some pages in the menu with insights that we found interesting to show

The navigation menu is made with bookmarks and appears by pressing the sing “menu” on the left upper corner. There are also some pages in the menu with insights that we found interesting to show

On the first page flow map shows trade moving for the one country chosen in the rating diagram and the last country without filters
Bubbles on the flow map always show the country(es) that sells (in the export view chosen country, in the import view countries-partners)

Visuals on the Summary, Country, and Cargo pages that comparing 2 different values – currency and volume (like dynamics and tables) shows USD if you chose Ton K in the main filter on the top

Tooltips on some visuals show additional information in the context of the stroke: a rating of cargo groups in every category in the treemap, trade dynamic in tables and matrix

On the Country page for the countries-partners was used animated bar chart that shows how rating changed year by year. To see that, you need to go through the play button

On the Cargo page, the cost dynamics diagram can show one or several lines together, the color of the button plays the role of legend. Line AVG TOP-10 is different from the AVG only after choosing a country in the table Export-Import.

1 INSIGHT:

Trade volume in Germany in Euro is at least twice bigger than in other countries with almost the same volume in tons. It works as for export as for import and depends on the share of machinery and equipment that is the most expensive cargo category. In Germany, it takes 49%, in the Netherlands only 37%. Also, in other countries, the share of cheap products as oil, coal and other fuels takes up to 11%, in Germany only 3%.

2 INSIGHT:

The main countries-partners for Germany are European Union, Great Britain, USA and China and only in Import of the category Oil, coal and other fuels in the TOP-10 we can see countries like Russia, Kazakhstan, Libya and, etc. The interesting thing is that the Netherlands takes the first position in this rating in Euro, but the volume of importing fuels in tons is almost twice less than in Russia.

3 INSIGHT:

All countries in the TOP-10 in Europe by GDP have a negative export-import balance in tons (volume of the products they sell is less than they buy) and only 3 countries have a negative export-import balance in Euro (the price of the product they sell less than they buy). There is France (-3.8%), Spain (-3.0%) and Sweden (-3.1%). Moreover, in France in 2019 this disbalance fell to -8,8%: demand for the products from the most expensive cargo categories – machinery and equipment and consumables – increased, but France kept the same level of production. In previous years in these categories, France had more money from export than spent to import and was not ready.

4 INSIGHT:

In the most expensive category “Machinery and equipment” Germany and Italy had the maximum profit (export minus import in money units) – 79% and 31%. The Netherlands spent 9% more than has on sales. The biggest difference is in cargo groups “Electrical machinery and equipment” and “Vehicles other than railway” with low cost but a large volume of consumption and “Aircraft, spacecraft, and parts thereof” with a high average price. But if you check the balance between export and import in the Netherlands in general (page Country), you see that it’s positive. What gives the profit? The tooltip on the last KPI card shows that are categories Other, Consumables, and Metals.

You can find a lot of other interesting insights in these 4 pages and think about its reasons. Looking forward to your feedback.

Business Intelligence Institute was founded in 2011 by Alex Kolokolov. We develop powerful tools for decision making and transform ordinary companies into data-driven businesses boosting their efficiency and performance. We specialized in digital dashboards with MS Power BI and Excel and helps business owners and decision-makers to understand big data and improve their business performance.

Please, visit our website and Alex Kolokolov’s LinkedIn profile. We are open to cooperation and ready to work on new interesting projects.

eyJrIjoiZWJlZDg3YjEtMzhmMi00YTZjLTkxOTAtMGU0NGJmOTM4ZmExIiwidCI6ImFjM2FiYzc2LTVjZDctNDhhNy05ZTdhLTc1NmEwMDY0MWU2ZSIsImMiOjEwfQ%3D%3D

Re: Trade in Europe

smolin57 — Thu, 02 Sep 2021 12:46:13 GMT

Very interesting insights. Thanks a lot

Re: Trade in Europe

Icad01 — Thu, 02 Sep 2021 14:32:55 GMT

Nice work 🙂

Re: Trade in Europe

elena_diller — Fri, 03 Sep 2021 17:38:34 GMT

Impressive work!

Re: Trade in Europe

Anonymous — Fri, 03 Sep 2021 20:26:17 GMT

Отличный разбор

Re: Trade in Europe

AMStakhova72 — Sat, 04 Sep 2021 05:16:20 GMT

Отличная работа!

Re: Trade in Europe

Anonymous — Tue, 21 Sep 2021 00:30:04 GMT

Great, it's a very good job.

Re: Trade in Europe

GWafonin — Tue, 21 Dec 2021 14:51:59 GMT

Превосходная работа!

Re: Trade in Europe

Anonymous — Sat, 25 Dec 2021 11:26:44 GMT

it was informative

Re: Trade in Europe

Вячеслав — Sat, 25 Dec 2021 15:29:36 GMT

Великолепная работа! Громада информации и всего на четырех страницах. Браво!

Re: Trade in Europe

Anonymous — Sat, 25 Dec 2021 16:24:04 GMT

Вложен большой труд, цифры грамотно визуализированы. Все четко и понятно, шикарный дизайн

Re: Trade in Europe

Anonymous — Sun, 26 Dec 2021 08:01:01 GMT

Наглядно демонстрирует торговые потоки, супер!

Re: Trade in Europe

Anonymous — Sun, 26 Dec 2021 08:01:06 GMT

Наглядно демонстрирует торговые потоки, супер!

Re: Trade in Europe

Elvira83 — Sun, 26 Dec 2021 17:02:25 GMT

Очень информативный отчет! Крутая аналитика!

Re: Trade in Europe

Anonymous — Mon, 27 Dec 2021 04:00:32 GMT

Интересно, есть над чем подумать

Re: Trade in Europe

Anonymous — Mon, 27 Dec 2021 04:38:17 GMT

все понятно!

Re: Trade in Europe

Anonymous — Mon, 27 Dec 2021 07:49:00 GMT

очень интересно, спасибо!

Re: Trade in Europe

botalova_elena — Mon, 27 Dec 2021 08:08:12 GMT

Отличная работа!

Re: Trade in Europe

mas76 — Mon, 27 Dec 2021 12:36:29 GMT

хорошая работа

Re: Trade in Europe

Anonymous — Mon, 27 Dec 2021 22:33:19 GMT

Unexpected insights, excellent work!

topic Re: Trade in Europe in Data Stories Gallery

Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe

Re: Trade in Europe