Philippine Barangays on the Map 08-16-2023 19:00 PM - last edited 08-27-2023 01:20 AM

[danextian]

This is my attempt at curating the coordinates of over 42K Philippine barangays or villages by using Power Query (Web scraping and API). I used the list of barangays from Philippine Statistics Authority website for the location and user power query to extract/generate/scrape the latitude and longitude for each.

Notes:

• There are less than 3K duplicate records
• Sanity checked up to region level only  - i.e. if the report is filtered to Ilocos Region which is in  Luzon,  none of the coordinates should be in other regions.

See the others Power BI works I enjoyed doing on my portfolio https://www.novypro.com/profile_projects/danebelarmino.

eyJrIjoiMzY3ZWY2MzktZjcyZi00NWUxLTg3MDctZGJhNmU0MDk5NjNiIiwidCI6ImRmODY3OWNkLWE4MGUtNDVkOC05OWFjLWM4M2VkN2ZmOTVhMCJ9

[technolog]

The dashboard you shared is an informative and visually appealing representation of information about Philippine Barangays. The use of a map with orange dots to represent the different Barangays, along with the list of the most popular Barangays by region and a bar graph showing the population of each Barangay, provides a clear and concise overview of the data. The search bar and drop-down menu at the top of the screen allow users to easily filter the Barangays by region, enhancing the user experience.

Overall, this is a well-designed and informative website that effectively communicates important information about Philippine Barangays. Great job! 😊

[danextian]

Thank you!