COVID-19 Situation in Sri Lanka: Real-time Dashboard using Power BI

[Updated on March 28, 2020]

COVID-19 is a new strain that was discovered in late December, 2019 and by now it has been started to spread all over the world including 199 countries. There are around 26,000 people were died due to the virus and 580,000 confirmed cases at the moment I update this blog post. Though, the fatality rate is lower when compared to other viruses in similar strains like MERS and SARS. However, the biggest challenge most of the countries facing right now is to accommodate the patients with the growing numbers at every minute.


The public was asked by the government to avoid nonessential gatherings as much as possible to stop spreading this deadly virus. Even though there were not many cases found in Sri Lanka, from March first week, they found the initial case a patient who works as a tourist. Now the situation is turning to worst after they found many cases especially tourists who are born Sri Lankans came down from Italy and European countries. The government taking many actions to prevent spreading this deadly virus and as an instance, any person who came from abroad has to go with a quarantine procedure in order to mitigate this situation. 

Sri Lankan government also took a step further to avoid curb fake news that causes unnecessary panic among the community, by introducing API to distribute accurate and official info to the public as a proactive measure. Accessing accurate information is vital for decision-makers and for the public.

Just out of curiosity, I created a simple Power BI report using the API. In order to make this data more sensible, I had to use some other reliable data sources using the public dataset shared by Johns Hopkins University

You can view this interactive report by click View Report button  


I know that, there are a lot more to improve in this. Specially adding more descriptive analysis, language support, and global stats. I'm planning to continue to do the improvements.

As mentioned in the report I've called multiple sources in order to build this report. There could be slide differences in figures if you compared with when you sitting at the couch comfortably and watching breaking news.  However to ensure the data accuracy and near real-time, I've scheduled the refresh more frequently.

I wish you all be safe and #StayHomeSaveLives 

Comments

  1. “Amazing write-up!”
    SUN International Institute for Technology and Management. To get more details visit
    business management programs in visakhapatnam

    ReplyDelete
  2. “Amazing write-up!”
    SUN International Institute for Technology and Management. To get more details visit
    MBA Institutes in Hyderabad

    ReplyDelete
  3. This is quite charming post you shared, I like the post, an obligation of appreciation is all together for sharing..
    Artificial intelligence course malaysia

    ReplyDelete
  4. "
    Viably, the article is actually the best point on this library related issue. I fit in with your choices and will enthusiastically foresee your next updates.
    "
    360DigiTMG Artificial Intelligence Course in malaysia

    ReplyDelete

Post a Comment