The interactive Power BI report follows the short narrative

The world reached a definitive milestone with the COVID-19 scourge. The cataclysmic change from the novel coronavirus pandemic tested the resilience and leadership disposition of all nations; many, including developed countries/regions, discovered with dismay the inadequacy of their medical emergency response systems. Some, more than others, had been able to interpret the data emerging from the virus infection and use the knowledge to halt its rapid spread. Those slow to react experienced higher rates of infection and mortality among the people. Influence of Data had never been more evident than during the coronavirus pandemic, proving that the success of every venture, social or economic, must not only be anchored on well-thought-out plans but must rely on reliable information derived from sufficient and proficient data.

Several global, regional and national reports on the corona pandemic are available on the internet, but only a few had paid more than passing attention to Africa. The following report aims to provide basic insights into the COVID-19 impact on the African continent. The data for the nCoV19 Pandemic Report–Focus on Africa was sourced from the GitHub repository as curated and made available by the Johns Hopkins University Centre for Systems Science & Engineering. Other sources include the Nigeria Centre for Disease Control and the National Bureau of Statistics. Refer to the INFORMATION page in the Report for more details.

To give the reader distinct and relatable information on the impact of COVID-19 on nations, the report has been scaled into Global, African, Regional and Nigerian sub-reports. The two pages at the end of the report are comprehensive details of the COVID-19 data presented in tabular form.

April 6th, 2020 was selected to benchmark analysis in this report. It marks the midpoint between 22nd Jan 2020, the date data on the pandemic was made publicly available, and the date this article was published. On this day, every country/region had come to the full realization of the existential threat of COVID-19; the only continent with no recorded case was Antarctica which has no indigenous inhabitants.

The reader would have an immediate appreciation of the growth of the pandemic by comparing data of different periods that can be selected on the live and interactive Power BI report at the bottom of this post. The following briefs would explain some of the basic insights that the report offers.

Global Pandemic Report

The Global Report page tracks the continental aggregations of reported cases and provides context to the sub-reports. Table 1.1 shows the distribution of confirmed cases among the six populated continents as of 6th April 2020, while Table 1.2 shows the impact per a population of one million.

Table 1.1 – COVID-19 Impact Status on 6th April, 2020
Table 1.2 Confirmed Cases per I Million Population on 6th April, 2020

It is instructive that, 60% of the world population of 7.4 billion is in Asia, the epicentre of the pandemic, which accounted only for 17.70% of the global confirmed cases as of 6th April 2020. Africa, the 2nd in population, recorded the second least number of cases after Oceania, the least populated of the six inhabited continents. Europe, accounting for 10% of the world population, recorded the highest number of cases at 652,327.

By 14th June 2020, the COVID19 global map had been reshaped. Table 1.3 is a summary, showing an increase of 497.90% over the April 6th recorded numbers. North America recorded the highest number of deaths, least recovery rate but second highest mortality rate.

Table 1.3 COVID-19 Impact Status on 14th June, 2020

Africa Pandemic Report

According to Wikipedia   Africa is home to an estimated 1.2 billion people, representing 16 % of the global total. Regardless of the political disputes, Africa comprises 55 countries in 5 geographical regions as indicated in Table 2.1

Table 2.1 Population of Africa

Summary of the impact of the pandemic by April 6th is contained in Table 2.2 below, while Table 2.3 shows the pandemic update on 14th June 2020, which displays a sharp contrast.

Regional Highlight

There are two significant insights the Africa Report has revealed pertaining to the East and Central African regions. First, Central Africa, comprising nine countries, which was once the epicentre of the Ebola pandemic, recorded the second-lowest count of confirmed cases as of 6th April 2020. However, in relative terms to both the population and the number of the confirmed cases, suffered the highest COVID-19 mortality rate on the continent. The inverse relationship between fatality and recovery rates means the region had the lowest rate of recovery from the infectious disease, as well.  

The North African region, comprising seven countries, had the highest number of confirmed cases and fatality rate in comparative terms. Factors such as proximity to Europe, particularly Italy, and sharing similar climatic conditions, could have influenced the rapid spread of the virus to the Arab nations.

The second highlight is a perspective on Madagascar, one of the 18 countries in East African. Often described as geologically a sub-continent, ethnographically South-East Asian, it is geographically the fourth largest island in the world located on the southeast coast of African. Madagascar had 304 confirmed cases, 114 were recovered, 190 undergoing treatment and ZERO death by 17th May 2020.

The President of Madagascar had claimed and, indeed, staked his reputation on the efficacy of a herbal solution he had manufactured as a cure for the coronavirus infection. There was a public launch of the product that he later made a generous allocation of to several African nations.

The discovery was greeted with enthusiasm in Africa but with the expected scepticism around the globe, including a call for caution from the World Health Organization (WHO). However, the recent pronouncement by WHO that where a system of medicinal practice had persevered for over 200 years amongst any society that system should stand recognized. This is a welcome development coming on the heels of several tested claims of the potency of African organic medications.

When Africa unites to establish a continental body, Africa Health Organization, for instance, for the study and research into African medicines, results that could delight both investors and political leaders would likely be achieved. The main challenge, however, would be how to negotiate the monolithic corporations controlling the global pharmaceutical industry.

Senegal was another African success story, proving again the resilience and resourcefulness of the African community when faced with an existential threat. This West African nation of 17 million people established one of the most successful systems of administration and management of the COVID-19 pandemic in the world. It brought down the cost of a single unit of test kit from $61 to just $1 and produced all the ventilators it required at just $60/unit as against the global price of $16,000. The story is available here.

The sudden increase in the spread of the coronavirus in the Southern African region should alarm the African Union. With only 5 nations, the region has the least number of nations and the lowest aggregate population as well. However, the region has recorded a jump of over 4000% rate of growth in COVID-19 confirmed cases per population of 1 million against the regional average of 2000%. Table 2.3 below compares the position between the April 6th and June 14th, 2020.

Table 2.4 Growth of Confirmed Cases per I Million Population

West Africa Pandemic Report

With an aggregate population of 340 million, the West African Region comprises 16 nations that make up the Economic Community of West African States (ECOWAS) and ranks second in population size after East Africa. Nigeria, where ECOWAS is Headquartered, holds 52.15% of the region’s population and is the most populous country in Africa as well as its largest economy. When Nigeria closed its borders on 14th October 2019 for economic reasons, the measure was widely regarded unpopular among the neighbouring States. With the benefit of hindsight from the COVID-19 development, however, it was hailed as a significant contributor in stemming the cross-border spread of the coronavirus. A summary of the impact status on the region as of 14th June 2020 is captured in Table 3.1 below.

Table 3.1 COVID-19 Impact on West Africa Region on 14th June, 2020

Given its population size, the commercial and social propensities of its people, it was less of a surprise that the number of confirmed cases recorded by Nigeria was the highest in the region as of 14th June 2020. Maintaining correlation with population size, Ghana recorded the second-highest number of cases in the region. Liberia’s mortality rate of 6.99%, the highest in the region, deserves a mention and attention.

Nigeria Pandemic Report

According to several sources quoted from data supplied by the United Nations, Nigeria’s 2020 population estimate of 206 million, representing 2.64% of the global total, is ranked 7th on the list of countries. It is also regarded as the most populous black country in the world. These metrics, which point to great economic and political potentialities, are responsible for some of the attention Nigeria attracts from the global community. The socio-economic implication of the closure of Nigeria’s borders pre-COVID and beyond as discussed earlier was one of such impacts.

The number of cases recorded by the country’s Centre for Disease Control as of 14th June 2020 was 16,805. With an active rate of 64.94% and mortality under 3%, Nigeria demonstrates a notable resilience of the African nations not unlike the type it demonstrated on the onset of the July 2014 Ebola outbreak. The institutional memory from the effective management of the Ebola outbreak would appear to have significantly contributed to the COVID19 structure established to manage the coronavirus pandemic. A dedicated Nigeria COVID-19 Report is available here

Final Thoughts

The COVID-19 Report has been presented in a story-like form, a popular culture in data analysis and reporting environment that has been adopted in providing clarity on data-based issues and structures. The knowledge shared is intended to lead to the formulation of measures against the COVID-19 scourge and support a new architecture of a reliable response framework against similar occurrences in the future. Business Intelligence and Analysis tools such as the Microsoft Power BI have eased the extraction and transformation of massive amounts of data to help reveal timely insights for actionable decisions.

In the future, daily disease forecasts channels would most likely evolve, similar to the ubiquitous weather channels, to broadcast warnings that would enable us to take preventative and remedial actions without waiting for belated government interventions. The evolution of such outlets would be driven by Data Merchants, entrepreneurs of actionable data for sale. They will substitute government information organs to bridge the information gap and profit from the opportunities. Events such as the one reported by Forbes in the United States of America present the perfect scenario for the new enterprises. Forbes reported a study published revealing that:

Around 54,000 coronavirus-linked deaths in the U.S. could have been avoided by early May if states issued coronavirus restrictions on March 1, 2020, according to a new Columbia University model that starkly demonstrates how early action might have curtailed the growth of the virus

The fact that if requisite warnings had been issued on time, 54,000 people could have been alive today, would continue to resonate with most Americans. A sub-conscious sensory memory for self-preservation has been created and would provide the perfect trigger target to the data merchants to formulate and offer customized on-demand information to willing clients.

Cloud computing powered through Artificial Intelligence, Machine and Deep Learning would continue to advance technological developments and the creation of opportunities that are yet to be fathomed. While many appear to resist and even regard the changes as digital sorcery, the new world order isn’t going to reverse itself but will continue to evolve because data has, indeed, become the new oil and forms the bedrock for all forms of human advancement.

Why Microsoft’s Dominance over Big Data is a Given

Why Microsoft’s Dominance over Big Data is a Given

The business model adopted by Microsoft has defined its growth and overall success story. For the purpose of this article, I shall call it the Access Model (AM). The acronym should not be confused with MA, Microsoft Access; if you contemplated the association, however, your thoughts are trending alongside mine. The musings that I am putting forth concern the recently affirmed recognition by Forrester Wave™ of Microsoft as a Leader in enterprise business intelligence (BI) platforms. And, for added perspective, let’s also mention Gartner’s recognition of Microsoft again as a leader in Analytics and BI platforms for 11 consecutive years.

Having used Microsoft Windows and Office since the 1980s and observed the entry of these products into the Nigerian homes and offices, I could hypothesize that the growth of any tech giant can be foretold by assessing the degree and scope of its penetration as an entity and product into the developing nations, particularly those in Africa. For this purpose, I have classified these companies into two categories. Companies with very strict or protectionist marketing policies that tend to be governed by the fear of open and new grounds would choose to remain local and private. You would find Apple in this category, a leader in its exclusive and secure club. Those with a generous outlook tend to be liberal and willing to take higher risks; by conquering imagined and real phobias, they boldly plunge into Africa and other similar risk adjudged markets. They would first make generous allowance to absorb projected risks and fears regarding unstable markets and losses occasioned from copyrights infringements. Microsoft belongs in the second category.

The average middle class and most of those below that class were introduced to the world wide web through Microsoft products; Widows, Office and the ubiquitous Internet Explorer had made it possible for a broad demographic to know and use the internet earlier than would have been possible without their presence. I am unable to envision any scenario where that would have been possible if Apple were the producer of those products and services. Microsoft would definitely not deliberately promote the piracy of its products, but making them accessible to many had effected a return on investments to Microsoft on a scale it probably never contemplated.

Let me digress to relate a marketing tactic deployed in Africa by the makers of Three Rings cigarettes in the 60s. Buyers narrated that when they bought a tin of cigarettes that contained about 20 sticks, they discovered lying at the bottom of the container the exact same amount of money they used to purchase the product. Additionally, the case was an attractive and useful ornament that delighted their sight as they got high and delirious on the nicotine they were sucking from the smoke. By the time the makers withdrew the free refund, enough customers had become hooked and more than willing smokers who continued to buy the product now in mutilated and ugly packaging. No one cared so long they could get their daily fix. The only analogy here is the habit formation capability of Microsoft products as tools of trade and commerce. Free is the most magical tactic to guarantee a successful marketing strategy. If you can provide cheap or free access to your product, depending on the long-term vision and resources, you have secured yourself growth and profits.

I neither subscribe to nor encourage copyright infringement to facilitate access to a product or service. The reference to it above was to underscore the conjecture I had theorized earlier. Evidently, growth models must design for accessibility and availability in terms of pricing and affordability to achieve full potentialities. Amazon realized this on its Market platform. Google and Facebook have attained successes primarily by deploying the Access Model founded on the platform of free and affordable infrastructure. Apple, on the other hand, though a manufacturer of high quality but an expensive and not easily accessible range of products, would remain a local high-value company that would not operate in the same league as the other global tech giants. Samsung’s struggle to compete with Apple has constrained the company from joining the elite AM club. Google too could have been a contender with its array of android, pixel and chrome products but is conflicted between the very successful search engine and various products it had fathered but was unable to keep faith in.

Microsoft, however, sticks with all its products and would trip only into the precipice of success. While Google had created and scrapped several chat apps, including Google+, a highly celebrated social platform, Microsoft kept faith with every single software that is created. Microsoft has transmuted its products into either Platform as a Service (PaaS) and/or Software as a Service (SaaS).

Now, let me run with some wild imagination.

The use of any of these products invariably leads to the other and slowly but surely the new modern era Matrix emerges under the seduction of the Oracle S to create a Singularity of Superior Soft Service. Teletransporting through and above the clouds into the tranquil blue sky that is the AZURE. Though Cloud and Azure Services do not actually hold any data, the symbolism carries a depth of meaning and demonstrates the amorphous capabilities and mastery in the accumulation and management of Big Data. By understanding the significance of Azure, one would have grasped the force driving Microsoft to emerge the head of the UDK – Ultimate Data Kingdom.

Data is regarded as King; though others would rather see it as the new virtual soil. Whoever commands and controls Big Data becomes the master of all. While Amazon and Apple are restricted to the atmospheric territory bounded by the Clouds, Microsoft transcends to the Azure into the mystic realm of the machine; comprising a chain of a satellite system that gathers and marshals all the data. This is the real Space Force comprising a virtual army that has effectively colonized the primary level of data generation and extraction from earthly computers. Then, it integrates with the secondary data being gathered under level two cloud chambers by Messrs. Amazon Web Services & Apple iCloud et al. Azure, sitting above it all, is the crown seat of the UDK where all data is coalesced to form a Singularity that unites all under the supremacy of Microsoft. Unlike the Blackhole that spaghettifies and destructs everything, the UDK transforms and constructs new robotic capabilities that would shape and dictate the New World Order.

I might have overstretched limits of imagination, but you understand the overall idea.

%d bloggers like this: