Building a COVID-19 Dashboard with Tableau

Data visualization is about telling a story with data.

Tableau is easily one of the most common and widely used data visualization platform in the fields of business intelligence, marketing, and much more. The great thing about Tableau is that it does not require technical or programming skills and it allows easy sharing of visualizations made with it.

Image for post

One of the most relevant and sobering topics to visualize is the ongoing COVID-19 pandemic. I decided to use public data sources to visualize the impact of COVID on the U.S at the state level.

Here’s how I did it.

The Data

Data is being collected from the local and city levels up a national scale. John Hopkins, the Center for Disease Control and Prevention (CDC), and even the New York Times all have collected data to track confirmed cases and fatalities. Some of the data is even live!

First I downloaded a spreadsheet of case counts. I chose to source my data from the New York Times’ GitHub account
I then added the CSV as a data source by navigating to the add button from the Connections link on the left (Connections -> Add)
I also downloaded and added a CSV of the 2 letter abbreviations of states. (Connections -> Add)
I joined the data by clicking on the Venn Diagram **(Join -> Inner) **and choosing an Inner Join to keep only states in both datasets

#dashboard #covid19 #business-intelligence #tableau #data-visualization #data visualization

What is GEEK

Buddha Community

Building a COVID-19 Dashboard with Tableau

Next.JS Developer

1620127560

Data Scientist Creates Python Script To Track Available Slots For Covid Vaccinations

Bhavesh Bhatt, Data Scientist from Fractal Analytics posted that he has created a Python script that checks the available slots for Covid-19 vaccination centres from CoWIN API in India. He has also shared the GitHub link to the script.

The YouTube content creator posted, “Tracking available slots for Covid-19 Vaccination Centers in India on the CoWIN website can be a bit strenuous.” “I have created a Python script which checks the available slots for Covid-19 vaccination centres from CoWIN API in India. I also plan to add features in this script of booking a slot using the API directly,” he added.

We asked Bhatt how did the idea come to fruition, he said, “Registration for Covid vaccines for those above 18 started on 28th of April. When I was going through the CoWIN website – https://www.cowin.gov.in/home, I found it hard to navigate and find empty slots across different pin codes near my residence. On the site itself, I discovered public APIs shared by the government [https://apisetu.gov.in/public/marketplace/api/cowin] so I decided to play around with it and that’s how I came up with the script.”

Talking about the Python script, Bhatt mentioned that he used just 2 simple python libraries to create the Python script, which is datetime and requests. The first part of the code helps the end-user to discover a unique district_id. “Once he has the district_id, he has to input the data range for which he wants to check availability which is where the 2nd part of the script comes in handy,” Bhatt added.

#news #covid centre #covid news #covid news india #covid python #covid tracing #covid tracker #covid vaccine #covid-19 news #data scientist #python #python script

Aketch Rachel

1618099140

How Is TCS Helping With COVID-19 Testing In India

COVID-19 cases have only been on the rise. With the non-availability of effective drugs and vaccines, one of the effective ways to control it is to detect it early in patients. However, the task is easier said than done. While a large number of test kits are being produced, they are not enough to conduct testing in large numbers.

Government-run body, C-CAMP or Centre for Cellular and Molecular Platform, has been a key enabler in driving COVID-19 testing as it has been aggressively building, managing and scaling the ecosystem of MSMEs to produce test kits indigenously. However, they might not be enough.

#opinions #c-camp #c-camp tcs #covid-19 #covid-19 testing #tcs #tcs covid-19

Abigail Cassin

1596574500

How The New AI Model For Rapid COVID-19 Screening Works?

With the current pandemic spreading like wildfire, the requirement for a faster diagnosis can not be more critical than now. As a matter of fact, the traditional real-time polymerase chain reaction testing (RT-PCR) using the nose and throat swab has not only been termed to have limited sensitivity but also time-consuming for operational reasons. Thus, to expedite the process of COVID-19 diagnosis, researchers from the University of Oxford developed two early-detection AI models leveraging the routine data collected from clinical reports.

In a recent paper, the Oxford researchers revealed the two AI models and highlighted its effectiveness in screening the virus in patients coming for checkups to the hospital — for an emergency checkup or for admitting in the hospital. To validate these real-time prediction models, researchers used primary clinical data, including lab tests of the patients, their vital signs and their blood reports.

Led by a team of doctors — including Dr Andrew Soltan, an NIHR Academic Clinical Fellow at the John Radcliffe Hospital, Professor David Clifton from Oxford’s Institute of Biomedical Engineering, and Professor David Eyre from the Oxford Big Data Institute — the research initiated with developing ML algorithms trained on COVID-19 data and pre-COVID-19 controls to identify the differences. The study has been aimed to determine the level of risk a patient can have to have COVID-19.

#opinions #covid screening #covid-19 news #covid-19 screening test #detecting covid

Nat Kutch

1597465740