Analyzing public web-based data using Power BI: A case study of PTDF 2022 Scholarship List

I am a previous beneficiary of Nigeria’s Petroleum Technology Development Fund (PTDF) oversees scholarship scheme (OSS) on two occasions: (1) MSc scholarship in 2010 (University of South Wales (UK)) and (2)PhD scholarship in 2012 (Cardiff University, UK). The PTDF is “a special purpose fund established to train and make available skilled, competent, and qualified local manpower for the oil and gas industry. It is also involved in developing and upgrading local institutions that are used in providing training and education to Nigerians to make them competent, capable, and skilled to participate actively in the energy industry”.

The impact the OSS scheme made on my personality and skillset is immense, and for that I am grateful to PTDF/Nigeria. In this article, the 2022 PTDF OSS list of successful scholars published on the PTDF website is imported to Power BI (one of the data analytics platforms I am fascinated with) and a dashboard created showing the distribution of scholars by state and region (for MSC and PHD).

PTDF OSS 2022 List of Successful Scholars

The first page of the report above is for the MSC scholars list and the PhD list can be found on the second page.

In a future post, I will share a dashboard with analytics of Advance Metering Infrastructure (AMI) data of Electrical Transformer Loading metering data in Nigeria.

Previous
Previous

Strategizing for Nigeria’s Midstream and Downstream Gas Infrastructure

Next
Next

Websites I found handy