Covid-19: Qlik Dashboard & Solution Collection

I've been working with the Covid-19 data for close to two months now, and I like to share some of the assets we've put together here at Qlik. I've curated my own collection of some of the best apps that Qlik has to offer to glean different views on the progression, spread, and hopefully eventually containment of the coronavirus.

First - the links to the apps can be found here: https://pe.qlik.com/extensions/Covid/Covid.html

This is a NodeJS site running inside of Qlik Sense (how cool is that?) that points to different systems with relevant data.

The biggest problem I've found is that the data (to be nice) started as a terribly unorganized, poorly documented mess of sources. What was great was that thanks to the power of the Qlik Associative Engine - I was able to stack and combine the data at different levels of granularity, with multi fact tables, and different refresh timelines into a single conformed application. The was well before John Hopkins and other started putting out their data (which was pretty bad at first too)...

I've collected my initial work here: https://github.com/dlfreriks/Covid19-Data-Research

What I've put together is just one small stream in a river of people working together to try and turn data into information for the collective good - and that had been just awesome to see. Even "competitor" companies are pooling data together to try and help each other in these strange times.

Our team here at Qlik has been working with our great technology partners to do the same level of cooperative building. Narrative Science, Vizlib, Snowflake, Databricks, Measur.io, are just a few of the companies we've been co-developing solution with to provide unique insights into the progression of the virus.

Every morning I publish on Facebook and LinkedIn my little contribution to the fight... An ARIMA forecast of projected growth of confirmed cases and deaths. I am using the Advanced Analytics Toolbox extension (https://github.com/mhamano/advanced-analytics-toolbox) along with our Server Side Extension plugin for R (https://github.com/qlik-oss/sse-r-plugin). These tools allow anonymous users through a public facing Qlik Sense site to interact with the power of a R engine to run these forecasts (no desktop or download required).

In this weird time, it's been great to see the humanity of the analytics community working together in the common language of data to try and do our part in this fight. We aren't the heroes the front line responders are, but hopefully the information we collect and curate can help in some small way...

Dave Freriks, Technology Evangelist - Qlik