Customer Tracking on Floor Plans With Social Distancing Alerts

When lockdown rules are relaxed it will be interesting to see if shopper’s return in the numbers we saw before the Covid-19 breakout. A large factor in this will be consumer’s confidence in stores to enforce social distancing and therefore retailers will be keen to measure performance in this new KPI. Offices and warehouses may also be thinking along the same lines. With footfall cameras and other IoT feeding data to Qlik Sense it’s possible to build a customer tracker and even an alert system. Here’s how…

Continue reading “Customer Tracking on Floor Plans With Social Distancing Alerts”

Geographic Outliers in England’s Covid-19 Data

There are plenty of Covid-19 dashboards out there (which is doing wonders for data literacy) but something caught my interest the other day when I was looking for my hometown of Sunderland in the government’s data.  I was surprised to see the city in its elevated position in the ranked table of cases by upper tier local authority.  The narrative we usually hear is that highly and densely populated regions are worst hit but there was Sunderland, above its larger neighbour, Newcastle.

I decided to scrape the data and then use Qlik’s associative engine to compare it with population data from  For tips on working with geographic data on different administrative regions, KML files and more see the end of this article. 

Continue reading “Geographic Outliers in England’s Covid-19 Data”

Spotify – REST – Qlik

I’ve been itching to do this one ever since I upgraded my Spotify account to premium and started using it on an almost daily basis!  What better data set could you hope for than all your favourite music?

When writing blog posts on Qlik and BI in general it’s often handy to have a data set to hand; to connect to, transform and visualise.  This is why sites with APIs are so useful and the rich variety of sites and companies now offering them makes for a playground of possibilities.  The Spotify API is free and available for anyone with a Spotify account (free, premium or family).  I’ll talk you through how I created my app…

Continue reading “Spotify – REST – Qlik”

Time Slices Preview: Telling Stories with Qlik (Jurassic Park and Championship Manager)

This post is a just a bit of fun using Qlik and contains two videos of apps/movies made I developed in Qlikview and used in my presentation at Edinburgh Qlik Dev Group earlier this week.  The videos are of “moving” data.

Continue reading “Time Slices Preview: Telling Stories with Qlik (Jurassic Park and Championship Manager)”

Woof. Getting the Point Across.

Often it’s easier to get the point across when it’s quicker to get to the point.  That’s why we use charts.  As a visualisation they should draw us to the key trends and figures without having to trawl through rows and columns of data.  However, aren’t they a bit boring?  Can’t we get the point across in a more immediate and engaging way?  So let’s strip away those axes and titles then see what we can do with a data set on pet ownership in the UK which I’ve taken from and stripped down to just the northern regions.  Here’s the raw data:

Continue reading “Woof. Getting the Point Across.”