Trade Tariffs Consultancy Dashboard

The client is a UK-based consultancy which helps other companies save costs paid as import tax upon import of international goods into the UK. The data source was an Excel file that is usually sent by HMRC. The scope was to analyse import taxes and areas of improvement.

Data Source

Excel

Analysis Tool

Google Data StudioTableau

Overview

The page shows the value of goods that were shipped, tariffs paid countries that goods were imported from and duties paid for each consignment.

Most importantly the dashboard shows by how much the tariffs are overpaid since this shows the area for improvement to the clients.

Procurement

This page analyses the commodities that were imported to the UK by a particular company, where they are imported from and what is their value.

Trend chart shows the value of these imports over time.

Tariffs

This page focuses on the tariff cost that is paid by a company, what it was paid for and by how much it was overpaid.

Benchmarking

Points of entry for goods into the UK are analysed. Whether goods were imported on time or late is also visualised on the dashboard.

Top commodities by import value are also visualised on the dashboard.

Supply Chain

Movement of products from country to country is visualised on the heatmap at the top.

Country of origin for the imported goods is also visualised.

Tariff duty paid by consignor and commodity is presented in a table.

Ways we can help

Support

All the support you need – when you need it. From 1-hour quick fix support to longer-term partnership that drives your business forward.

Consultancy

Advanced data thinking, creative  ideas and the best Power Platform practices to unlock the true potential of your business data.

Training

Succeess shouldn’t be a one-off. When we train you teams user adoption surges and your Power Platform results radically improve.