New York Public Library Digital Collection in Power BI

Some time ago I saw news that the New York Public Library has published its digital collection on its website and as a dataset you could download and explore. So I downloaded it and started to play with it. But as fate had it, I didn’t finish the project. The week before last, I was in…

4

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

Basic DAX filtering with CALCULATE and ALL functions

Recently I helped a few reporters get their first taste of building reports using Power BI. Power BI provides sophisticated filters and expressions that help you get the most of your data. In this post I’ll focus a little on the expressions you can use to create custom calculations in Power BI. The expressions are defined in a…

1

#VisualizeChange – Comments in Words

Recently a retweet from @olivier_matrat  came through my twitter feed and it struck a chord. It was the #VisualizeChange  challenge part of this year’s World Humanitarian Summit.  Submissions are due 8/31, so there’s still time for folks to work on it. Not sure if I’ll actually enter into the contest, but I did do enough work on it…

0

Visualizing London’s open data in Power BI

Today we’re visiting London, UK.  In previous posts, I’ve looked at data from Seattle and Chicago.  Now we’re headed across the pond to see data from the UK.  Specifically, the Greater London Authority has a myriad of data available at London Datastore.  The datasets are generally covered by the UK Open Government Licence (OGL) but some have…

0

Finding the Latest Date in Power BI Desktop

One common question I get is how to do date filtering in Power BI.  In a previous post, I showed how to make filters that show if a values occurred in the last 30 days, in the last month, in the last 12 months, or in the current year.  This post show how to show…

2

Don’t miss out – See Power BI in action at the Ignite Expo Hall

  Folks, Spread the word.  Dawn, our amazing event coordinator, has put together an ‘A’ list of quick demos to help you get up to speed on Power BI.  Here’s the list of presenters so far.  Please tweet, share, repeat, tell your friends, and be sure to stop by to see these great sessions.   …

0

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