Data Story Telling through Power BI

India’s Covid-19 Cases on the rise- Analysed with PowerBI

The other day I was looking at the India’s Covid-19 cases on the Ministry of Health and Family Welfare’s website which made me think of a way to depict the data in a way which is more interactive and easy to consume. As currently I am working towards advancing my data visualization skills using different Business Intelligence tools, I decided to depict the data by harnessing the visualization capabilities of Power BI.

Govt. of India had imposed lockdown 1.0 in the country on March 24, 2020 (complete lockdown) and now after approximately 1.5 months, the country has moved into lockdown 3.0 (lockdown with some easing) on May 04, 2020.

Developed in Power BI

The first covid-19 case was detected in India on January 30, 2020. The country effectively managed to keep the infection rates low. However, the infection started rising at an exponential rate from the mid March, 2020 and has continued to rise since then. One of the positive news is that the recovery rate of infected patients has also been increasing and as on May 05, 2020 the recovery rate is 27.41% compared to approx. 15% as on April 20, 2020.

The collective efforts of the Governments and citizens have also reduced the growth rate of infection . The infection that was doubling every 6 days as on April 06, 2020 has slowed down to doubling every 10 days as on April 20,2020.

Covid-19 Infection Trend

Another important aspect is that the majority of cases are concentrated in few States/Union Territories with top 7 states constituting 74.94% of the total covid-19 cases. Maharashtra has been affected the worst while three States -Goa, Manipur and Arunachal Pradesh currently have no active positive cases and four States/UTs- Nagaland, Sikkim, Daman and Diu and Lakshadweep have not reported any cases so far.

The daily reported cases in the country after a 41 days lockdown are still increasing and shows an upward trend. The infection chart in Maharashtra, Gujarat and Delhi are also depicting an exponential growth.

Therefore, the extended lockdown 3.0 imposed by the Govt. on May 04, 2020 to control infections in States currently having high infection rate and to prevent spread in States/UTs with low or zero infection cases is the need of the hour.

Disclaimer: As the data on source websites gets updated regularly, few figures may not match.

Data source: Source: Ministry of Health and Family welfare (https://www.mohfw.gov.in/) and ICMR (https://www.icmr.gov.in/)

Data enthusiast. Loves telling stories using data.