The Berka Dataset Visualisation

An anonymised dataset from a Czech bank, known as the Berka Dataset was downloaded from here. This dataset was prepared by Petr Berka and Marta Sochorova. The data about clients and their accounts include:

  • Account details
  • Client details
  • Disposition details; which client has the right to operate an account
  • Standing Order details
  • Transactions details
  • Loan details; each loan is linked to an account
  • Credit Card details; each credit card is linked to an account
  • Demographic details; characteristics and statistics for a district

Each of the above is stored in a separate CSV file, which was loaded to PowerBI. Data cleaning was performed on various relations, mainly translating Czech to English, and date conversion. The relationships between each table were then identified. More information about this dataset can be found on data.world and here.

A report with a number of pages highlighting some aspects from each relation was then created.


MIA Passenger & Aircraft Movements Dashboard

We are proud to launch a free public Business Intelligence (BI) dashboard based on the Malta International Airport (MIA) public data of aircraft and passenger movements. This showcases the importance of data visualization, which leads to insights and reflection to ask very valid questions. In this article, we shall go through the different sections of the tool and in a subsequent article, we shall give an overview of the cleaning process and some insights.

The report contains passenger and aircraft movements from MIA between 2005 and 2016 with the possibility of filtering by Year, Country, and Airport. The Airline market share is available from 2004 until 2016 with the possibility of filtering by Airline and Year. The passenger to aircraft ratio is a metric that measures the aircraft occupancy rate, and we are providing it for the top 5 airlines with the possibility of filtering by year. The same metric is also provided for 5 airlines with the possibility of filtering by year and country.

Continue reading part 02 for insights from the dashboard.


We would like to note that the data is as found on the MIA and NSO sites and ensquad Ltd. does not take responsibility for the correctness of said data. We would also like to note that this tool should not be considered in isolation, meaning that no concrete conclusion can be made without further investigation. Should you have any queries feel free to contact us on info@ensquad.frankieinguanez.com