IBRD Statement of Loans
📌 Type
Multiplatform
Automation
⚜️ Domain
Banking
International Development
💻 Technologies
Python (Jupyter Notebook)
SQL (MySQL, MSSQLServer)
MS Excel
Power BI
Tableau
🕹️ Skills
Database Management
Data Transformation
Data Analysis
Data Visualization
Business intelligence
🏦 Statement of Loans of The International Bank for Reconstruction and Development. Get to see how the World Bank lends money, which countries, amounts due and more!
⚡ A fully automated, start to end, multiplatform process using the real-time* real-data from The World Bank Group, including data extraction, transformation, storing in relational databases, querying and visualizing in beautiful interactive dashboards!
🐍 Wrote a Python script for data extraction through an API or csv files, then transforming the data and get it ready for exporting, finally connecting to the SQL database and inserting the data; using libraries such as Pandas and NumPy. The script can be ran whenever new data is available.
🛢️ Constructed a relational database in both MySQL and MSSQLServer, designed in MySQL Workbench, composed of tables, foreign keys, stored procedures and more.
🔎 Wrote several SQL queries compatible with both platforms for a fast and precise retrieval of useful information and to check that the dashboards' data is accurate.
📊 Created 3 beautiful interactive dashboards in 3 different platforms: Tableau, Power BI and Excel. Retrieving data from the SQL database and displaying it with useful charts into 3 dashboards: Loans, Countries and Details; now with a dark mode toggle!
*real-time has been disabled since there is no maintenance for this project.
Interactive Dashboard
Original Tableau dashboard size: (1280px x 720px) (16:9)
If the dashboard does not display fully, zoom out, click full screen on the bottom right, set the display scale of your monitor to 100% or use a bigger one.
You may also go to Tableau Public.
Screenshots
Python Code
Written in a Jupyper Notebook, all in one file 'ibrd_stmt_loans_get_transform_data.ipynb'.
It's meant to run locally since the SQL servers are in the local computer, however, it can be adjusted to connect to any server.
You can get the .ipynb file in GitHub!
Story of the Project
Inspired by some courses I embarked on this big project where I found this dataset of loans from The World Bank, and got to work on an automated process to get the data from the source to a database to a dashboard. Using a lot of my technical skills in programming, designing, databases and visualization with the combination of tools like Python, MySQL and Power BI.💡
Different platforms were used in order to test my skills for using multiple tools and get the same output, get really comfortable doing things that might be easy on a platform but no so much on another while simultaneously taking each platform to its full potential. I learned a lot while doing the project because I wanted to do a lot of advanced things in platforms I haven't used much before, but learning while doing is something I like a lot! 😃
This is my biggest project yet and I am very proud of how it turned out, from the code to the colors. This really shows my ability for full process projects and multiplatform dominion. 💪