James Dales
icon-map.com/blogs/blogs.html
James is a Microsoft Data Platform MVP and the Azure Data Platform and Visualisation Practice Director at Altius Consulting. Author of the Icon Map Power BI custom visual.
SQLBits 2024
Take an aerial view of your data with a deep dive into spatial analytics in Power BI
In this deep dive session we'll explore the different mapping possibilities available with the map visuals in Power BI, focussing on Azure Maps, ArcGIS and the Mapbox and Icon Map custom visuals. We'll discuss the different options for storing and access spatial data, including Snowflake, PostGIS, SQL Server and OneLake. We'll also show how to use third party tools such as Mapshaper, QGIS, Mapbox Studio and GeoSrver to help your prepare and customise your map data.
In this session we’ll take a deep dive into the Azure Maps and ArcGIS visuals within Power BI, not only showing how best to represent your data on a map, but exploring some of the more advanced features available. We’ll then go beyond what’s available out of the box, and use a couple of the more popular custom visuals, Mapbox and Icon Map to really push the boundaries of what can be achieved in a Power BI report.
The session will cover everything from; displaying point data, aggregation and representing geographic hierarchies, custom shapes and boundaries both as reference layers and choropleth maps, heatmaps, custom map tile layers and backgrounds, displaying images and labels, 3D column charts, custom tooltips and much more. In addition to exploring the visual side of mapping, we’ll also cover data formats such as points, well known text and geoJSON and discuss how to store and process them from different sources including Snowflake, PostGIS, SQL Server and OneLake.
We will also look at related tools such as mapshaper, QGIS, Mapbox Studio and GeoServer to help you prepare your data, deal with different coordinate systems (such as British National Grid used with Ordnance Survey maps in the UK), and create custom map tiles.
This session will be delivered by MVP, James Dales. James delivered may bespoke map solutions with Power BI through the course of his work, and is the author of the popular Icon Map custom visual for Power BI.
The session will cover everything from; displaying point data, aggregation and representing geographic hierarchies, custom shapes and boundaries both as reference layers and choropleth maps, heatmaps, custom map tile layers and backgrounds, displaying images and labels, 3D column charts, custom tooltips and much more. In addition to exploring the visual side of mapping, we’ll also cover data formats such as points, well known text and geoJSON and discuss how to store and process them from different sources including Snowflake, PostGIS, SQL Server and OneLake.
We will also look at related tools such as mapshaper, QGIS, Mapbox Studio and GeoServer to help you prepare your data, deal with different coordinate systems (such as British National Grid used with Ordnance Survey maps in the UK), and create custom map tiles.
This session will be delivered by MVP, James Dales. James delivered may bespoke map solutions with Power BI through the course of his work, and is the author of the popular Icon Map custom visual for Power BI.