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… I’ll break this down into the following steps: Convert spatial data into geo-coordinate ..read more

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… Radar charts have been around in Qlikview for a long time but I never really made use of them. They fell completely out of my mind after I made the move to Qlik Sense, what with it not being a native chart option. After all, what is a radar chart if not a circular bar chart? At first glance, with a single measurement, radars make it harder to compare the height of lines and bars than conventional line and bar charts. My opinion started to c ..read more

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 ..read more