Improvise the below doc

Data Acquisition, Examination, and Transformation

Data acquisition and extraction refers to the process of gaining access to data that is related to Covid-19 standings across the world. This will involve the generation of fresh data or through acquiring data via websites as it will be done in the context of this paper. In the extraction stage, data that have been acquired will be converted from its source format, which can be utilized in further processing as well as analysis. This mainly entails loading the data into a spreadsheet which will make it easier for analysis (Fetzer et al. 2020).

a) Collect the dataset you are planning to use within your project.

As per the world reporting on the rates of infections and the deaths resulting from coronavirus, as at July 30, 2020, the total number of confirmed corona virus-positive infections were at 17, 005,983 with total conformed death cases being 666,857 globally. In the United States alone, the number of infections is approximately 4,472,963, with the number of deaths being 151,570. This makes the United States be the leading country with the highest infection rates as well as deaths in the world. The following tabulations show the number of coronaviruses confirmed cases in five countries per continent reporting the highest cases on a cumulative basis from December 31, 2019, to July 30, 2020.

The Number of Deaths Which Have Been Reported From Every Continent

The tabulation below indicates the statistics of the number of deaths per continent from five countries reporting the highest death rates.

The Number of Infections Reported in the Last 14 Days

In the tabulation below, it shows the number of infections from every five countries recording the highest infection rates for the last 14 days.

The tabulation below summarizes the global reported total number of infections, the total number of deaths, as well as the reported cases in the last 14 days.

Data Examination

From the above data, there is a lot that can be learnt through it. For instance, from the trend of the data, it's clear that the rate of infections as well as deaths is surging in the America continent, followed by Asia, Europe, Africa and finally Ocean continents respectively. The rate of infections can also be determined from the number of cases reported in the last 14 days. These data is very much reliable since it comes from the world health organization (WHO) website. The data was approximated from the daily updates from various governments’ statistics after conducting testing according to the guidelines issued by the world health organization. The data is making sense concerning the way the coronavirus pandemic spreads and the factors facilitating the spread of the same (Fetzer et al. 2020).

These data is useful for three main reasons according to the trends of infections as well as deaths that are resulting from the pandemic. First, this data can give an insight into the spread of the virus can significantly assist the leaders to respond more effectively to the epidemic. Secondly, the new technologies that are making use of data to fight COVID-19 must have to comply with the privacy regulations. Finally, the coronavirus data is essential for it helps the relevant authorities to identify the most vulnerable communities more, especially during these hard times in terms of economy. To create interactivity design, Microsoft Excel software will be utilized to come up with a visual chart that will be used to give a clear trend of the global standings in the infections, deaths as well as the recent infections. These will help the leaders as well as the health ministries to enact laws and guidelines that will help in shaping the world in the coming days (Kannan, et al. 2020).

I'm proposing that this data should be presented via PowerPoint slides. This will be an effective technique of presenting this data as well as the interactive design that will be generated from this data. A visual impression on the real situation which can be used to trigger the leaders to act at a faster rate in coming up with policies that are aimed at curbing the spread of the virus. I also propose to use the pie-chart and area-charts as my interactive solutions while designing this data into something visual. With this, the right image will come out as to whether are the citizens of various nations in the world live in a comfortable life as they used to live before the coronavirus pandemic or not. This will mainly give a solution to what is supposed to be followed or given priority in curbing the pandemic and enhance the lives of the citizens back to normal (Meo et al. 2020).

Interactive Solution

One of the challenges encountered while creating the above interactive solutions is the representation of the actual percentage of (Other) as a variable in the visual representation. As can be seen from the visual representations, the (Other) variable is denoted by zero percentage value even though it has a value which has an impact on the result. On life, the challenge will be avoided by using the actual values and not percentages (Petropoulos, & Makridakis, 2020).

Proposed Dynamic Solution

The dynamic change of solution as the data changes can be enhanced by embedding the data with excel program. This enables the interactivity design solution to change as the data increase automatically or decreases depending on the trend in the coronavirus infection rates, death rates as well as the cases of infections reported within the last 14 days (Strzelecki, 2020).

References: