Spatial Data Analysis in Power BI
From Beautiful Thematic Maps to R-based Models
-
Understand How Power BI Can Help Your Workflow
-
See the Breadth of Spatial Analytics Available in Power BI
Session Agenda
Tony McGovern
Hacker. Artist. Storyteller. Data lover.
- Data Scientist
- emdata.ai
- github.com/tonmcg
- twitter.com/tonmcg
How Power BI Can Help Your Workflow
Simple Spatial Data Workflow in R
How Power BI Can Help Your Workflow
Data Preparation in Power BI
How Can Power BI Help Prepare Your Data?
- Data Connectivity & Ingestion: Access data stored in hundreds of data sources through a clickable interface
- Data Transformation: Apply over 350 different data transformations, preview data, and see history of applied steps, all through the user interface
- Data Query Extensions: Comes with its own highly-intuitive data mashup language that can be customized to help with any data preparation activity
Breadth of Spatial Analytics Available in Power BI
Heatmaps, Clustering, Circles
Custom Boundaries
2016 Presidential Election Results
ML Models in R, Azure, and Power BI
Resources
-
Getting Started with Power Query for Data Preparation
https://powerbi.microsoft.com/en-us/blog/getting-started-with-power-query-part-i/ -
Using R in Power BI
https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-r-scripts-in-power-bi-desktop-part-3/ -
Mapbox Visual in Power BI
https://www.mapbox.com/help/power-bi-choropleth-map/ -
2016 Presidential Election Results
https://github.com/tonmcg/US_County_Level_Election_Results_08-16 -
Socrata Open Data API
https://dev.socrata.com/ -
Rsocrata
https://github.com/Chicago/RSocrata -
ACLU’s What the District?!
https://what-the-district.aclu.org/ -
Build Experiment in Azure Machine Learning Studio
https://docs.microsoft.com/en-us/azure/machine-learning/studio/create-experiment -
Using R in Azure Machine Learning Studio
https://docs.microsoft.com/en-us/azure/machine-learning/studio/r-quickstart