James Dales

James Dales is the Global Capability Lead for Power BI at Avanade and is a Microsoft FastTrack Recognised Solution Architect. As a Microsoft Data Platform MVP he is the co-leader of the London Power BI user group. In 2019 he became the first member of the Power BI Contributors Program, working alongside the Microsoft engineering team to build new functionality into the product itself. He has a keen interest in spatial analytics and is the author of the Icon Map custom visual.

James Dales's Sessions

Take an aerial view of your data with a deep dive into spatial analytics in Power BISQLBits 2024

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.

Scanning the skies above SQLBits - Realtime streaming of flight data with Microsoft FabricSQLBits 2024

Using the real-time analytics capabilities of Microsoft Fabric we'll stream aircraft transponder data via a Raspberry PI and antenna into Microsoft Fabric. Through an end-to-end demo, we'll use Eventstream and KQL database to ingest the current locations of 100s of aircraft as they fly above the SQLBits venue. We'll then display and analyse these aircraft in Power BI, and use KQL DB's powerful spatial functions to determine the which parts of the area experience the most amount of air traffic.

Power BI Map Magic - Make amazing maps with Power BISQLBits 2022

Liven up your Power BI reports with spatial analytics. Which visuals fit best for different map types with a deep dive of more advanced mapping themes.