Analyzing COVID-19 Global Pandemic Crisis
Life SciencesBusiness Impacts
Data Visualization
Increased Healthcare Safety Measures
Customer Key Facts
- Location : United Kingdom
- Industry : Healthcare
Problem Context
The outbreak of COVID-19 across the globe not only resulted in wide-spread infection, but also caused countries to suffer massively in terms of both inadequate health facilities and economic slowdown. Analyzing the spread, beginning from its initial outbreak to when it had been declared as a pandemic, can provide a holistic view of its impact.
Challenges
- Obtaining claims data in .CSV format
- Pulling data into Google’s BigQuery and processing the raw files
- Bringing data to Looker from BigQuery and visualizing multiple metrics
- Collecting COVID-19 data from multiple sources
- Deriving relevant metrics and key KPIs needed to comprehend trends from number of different angles
Technologies Used
Cloud Storage
Google's BigQuery
Looker
Analyzing the Spread of COVID-19 Across the Globe
Solution
Leveraging COVID-19 data from multiple sources, like Worldometer, The World Health Organization (WHO), and The Center for Systems Science and Engineering (CSSE) at Johns Hopkins University, Quantiphi helped a global medical technology business build a visualization tool that gives an in-depth analysis of the impact of the virus in India.
Result
- Assists organizations in taking appropriate security and healthcare safety measures
- Maps demographics, mobility of citizens, facilities, services, etc. for organizations to better understand and respond to current and potential impacts of COVID-19
