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”
Radar charts are often overlooked when it comes to dashboards and analytics but I’ve recently fallen in love with them again and here’s why you should too…Continue reading “Radar Charts”
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 data.gov.uk. For tips on working with geographic data on different administrative regions, KML files and more see the end of this article.
Qlik Sense June 2018 is now available! I’ve taken a look at some of the new features in the following video:
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…
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.
I’ve finished work for Christmas so I’ll be taking a short break from the blog to eat, drink and be merry with my friends and family. Driving back home from work earlier today Chris Rea’s dulcet tone came floating out of the car speakers with his aptly named song ‘Driving Home for Christmas.’ Continue reading “Driving Home for Christmas”
As a nod to the release of Star Wars Rogue One (and and excuse to try out a dark theme dashboard) I’ve put together a Qlik dashboard with some of the freely available Star Wars stats and data from around the internet.
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 http://www.pfma.org.uk/regional-pet-population-2016 and stripped down to just the northern regions. Here’s the raw data: