Qlik Community

COVID-19

Let's bring together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2. All are welcome to share insights and sources of factual data.

Luminary
Luminary

Coronavirus COVID-19 | Qlik Community Response

qlik_community_covid19.png

Updated: 30 March 2020

The main topic group on Qlik Community is here: https://community.qlik.com/t5/COVID-19/gp-p/covid-19-group

This post is to bring together people and resources in response to the global outbreak of Coronavirus, aka COVID-19, aka SARS-CoV-2. You'll find Qlik Sense screenshots and some live apps below.

I encourage people in the Qlik Community to share their insights using the data, without personal opinions as much as possible. There is enough hysteria in the news and this post isn't about that. It's more about what the data might tell us through visualizations and dashboards, and how they could inform decision-makers, policy-makers, healthcare professionals, patients and their families, and the general public.

InformationWeek had a good article on how analytics can help fight the virus: https://www.informationweek.com/big-data/big-data-analytics/fighting-the-coronavirus-with-analytics-...

Posts/contributions from Qlik Community members:

  1. Marco Zampieri - Qlik Luminary - datasynapsi: http://covid19.dasycloud.com/
  2. Ivan Bozov - Qlik Luminary: https://twitter.com/MrBozov/status/1233040571192795143?s=20   
  3. Alvaro Palacios Morales - Qlik: https://www.linkedin.com/posts/alvaropalacios_qlik-analytics-embeddedanalytics-activity-664053729196... 
  4. Ralph Graham - Neueda: https://www.linkedin.com/posts/ralphgraham85_coronavirus-neueda-qlik-activity-6637707968898977792-XW... , https://www.linkedin.com/posts/ralphgraham85_qlik-coronavirusoutbreak-activity-6630574166602981376-B... 
  5. Thiru Balaji G - Cognizant: https://www.linkedin.com/posts/thiru-balaji-g-0211_dataanalytics-visualization-qliksense-activity-66... 
  6. Jordy Wegman - Climber: https://www.linkedin.com/posts/jordywegman_businessintelligence-bi-qlik-activity-6628537141343461376... 
  7. Per Malmlov - Drake Analytics: https://www.linkedin.com/posts/malmlov_coronavirus-coronaoutbreak-qlik-activity-6630203386639773697-... 
  8. Wederson Cabral Domingues - SOEVA Consulting: https://www.linkedin.com/posts/wederson-cabral-domingues-9b944714b_qliksense-coronavaedus-soeva-acti... 
  9. Ofir Wienerman- Qlik Israel: https://qlikisrael.qlikil.net/sense/app/e173449f-fbef-4d41-bed4-213404738cd6/sheet/df98a2fd-2869-45b... 
  10. Lucke Hallbergson - Qlik: https://www.linkedin.com/pulse/simple-qlik-sense-application-visualizing-jhu-csse-data-hallbergson?l...
  11. Angel Das - Novartis: https://towardsdatascience.com/why-quality-sense-checks-are-so-important-in-data-science-7ef80da760c...
  12. Luis Felipe Tensini -Bilden Inteligência em Negócios: https://www.linkedin.com/posts/tensini_qlik-coronavirus-activity-6641432639720955904-XheW/
  13. Alberto Vaghi - Qlik: https://www.linkedin.com/posts/albertovaghi_qliksense-data-businessintelligence-activity-66441833459...
  14. Rob O'Neill - NHS: in-hospital patient-zero potential contamination app. Covers ED, Radiology, OP, IP and Ward Attenders. Very happy to share if anyone interested - would probably slot on top of most DXC Lorenzo EMRs. https://www.linkedin.com/feed/update/urn:li:ugcPost:6641122038125772801?commentUrn=urn%3Ali%3Acommen...
  15. Tmeacham - https://community.qlik.com/t5/New-to-Qlik-Sense/Coronavirus-COVID-19-Qlik-Community-Response/m-p/168...
  16. Ramajola - https://community.qlik.com/t5/New-to-Qlik-Sense/Coronavirus-COVID-19-Qlik-Community-Response/m-p/168...
  17. Copley - https://www.linkedin.com/posts/copley-consulting-group_copleys-covid-19-walkthrough-with-qlik-activi...
  18. Giorgio Dossena - Qlik -  Italy - https://www.linkedin.com/posts/albertovaghi_qliksense-data-businessintelligence-activity-66441833459... 
  19. Tanveer Pratap - GINQO - BC Canada - https://www.linkedin.com/posts/tanveerpratap_lets-hope-this-curve-tapers-off-in-bc-you-activity-6646...

Marco's appMarco's app

Ivan's appIvan's app

Alvaro's appAlvaro's app

Ralph's appRalph's app

Thiru's appThiru's app

Jordy's appJordy's app

Per's appPer's app

Wederson's appWederson's app

Lucke's appLucke's app

Angel's appAngel's app

Luis's appLuis's app

Alberto's appAlberto's app

Rob's app for Patient TrackingRob's app for Patient Tracking

 

Giorgio's appGiorgio's app

Tanveer's appTanveer's app

Sources of data:

 

Visualizing and mapping the pandemic responsibly: 

Johns Hopkins CSSE DashboardJohns Hopkins CSSE Dashboard

Have you created something around the data?

Please comment and share! I'll keep adding stuff as I find it. Stay tuned!

Tags (1)
22 Replies
Highlighted

Re: Coronavirus COVID-19 | Qlik Community Response

This is my app.
Without selections;

cov19.png

 

And with Hubei excluded to show the difference (since it carries such weight compared to all other locations);cov19-except-Hubei.png

Update: Looking specifically at China and excluding Hubei, the number of reported active cases are really low so either the spread has been capped or the reporting is off track. Or does Hubei show what happens when the spread of the virus get out of hand and the number of affected people become so many that the health care system gets overwhelmed and can no longer treat the most affected?
cov19-except-Hubei0305.png

Highlighted
Luminary
Luminary

Re: Coronavirus COVID-19 | Qlik Community Response

@Lucke_Hallbergson - nice work! I like the color-coded information. Very clean. Are you sharing this app anywhere publicly? If not, would you mind sharing the QVF and I could host it for you?

Highlighted
Luminary
Luminary

Re: Coronavirus COVID-19 | Qlik Community Response

This time I left the dashboard building to others and focused on getting latest summarised data extracts on a schedule to drive these dashboard. Here is my contribution - https://kabonline.net/2020/03/06/coronavirus-outbreak-data-feed/

Kabir
Please do not forget to the mark the post if you find it useful or provides you the solutions 🙂
Highlighted
Visitor

Re: Coronavirus COVID-19 | Qlik Community Response

76569162-d6c84380-6488-11ea-900b-2ae4d22aeb06[1].png

Highlighted
New Contributor II

Re: Coronavirus COVID-19 | Qlik Community Response

Capture1.PNGCapture2.PNG

Highlighted
New Contributor

Re: Coronavirus COVID-19 | Qlik Community Response

Great post, amazing information here!

Has anyone seen data that gets a bit more granular for U.S.?  Wondering if anyone has seen data with county or zip code?  Looking to get insight into which regions of each US state are being impacted the most.

Highlighted
Partner
Partner

Re: Coronavirus COVID-19 | Qlik Community Response

This is a video of our Dashboard (visible only on our tenant at the moment) https://share.vidyard.com/watch/NCvXn4qg73fTU1eUgvRiEx? 

FM

Nevis

 

 

Highlighted
Employee
Employee

Re: Coronavirus COVID-19 | Qlik Community Response

Johns Hopkins CSSE was collecting county level statistics in the US, but after 2020-03-10 they stopped because it was too much to maintain as the impact spread. Additionally there were issues with double counting, etc. 

Highlighted
Luminary
Luminary

Re: Coronavirus COVID-19 | Qlik Community Response

Updated the article with more examples and some great blog posts on visualizing/mapping the coronavirus data, responsibly. Thanks to Kenneth Field from ESRI, Amanda Makulec from Data Visualization Society, and Megan Danielson & Marena Brinkhurst from Mapbox for the content!