Playing with Microsoft Power BI and Vermont's Open Geodata

VCGI has begun to explore the possibilities of Power BI, Microsoft's "business intelligence" data modeling and visualization tool.

In this simple example, VCGI downloaded the location of Vermont owned or leased buildings from the VT Open Geodata Portal.  The option to download in "spreadsheet" format was chosen, which provided a CSV file.  The CSV file was pulled into Power BI Desktop and used to create the donut chart and map shown below.

The chart depicts the number of buildings owned and/or leased by specific State of Vermont agencies or departments.  Clicking on one of the sections on the donut chart will "filter" the map to the towns where particular agencies/departments have buildings.

We are just getting our feet wet.  We anticpate doing more as we explore the potential of business intelligence tools to enhance data visualization, data exploration, and data-driven decision making.

P.S. Want to learn more about how the State of Vermont is leveraging tools to extract buisiness intelligence?  Check this out!
Webinar: Business Intelligence Tools for GIS, July 26
Presented by Erik Engstrom, VT Agency of Natural Resources. This webinar will provide an overview on how ANR is using Business Intelligence tools such as Microsoft Power BI and ESRI Operations Dashboard to create meaningful visuals of data for reporting and decision making.