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