9/28/2023 0 Comments Google my maps app![]() All geographical data must be loaded into Data Studio as a STRING. A side note here, BigQuery GEOGRAPHY data from public data sets does not work well in choromap even after converting it to GeoJSON, see the Known Limitations section at the end of this post. To start, Google Data Studio does not recognise BigQuery GEOGRAPHY data. The first challenge was to get Google Data Studio to recognise geographical data. Data: Fitting a square peg in a round hole Here are Counties and Unitary Authorities for England, UK. Currently, there is no ability to visualise polygons in Google Maps in Data Studio, meaning that choropleths such as below, cannot be created.Ĭhoromap allows the user to choose the boundaries they want to visualise. ![]() The Google Maps tool in Data Studio allows for the plotting of Bubble Maps, whose centroid can be tied to areas as large as a country, or specific latitude and longitudes. Choropleths cannot be created for smaller areas than these. For the UK, this is UK and devolved nation level (England, Wales, Scotland and Northern Ireland). Geo Map allows for the creation of choropleth maps at country and sub-country level. ![]() Credit to Google though, Data Studio is free, whereas others in the market are not.Ĭurrently, at the time of writing, Google Data Studio only has two mapping tools: Geo Map and Google Maps. It’s just that after using libraries such as leaflet, D3 or deck gl, I was a little disappointed that Google would not have ported their geo-based infrastructure over to their Data Studio product. Even Google’s latest acquisition, Looker, seems to be limited. ![]() Ok, so it isn’t fair to point the finger just at Google in this market, because as far as I can see only Tableau offers a decent mapping capability. Things got off to an amicable start when using the built-in line and bar chart tools however, there was a noticeable lack customisable mapping tools in Data Studio. Having used data visualisation tools like Shiny, D3 and Dash to create bespoke dashboards in other projects I did groan when asked to use Google’s late entry into the dashboard market. Over the past few months I’ve been using Google Data Studio in my role at the Data Science Campus, Office for National Statistics. ![]() Creating choropleth maps in Google’s Data Studio ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |