1 min read

Oh Data - Discovering insights with OData with Power BI, Excel and Tableau

At Socrata Connect, I had the opportunity to lead a session on loading various datasets from our customers via OData in Tableau, Power BI and Excel.

Power BI

In this demo I join data from the CDC (Centers for Disease Controls) 500 Cities: Local Data for Better Health, with Commute Time for Census Tracts in Los Angeles county and look for relationships via a scatter plot in this Power BI report.

Excel

In this demo, we connect to Austin Code Task List to review Code Cases by Inspector and Status in a pivot table.

Tableau

This demo examines Seattle Terry Stops data on a Tableau Dashboard with a collectio of Tableau visualizations to look for any trends in police stops by Officer and Citizen gender, race and age.