We're onto day 8 of the #30DayMapChallenge.
The theme for today's map is Humanitarian Data Exchange (HDX) - Use data from HDX to map humanitarian topics. Explore the datasets from the Humanitarian Data Exchange, covering disaster response, health, population, and development. Map for social good.
The dataset caught my eye as it's vast! I'm using the Global Population Density for 400m H3 Hexagons dataset from Kontur. I then limited to the Central American countries which is still 286,422 rows of data. As we've seen from previous challenges, more than 30,000 rows is a challenge for Power BI. I've used a forthcoming version of Icon Map Pro that will enable more H3 hexagons to be displayed on the map - in this case nearly 300,000.
The earlier challenge where I used H3 hexagons, Icon Map Pro generated the H3 cells based on aggregating longitude and latitude coordinates, whereas in this case, the data is provided as 2 columns - H3 Cell Index and Population in that cell. Icon Map Pro natively supports these cell IDs so the map configuration is really easy and only requires these 2 fields. I also overlaid a shape file with the country outlines in too, and added a Power BI slicer to zoom to specific countries.
If you'd like to see how the report was built, you can download it here.