Cleansing and Transforming Solarmanpv Datasets for Visually Interactive Disclosure of Covert Information of Solar Power Plants Worldwide

New Renewable Energy (NRE) has become a buzzword. The sun is the most widely available source of NRE as its energy is so abundant and not restricted to a single dominating country, unlike fossil fuel sources such as oil and coal. In Indonesia solar power plants (SPP), also known as PLTS, is a growing opportunity as well as an increasing challenge for various stakeholders. The main question is how to grab and convey information on the development of rooftops SPP worldwide to boost their interest in the use of SPP. The purpose of this study is to gather and provide meaningful information in the form of Map Visualization of the distribution of rooftops SPP that have been installed throughout the world, ranked from the level of continents, countries, cities, down to the location. In particular, an interactive map visualization with drilldown (zoom in) and rollup (zoom out) capabilities to enable users to reveal interesting hidden information on global maps with pop-up details. Data processing, analysis and presentation involve data extraction, cleansing, transformation, exploration, and map visualization with folium, as well as additional map visualization using Google Earth Pro. Disclosure of key findings visually improve the quality of information delivery for ease of comparison and evaluation. In conclusion it is proven that the objective of providing map visualization with interactive zoom in and zoom out to drilldown and rollup for revealing relevant finding in the form of pop-up windows at selected points is achieved.