SQL Made Banking Easier: World Bank Analysis Using SQL

Introduction:

Me being a data enthusiast who is always lenient towards huge data sets consisting of big numbers. That being said, the data set in finance sector meets my enthusiasm. Also, I always wanted to do a project in finance sector that’s when I started looking up for a banking/finance data set and ended up with the IDA’s (International Development Association) World bank data set.

IDA is an important group of World Bank Org which helps in creating a world free of poverty. The International Development Association (IDA) helps poor countries by offering the loans at zero or low interest for the economic development of country, reduce in-equalities improve people’s living conditions.

Key Find outs:

I acted up as a Data Analyst for IDA and resolved the below ad-hoc questions using SQL.

• Total Number of transactions per country: India has 63,624 transactions with IDA which is the highest and the lowest is Middle East and North Africa with 17 transactions.
• What are the total number of projects country wise? India is the highest with 455 projects and the lowest is Middle East and North Africa with 1 project which are being funded by IDA.
• What is the max owed and max paid to the IDA Country wise? Ukraine has the maximum due of $10,43,624,506.91 to IDA and Democratic Republic of Congo repaid the maximum amount of $5,61,766,292 to IDA. ?
• Top 5 countries with their respective total owing and total repaid amount to IDA? India secured the first place in both the categories with $ 3566659058642.86 of Total owing amount to IDA and $ 2681652350376.46 of Total Repaid Amount to IDA.

Further Insights:?

• Listed out all the transactions from the India as it is the making use of the IDA schemes in the most appropriate way.
• The list of 52 Projects for which India fully repaid to IDA were listed out.

Let’s Dive into Data:

This Data is originally from IDA which is an important group of World Bank Org. The dataset is updated on NOV 2023 and it is updated for every quarter. This dataset consists of almost 1.23+ million rows and 30 Columns which hold the information about the transactions of different countries across the world with IDA.

If you wish to dive further more into the data set, here’s the link for the DATASET.

SQL Analysis: A big dataset with millions of records? Worry less SQL got you!

SQL is specially designed to deal with large datasets consisting of million records. As a Data Analyst for IDA using SQL to analyze this dataset is ideal.

• Total Number of transactions per country!

The first question resolved here is Total Number of transactions, Country wise with the help of below query. Also, the output is ordered based on the number of transactions.

The above query yielded the below output i.e. number of transactions per each country which is ordered descending manner. India has 63,624 transactions with IDA which is the highest.

• What are the total number of projects country wise?

Secondly, number of projects were listed down country wise using the below query. As we can clearly see that the list is ordered based on the number of projects.

The above query yielded the list of countries with number of projects accordingly. India has the highest number of projects 455 that are being funded by IDA.

• What is the max owed and max paid to the IDA Country wise?

Next, the maximum due amount of each country to IDA and maximum amount repaid by each country to IDA was resolved using below queries.

The beautiful list of countries with their max due amount and max repaid amount were yielded by the above two queries respectively. Ukraine has the maximum due of $10,43,624,506.91 to IDA and Democratic Republic of Congo repaid the maximum amount of $5,61,766,292 to IDA. Also, we can clearly see that India had its place in every category.

• Top 5 countries with their respective total owing and total repaid amount to IDA??

And finally, the list of top 5 countries whose total owing amount is the most and another list of top 5 countries whose total repaid amount is the most was obtained using the below beautiful queries.

India again secured the first place in both the list with $3566659058642.86 of Total owing amount to IDA and $ 2681652350376.46 of Total Repaid Amount to IDA.

In all the above ad-hoc questions India had its place which made me to analyze a few more ad-hoc requirements.

• All transactions from the India (the country)?

As India had its place in every category, all the transactions from India were displayed using the below query.

Filtered the transactions using a where condition which would result all the transactions of India with IDA.

• For how many projects did India repay completely and what projects are they??

As India has the greatest number of projects which are being funded by the IDA, we went a bit further to answer, how many number of projects from India were fully repaid to IDA and what projects were they? The queries below answered the above question.

The list of Projects for which India fully repaid to IDA were displayed below using above query.

The below query identified that the total number of repaid projects from India were 52.

Conclusion:

• India has the highest number of transactions (63,624), the highest number of projects (455), the highest total owing amount ($3566659058642.86) and the highest total repaid amount ($2681652350376.46) with IDA. This shows us how appropriately India is making use of IDA schemes.
• Middle East and North Africa has the lowest number of transactions 17 lowest number of projects 1 which concludes that it is not making use of IDA at all.
• Ukraine has the maximum due of $10,43,624,506.91 to IDA
• Democratic Republic of Congo repaid the maximum amount of $5,61,766,292 to IDA and proved their commitment.
• India has repaid fully to IDA for 52 projects which shows a strong relationship between them.

Call to Action:

My analysis on this dataset is more business driven. “Any questions or suggestions about the analysis? Want to discuss more about data analytics?” Kindly feel free to reach out to me on?LinkedIn?or write up an email to?[email protected] or catch me at MyData Portfolio.

Thank you for reading this article. You have a good day now!

I would like to extend my sincere thanks to?Avery Smith?for helping me on my data journey and guiding me in the right direction of this project.