Mapping UK Highways Agency traffic data in PowerBI Desktop

I downloaded the May 2017 version of PowerBI desktop to load in some of the traffic data that I dropped into Qlik Sense and Tableau in a previous post.

 

The finished article first

 

So – back to getting started. This is my first time using the software, and it’a pleasant experience right up until I try to load an .xls file.

 

A missing driver? Already?

Continue reading “Mapping UK Highways Agency traffic data in PowerBI Desktop”

Viewing Department for Transport vehicle statistics by make in Qlik Sense

Generally, getting access to vehicle data is a pay-for-data experience – but snapshots are released each year to the public.

If you head to the Vehicle Statistics page on gov.uk you get statistics about vehicle licencing, excise duty evasion, vehicle roadworthiness testing and more. You’ll probably want to check out the index as there’s 76 files in the 2016 download alone, at various levels of granularity…

The one I’m going to look at today though, is:

Licensed Cars, Motorcycles, Light Goods Vehicles, Heavy Goods Vehicles, Buses and Other vehicles by make and model, Great Britain, annually from 1994, quarterly from 2008 Quarter 3 ; also United Kingdom from 2014 Quarter 4

AKA table VEH0120. Interestingly, Qlik Sense throws an “Unknown Error” message when trying to load “.ods” files so I converted it to Excel prior to loading.

Continue reading “Viewing Department for Transport vehicle statistics by make in Qlik Sense”