Power BI World Tour 2018 - Seattle

This presentation is aimed at people who want to create beautiful thematic maps, perform impactful spatial data analysis, and explore common spatial machine learning models with Power BI. Much of the content will make use of Power BI's out-of-the-box spatial capabilities through Esri's ArcGIS Maps and the MapBox Visual for Power BI. While I use data from the United States Census Bureau's rich, fully-featured API to illustrate what can be done with these custom visualizations, what you'll learn can also be reproduced using similar non-U.S. spatial data.
You'll also be introduced to PowerCensus, a series of custom Power Query M functions that allow you to easily clean, convert, and supplement your location data into robust spatial data for powerful analysis. PowerCensus also contains a custom Power Query M connector where you can download and explore the U.S. Census API, which contains over 200 endpoints that holds hundreds of thousands of rows of U.S. poverty, international trade, demographic, and business data.
I'll also highlight some commonly used spatial machine learning models you can integrate with Power BI using the popular statistical programming language, R. From clustering algorithms to hotspot analysis, R in Power BI allows us to deliver better and more rigorous insight from our spatial data.
If you're accustomed to mapping data in Power BI and want to be able to perform advanced spatial analysis and visualize more beautiful maps, this is the session for you.