The Copley Consulting Group

COVID-19

By

Copley COVID-19 Vaccinations Tracking Utilizing the Qlik Platform

The Copley Consulting Group has The Copley Consulting Group has Designed an Application Tracking COVID-19 Vaccinations Using Qlik

Its been a year since the inception of the COVID-19 and vaccines are being rushed out to the world quicker than can be administered. With a shortage of vaccines and waitlists, there is concern about how long it will take for these vaccines to reach heard immunity within the population. Heard immunity is when a certain proportion of the population has been vaccinated or immune to interrupt the transmission to other individuals. The Mayo Clinic estimates this percentage of the population could be as high as 94% for proper effectiveness. Taking the 2020 population estimate of 331 million in the United States, this means heard immunity will need to comprise of more than 311 million individuals vaccinated or immune in the US alone. As of February 1st, 2021, the United States has successfully administered 26 million first-time doses in just under 2 months. As you can see, the United States is currently near a 7.8% vaccination rate for and this is a growing concern regarding the efficacy, mutations, distribution, and timeline of the efforts for vaccinating COVID-19.

Copley made expansive efforts to track the COVID-19 outbreak by daily cases, deaths, and recoveries to find correlations in unemployment claims, weather pollution, and stock market information. Now, we believe the focus of this pandemic is on the upswing and have directed our focus to tracking the Vaccinations in the United States. By using data from Our World in Data’s GitHub repository, the Copley Consulting Group has constructed a web application that tracks daily vaccinations performed, issued, and doses used in respect to population density.

The goal of the Qlik Sense application is to provide a real-time (daily refresh), interactive, and visually aesthetic way of consuming the data that exists in the wild. At Copley we strive to convey messages in a way that would enhance data transparency and literacy for all during this time of the pandemic. Having the most up-to-date and accurate data can be accomplished with Qlik. This data is being provided with the hope that people will gain deeper and meaningful insight as to the challenges we face and provide some degree of reassurance as we move towards controlling and hopefully eradicating this virus. We will continue to enhance the application as we evaluate new data sources as we work to provide you with updates as we progress and continue to support our community.

If you have any questions regarding Qlik or the data provided, please feel free to contact us at qlik@copleycg.com.

To access the interactive Qlik application to track COVID-19 vaccination data, click here.

About The Copley Consulting Group
The Copley Consulting Group helps organizations drive business transformation. With 30 years of experience in ERP and business analytics, it is our mission to guide organizations and help them enhance business processes and increase efficiencies in operations. https://copleycg.com

Share This on Social:
LinkedIn
Twitter

By

A Copley Customer Case Study Using Qlik For K12 Decision Making During The Time of COVID-19

The Copley Consulting Group’s customer, Loudoun County Public Schools, is doing their part to help students and families by utilizing the Qlik application during the COVID-19 outbreak.  

Qlik.com – Loudoun County Public Schools (LCPS) was able to purchase 1,500 total hotspots from different vendors in early March, in anticipation of school closures for a small percentage of families and staff who do not have access to the internet in their homes.

LCPS needed to identify household data, not just students, in order to equitably distribute the devices to families. In addition, a triage approach for need was established to provide hotspots to families based on these needs:

1. Households identified with a disadvantaged status
2. Households with multiple students
3. Households with students in higher grade levels (starting with High School as a top priority)

Each hotspot can serve up to 15 devices in a household. The Department of Digital Innovation was asked to identify families and staff who needed a WiFi hotspot during the closure of buildings. A Google form survey was sent out to the public school families and staff requesting the following information:

1. Student name, address, LCPS school
2. Parent/Guardian name and contact information

The results of the survey were then loaded into Qlik, connected to additional data, and a set of visualizations developed.

Sheet 1 – Map of Addresses w/Student Count is a geo-map of the responses from the survey.

Sheet 2 – Prioritization Data identifies students and household counts, along with the decision factors such as Disadvantaged status, number of students in a household, and grade levels (3-12 to ensure instructional delivery online).

By reviewing the data we identified specific clusters (high school feeder zones that include elementary, middle and high schools in a region). In this example, the JCH (John Champe HS) cluster showed the highest number of respondents:

However, the number of Disadvantaged students was lower than PVH (Park View HS) cluster.

Thus, we were able to identify households in the PVH cluster as the first set of recipients for the hotspot devices.

Sheet 3 – Contact Information shows the data we needed to contact families via all of our methods and stage pick up processes outside of the school. The student data is tied to the student information system tables and shows indicators for English Learners and Special Education students as well.

As hotspots were distributed, data was reloaded and adjustments made based on usage metrics and feedback from principals who were in touch with families. The Qlik app significantly improved our ability to identify households in need of hotspots and quickly contact and deploy devices.

Original Article: By Rachel Johnson, Director, Enterprise Solutions, Loudoun County Public Schools 

By

Copley COVID-19 Application Utilizing the Qlik Platform

The Copley Consulting Group has Designed an Application Utilizing the Qlik Platform to Track COVID-19

With the COVID-19 pandemic impacting the world population, and the recent aggressive outbreaks across the United States, Copley has designed an application utilizing the Qlik platform, to measure and track this virus and the effect it has had across financial markets and environmental conditions, in addition to health data. Unifying disparate data from multiple sources including Johns Hopkins, the World Health Organization (WHO), the Federal Environmental Protection Agency (EPA) and other data sources, Copley has built an interactive Qlik Sense application to track daily, weekly and monthly critical data elements to provide a more holistic view of the viruses impact. We have melded this information with the new unemployment statistics to understand the correlation of the pandemic with the financial fallout.

At a high level, individuals can visualize key metrics such as Total Cases, Mortality Rates and Recoveries globally while melding it with correlated financial and environmental information. Given the capability for on-line, real time interactivity, users can compare country, region, state, and local critical data points to better understand the profound impact of COVID-19 while allowing for personalized geographic focus.

As stated, by consolidating data from the multiple, disparate data sources, the application provides you with a broader vantage point of the overall impact of the virus on our economy and environment.

Having the most up-to-date and accurate data can be accomplished with Qlik. This data is being provided with the hope that people will gain deeper and meaningful insight as to the challenges we face and provide some degree of reassurance as we move towards controlling and hopefully eradicating this virus.

We will continue to enhance the application as we evaluate new data sources as we work to provide you with updates as we progress and continue to support our community.

If you have any questions regarding Qlik or the data provided, please feel free to contact us at qlik@copleycg.com.

To access the interactive Qlik application to track COVID-19, click here.

About The Copley Consulting Group
The Copley Consulting Group helps organizations drive business transformation. With 30 years of experience in ERP and business analytics, it is our mission to guide organizations and help them enhance business processes and increase efficiencies in operations. https://copleycg.com

Share This on Social:
LinkedIn
Twitter

Copyright © 2021 · THE COPLEY CONSULTING GROUP · 400 Trade Center, Suite 3950, Woburn, MA

FOLLOW US: