World Banking Analysis Project 🌎

In 2015, Nepal captured global attention on April 25th when a powerful 7.8 magnitude earthquake struck the nation. This devastating earthquake claimed nearly 9,000 lives, displaced thousands, and caused over $7 billion in physical damages. The news of this catastrophe rapidly spread worldwide, leading to an outpouring of mourning and prayers for Nepal's recovery from the climate-related risks it confronted.

However, it is crucial to recognize that Nepal is not alone in facing climate change challenges. Throughout the South Asia Region, numerous countries are confronted with similar adversities each year, making them the most vulnerable in Asia.

Why This Project?

As a Data Analyst aspiring to venture into the world of Finance while also expanding my expertise in SQL, this project presents a captivating challenge that aligns perfectly with my interests. I thoroughly enjoy tackling complex questions and employing SQL to analyze extensive datasets, all while effectively communicating my findings to the audience.

Working on a project that involves data from the World Bank, which supports countries in need of financial assistance worldwide, adds an extra layer of significance to my endeavors. This opportunity will put my analytical skills to the test, especially when dealing with financial figures and assessments. By the project's conclusion, I anticipate gaining invaluable experience in handling financial data, which will contribute to my growth and success in the realm of data analytics.

The Data

The dataset was downloaded from the World Bank’s website. You can access the dataset here:

Key Questions

After looking at the dataset from the World Bank website, I decided to focus Nepal on the South Asia Region for this project primarily because it is facing significant challenges related to climate change. Recognizing the urgency and relevance of environmental issues, I aim to contribute my skills as a Data Analyst to better understand and address the impacts of climate change in this vulnerable region.

South Asia has been experiencing a rise in climate-related disasters, including extreme weather events, rising sea levels, floods, and droughts. These changes directly affect millions of people's lives, economies, and natural ecosystems. By focusing on this region, I seek to analyze and interpret large datasets related to climate, weather patterns, and environmental indicators, using my expertise in SQL to extract meaningful insights. My Key questions going into this analysis were:

1. What was the total amount in U.S. dollars provided by the IDA to Nepal?
2. How many total transactions in Nepal?
3. What are the names of the top 5 projects the IDA has extended money to Nepal?
4. Which project(s) the IDA has impacted the most to Nepal?
5. Which project the IDA has extended money to Nepal that was canceled?
6. What was the average amount Nepal received from IDA?

Key Insights

Using SQL, I was able to gain these key insights from my questions:

What was the total amount in U.S. dollars provided by the IDA to Nepal?

• $7,723,357,267.25

How many total transactions in Nepal?

• 22,088 Transactions

What are the names of the top 5 projects the IDA has extended money to Nepal?

1. Earthquake Housing Reconstruction Project ($300,000,000)
2. Strategic Road and Trade Improvement ($300,000,000)
3. ACCESS - Nepal Phase 1 Project ($275,000,000)
4. Nepal Fiscal Reforms DPC ($200,000,000)
5. Finance for Growth (F4G) ($200,000,000)

Which project the IDA has impacted the most to Nepal?

• Earthquake Housing Reconstruction
• Strategic Road and Trade Improvement

Which project the IDA has extended money to Nepal that was canceled?

• URB WATER & SAN REHAB - CLOSED(T) ($45,757,993.36)

What was the average amount Nepal received from IDA?

• $18,166,201.94

SQL Analysis

SQL is the best tool for handling large datasets due to its efficiency and scalability. Its optimized query processing allows for quick retrieval and manipulation of vast amounts of data. In the case of this dataset, there were 1,048,576 rows of data. As a best practice, it is essential to include clear annotations above each query. This ensures that other data analysts can easily follow the analysis and even offer suggestions to enhance query efficiency when reviewing my work.

What was the total amount in U.S. dollars provided by the IDA to Nepal?

Through an SQL query, the analysis revealed that Nepal received a significant loan amount of $7,723,357,267.25, aimed at rebuilding infrastructure affected by climate change and bolstering resilience against future climate-related disasters. However, Nepal has faced additional challenges, including numerous natural disasters and the 2020 COVID-19 pandemic, which further impacted the nation's economic recovery efforts. Addressing these challenges requires an approach to ensure a sustainable future for Nepal.

How many total transactions in Nepal?

Through an SQL query, the analysis revealed this period marked by climate change challenges, it's important to note that a total of 22,088 transactions were conducted by the International Development Association (IDA) to support Nepal. These transactions represent a significant commitment to assist Nepal in addressing the impacts of climate change and related challenges.

What are the names of the top 5 projects the IDA has extended money to Nepal?

Through this section along with the SQL query, this analysis revealed the top 5 projects that was used to help Nepal. The projects listed below:

1. Earthquake Housing Reconstruction Project ($300,000,000)

The Earthquake Housing Reconstruction Project in Nepal aimed to rehabilitate and rebuild housing infrastructure following the devastating earthquake in 2015. Utilizing an SQL query to analyze the data, the total cost for this project is at $300,000,000. One of the notable projects, with the highest original principal amount, stands out as a significant initiative in this reconstruction endeavor. For more insights into these approaches, refer to the World Bank's comprehensive overview: Lessons in Earthquake Reconstruction.

2. Strategic Road and Trade Improvement ($300,000,000)

The Strategic Road and Trade Improvement Project in Nepal aimed to enhance road connectivity and facilitate trade within the country. Utilizing an SQL query to analyze the data, the total cost for this project is at $300,000,000. Using an SQL query, it's evident that this project played a crucial role in improving infrastructure. For further details on the impact and significance of this initiative, you can refer to the World Bank's official page: Nepal Strategic Road Connectivity and Trade Improvement Project.

Climate change has significantly impacted Nepal, affecting road infrastructure due to the increased occurrence of extreme weather events such as floods and landslides. As Nepal rebuilds its roads and infrastructure, addressing climate change resilience becomes paramount to ensure the longevity and sustainability of these improvements.

3. ACCESS - Nepal Phase 1 Project ($275,000,000)

The ACCESS - Nepal Phase 1 Project holds the potential to instigate profound shifts in material transportation dynamics, by providing as a key component to the economies of South Asia. The program is used to yield outcomes for trade operations, providing improvements in paper-based and manual trade procedures, enhancements to trade-related infrastructure, mitigation of transport deficiencies, and provide restrictive trade and transport protocols. The core developmental aim revolves around augmenting the trade and transportation systems within specified corridors across Nepal.

For more information: ACCESS - Nepal Phase 1 Project

4. Nepal Fiscal Reforms DPC ($200,000,000)

The Nepal Fiscal Reforms DPC (Development Partner Center) proposed operation will support the Government of Nepal in its efforts to establish a framework to move towards fiscal federalism and improve public financial management. From the SQL query, this project cost is at $200,000,000.

What is a Fiscal Reform/Policy?

• Fiscal policy refers to the use of government spending and tax policies to influence economic conditions, especially macroeconomic conditions. These include aggregate demand for goods and services, employment, inflation, and economic growth.

The proposed operation aims to support the government’s transition from a centralized to a federal structure and reforms that enhance Public Financial Management (PFM). The activities of the project are organized under two pillars:

(i) Establish a framework to move towards federalism

(ii) Improve the policy framework for PFM

The main development challenges faced by the country include fragility stemming from limited government capacity, political instability, as well as natural disaster related risks. The country had nine governments over the past 10 years and was hit by three large exogenous shocks in the past three years: earthquake (2015), trade blockade with India (2016) and floods (2017).

5. Finance for Growth (F4G) ($200,000,000)

With the project estimated at $200,000,000, the Finance for Growth Development Policy Credit (DPC) Project is geared towards aiding the Government of Nepal in enhancing financial sector stability, expanding the range of financial offerings, and facilitating broader accessibility to financial services. This effort is designed to bolster Nepal's financial landscape, fostering economic growth and resilience.

Which project the IDA has impacted the most to Nepal?

• Earthquake Housing Reconstruction
• Strategic Road and Trade Improvement

Both the Earthquake Housing Reconstruction and the Strategic Road and Trade Improvement projects, each funded at $300,000,000, have left a profound mark on Nepal's landscape, especially considering the climatic changes that transpired over the last decade. The Earthquake Housing Reconstruction project has significantly contributed to rebuilding and fortifying housing infrastructure following the devastating earthquake of 2015. Given Nepal's vulnerability to climate-related disasters, this initiative has not only restored physical structures but has also helped communities become more resilient to future environmental challenges.

Likewise, the Strategic Road and Trade Improvement project has played a vital role in enhancing connectivity and trade networks within the country. Improved road infrastructure is crucial for effective disaster response and recovery, considering Nepal's susceptibility to natural calamities. Furthermore, this initiative holds particular significance due to the climate change-induced impacts that the nation has faced, such as floods and landslides.

However, it's important to acknowledge that these efforts have taken place amidst another significant global crisis—the COVID-19 pandemic in 2020. The pandemic's economic ramifications further highlighted the importance of robust infrastructure, including road networks for trade and transportation, in facilitating essential supplies and sustaining economic activities during such challenging times.

Which project the IDA has extended money to Nepal that was canceled?

URB WATER & SAN REHAB - CLOSED(T) Project had the extended amount of $45,757,993.36 received by the IDA was canceled. Why was it canceled? According to the GWP Nepal, “The Urban Water Supply and Sanitation Policy (UWSSP) was formulated to address the complex operational issues of urban water supply and sanitation service delivery.

It also addressed the need of an umbrella policy to achieve coherent, consistent and uniform approaches of development sector in urban areas by all effectiveness for improved service delivery in proper perspectives according to the need of the day. While working on this project, it appeared to have more complications with the urban water supply and will have to spend more money on this project than expected, which the IDA had no other choice but the canceled it.

What was the average amount Nepal received from IDA?

The query returned $18,166,201.94 as the average amount the IDA has loaned to Nepal to help rebuild a stronger road and housing infrastructures development.

Conclusion

Based on a thorough analysis with this project, we learned several key insights through this research:

1. In 2015, Nepal faced a catastrophic 7.8 magnitude earthquake, resulting in significant loss of life, displacement, and massive physical damage amounting to over $7 billion. The global response to this disaster highlighted the urgent need for recovery from climate-related risks.
2. The challenges posed by climate change are not unique to Nepal; the entire South Asia Region confronts similar vulnerabilities. Extreme weather events, floods, rising sea levels, and droughts threaten millions of lives, economies, and ecosystems.
3. The "Finance for Growth DPC" initiative focuses on strengthening Nepal's financial sector stability, diversifying financial solutions, and improving access to financial services. This project holds significance in boosting economic growth and resilience in Nepal.
4. The projects "Earthquake Housing Reconstruction" and "Strategic Road and Trade Improvement," each funded at $300,000,000, have left a profound impact. The former aids in rebuilding housing post-earthquake, bolstering climate resilience. The latter enhances connectivity and trade, addressing the impact of climate change-induced disasters.
5. COVID-19, a global pandemic in 2020, highlighted the importance of robust infrastructure. Effective road networks and transportation systems proved crucial in facilitating essential supplies and economic sustenance during crises.
6. The "ACCESS - Nepal Phase 1 Project" and other similar efforts demonstrate Nepal's commitment to building forward post-disaster. With robust reconstruction and resilience strategies, the region aims to mitigate capital and humanitarian costs.
7. Data analysis through SQL yielded valuable insights. Notably, Nepal received a loan of $7,723,357,267.25 for rebuilding infrastructure affected by climate change. The average loan amount was approximately $18,166,201.94.
8. The cancellation of the "URB WATER & SAN REHAB - CLOSED(T)" project, which received an extended amount of $45,757,993.36, exemplifies the complexities of infrastructure development and the need for adaptable strategies.

Overall, these projects and analyses underscore the importance of resilience, sustainable infrastructure, and collaborative efforts in addressing climate change impacts and other unexpected challenges that Nepal and the region continue to face.

I'd like to express my gratitude for taking the time to review my work. I hope to receive your insights and comments. It has been an incredible journey with this project, and I eagerly anticipate upcoming projects. Please feel free to connect with me here, and let's thrive together in the world of data!