Building a Dashboard For The Coronavirus In Singapore

Using Tableau to display confirmed cases of Coronavirus in Singapore

Confirmed Cases In Singapore

As the Coronavirus outbreak from Wuhan spreads globally, almost everyone in Singapore has been following the news regarding this virus.

From a data perspective, i realized that there wasn’t much visibility on the spread and growth of the virus outbreak in Singapore. After googling for some time, i decided to create my own dashboard.

Map of the places visited by coronavirus cases in Singapore

Details regarding these cases

Statistics and details regarding these cases

Here’s the entire dashboard

For those who are keen on how i gather and built my own dashboard to track the Coronavirus outbreak in Singapore, please refer to the next section.

How to get started?

Tools used to build the dashboard

1. Collection of data

My main source of data is from the Ministry of Health’s press release. Currently, i perform a manual extraction of data based on the details provided by the press release. Do let me know if you have a way to perform an automated extraction from the site. An example of the fields required to build the dashboard is shown below.

╔═════════════╦═══════════╦═════════════╗══════════════════════╗
║ Case No ║ Gender ║ Nationality ║ Places Visited ║
╠═════════════╬═══════════╬═════════════╣══════════════════════╣
║ Case 2 ║ Female ║ Chinese ║ J8 Hotel ║
║ Case 2 ║ Female ║ Chinese ║ Orchard Road ║
║ Case 2 ║ Female ║ Chinese ║ Marina Bay Sands ║
║ Case 2 ║ Female ║ Chinese ║ Gardens by the bay ║
╚═════════════╩═══════════╩═════════════╝══════════════════════╝

2. Getting the exact locations

After getting the places visited by these cases, the next logical step would be extracting the latitude and longitude of these locations. My favourite tool for performing this step is using the Geo-coding API from Google Maps API.

Example of how the Geo-coding API works

https://maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,
+Mountain+View,+CA&key=YOUR_API_KEY

The latitude and longitude will be among the JSON response returned.

"formatted_address" : "1600 Amphitheatre Parkway, Mountain View, CA 94043, USA",
"geometry" : {
"location" : {
"lat" : 37.4224764,
"lng" : -122.0842499
},

Google’s documentation on this API is fantastic and easy to understand so i will not dwell further on this.

3. Putting it together

Now, here’s the fun part where you can choose the design and layout of the data! Eventually, i selected the dark mode version for the map as it was the best option to display all these cases in Singapore.

Different variations of maps

Tip: Use labels and annotations to highlight key insights

That’s all! Feel free to reach out to me on LinkedIn or comment on this post if you have any questions. Will try to improve the dashboard when i have more time.

I write about new tech that i’ve been exploring recently. I believe in working hard, being kind and trust that amazing things will happen.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store