The Finance Project using SQL

In most organizations, the datasets can easily result in over a billion rows of data! When it comes to a massive dataset, we can only rely on something other than Microsoft Excel and must use the correct programming language. I used SQL (Structured Query Language) for this project, which easily handles excessive amounts of data.

Let's Start with the Data

The data I worked on for this project comes from The World Bank, which is made up of the International Development Association (IDA), which focuses on helping the World's poorest countries. I have linked the data below:

After uploading the data to bit.io (which runs SQL), I wanted to explore the following:

• How many transactions did Nicaragua have?
• What was the largest transaction Nicaragua made?
• What is the service charge rate for Nicaragua?
• What is the max amount owed to the IDA?

Insight

• The number of transactions that Nicaragua had was 13,922.
• The largest transaction was $116,000,000, which was due to COVID-19 Response.
• The service charge rate for Nicaragua is 8.1%
• The max amount owed to the IDA is $793,256,127.64

Analysis

When working with a dataset, it is essential to look through all the columns; it gives data analysts a more in-depth understanding of the data.

I wanted to focus on the IDA and its relationship with Nicaragua for this dataset. I've shared below the queries I wrote and the results for each below, which would allow others to follow along easily.

How many transactions did Nicaragua have?

I ran the following query and found that Nicaragua had 13,922 transactions in the dataset.

The next question I had was, what was Nicaragua's largest transaction? The following query showed that the largest transaction was $116,000,000 due to the COVID-19 Response.

The next question I had was, What is the service charge rate for Nicaragua? The query I ran showed 8.1%.

The final question I had was, what is the max amount owed to the IDA?

After running the query, the data showed $793,256,127.64 as the max amount owed to the IDA.

Conclusion

From the dataset we received from the IDA, we could determine that the number of transactions that Nicaragua received was 13,922. The country's largest transaction was $116,000,000, which was accepted due to the COVID-19 response. Nicaragua also has a service charge rate of 8.1%. Lastly, I determined that the maximum amount of money owed to the IDA by a country is $793,256,127.64.

Thanks so much for viewing my project; I'm currently looking for opportunities in Data Science; if you have any options or questions, feel free to comment below or email me at rickmatajr@outlook.com. Also, please view my other projects below and connect with me on LinkedIn, Rick Mata.