Working with JSON data in Power BI Desktop’s query tab

I’m helping some journalists get up to speed with Power BI and walking them through how to load common data sets into Power BI Desktop.  A recurring topic of interest is how to load government data, including unemployment rate. Here’s a report I created to show what you can make with Power BI, click through to…

1

Visualizing City of Chicago owned properties with Power BI Designer

Update 8.9.2015: Title updated with new product name   The week after next, I’ll be in Chicago to present at Microsoft’s Ignite conference.  I thought it would be fun to look at some data for the City of Chicago to see what I could do with it.   Revenue is important to any city.  Developing…

0

Power BI Dynamic Date Filtering

One question I get from time to time is how to filter to the last week’s worth of data automatically in Power BI.  You might want the last 7 days, this week, this month, etc.  You can make it fully dynamic by combining the technique Matt Masson describes here to create a date table and add…

2

Seattle Building Permits visualized in Power BI with Socrata OData and data.seattle.gov

  Living in Seattle, it’s quite fun to keep track of what’s happening through data.  The Open Data initiative from the City of Seattle is a treasure trove of information that you can explore here: http://data.seattle.gov.  This is all power by Socrata, as are many other open data initiatives for Cities and organizations.  I wanted…

1