GitHub Public Repository Statistics

GitHub Public Repository Statistics

The Data The data is obtained through GitHub's Rest API using bearer tokens.  GitHub's API has strict rate limits when not using authorisation credentials of some sort. A few of the paginated calls would not be possible on the larger repositories without using...

read more
Custom Icons and Conditional Formatting Measures

Custom Icons and Conditional Formatting Measures

Custom Icons You can add custom icons to any table or matrix visual in Power BI in a few easy steps.  First we need to edit the JSON theme. Open the JSON theme file with some form of text editor like Notepad++ and add code like the example here:{ "name": "Custom...

read more
Monthly Sales Dashboard

Monthly Sales Dashboard

The Data Twelve months' worth of demo sales data over 2 years. Bit of data cleaning required. With only 12 months of data, I decided to do a monthly sales dashboard. I had seen widgets on a demo dashboard not built with Power BI and I wanted to see what it would take...

read more
UK Police & Crime Dashboard

UK Police & Crime Dashboard

The Data I decided I would like to create some reports based on data provided by Data.Police.UK There are many ways to obtain data from this site including CSV archives and API calls. For this project I just selected the full date range data dump option of three...

read more