Business Intelligence Solution for Covid-19 Pandemic

The COVID-19 pandemic, first detected in December 2019, spread drastically globally within a short period. Such a pandemic has caused enormous loss of lives and health complications and adversely affected the world economies. Effective tracking of the spread of the disease around the globe and predicting when the next wave will occur has become critical in measures geared towards mitigating COVID-19. This paper explores different ways of utilizing analytics and business intelligence tools and solutions to understand the spread of COVID-19 around the globe and predict the number of new COVID-19 cases likely to be recorded. Microsoft Power BI is used to visualize COVID-19 data simply and intuitively in different ways for health decision-makers and concerned parties to easily understand the spread of COVID-19 through various visualizations and dashboards. We also utilize predictive analytics capabilities in Microsoft Power BI to predict the number of COVID-19 cases likely to be recorded in the next few months. The obtained results showed that COVID-19 cases increased over time, particularly in crowded countries. In addition, the results proved that the death rate is reducing with time even though the cases number is increasing.