• Skip to content
  • Skip to footer

The Copley Consulting Group

MENUMENU
  • Products & Solutions
    • Infor ERP

      Fully integrated ERP solution suite for manufacturers which can be deployed in the cloud or on premise

      Infor CloudSuite Industrial

      Copley FDA Extended Solution

    • Qlik Business Intelligence

      Easy to use self-service and predictive business analytics platform to enable better decision-making

      Qlik Analytics

      - Qlik Sense

      - Qlik Extended Solutions

      Analytics Applications

      Business analytics solutions tailored to your industry

      Life Science Analytics

      Manufacturing Analytics

      Public Sector Analytics

    • Partner Products

      Pacejet Shipping Solution

      Prophix Corporate Performance Management

    • View Cloud Solution
      Visit the Blog
      View Resources Center
  • Services
    • Copley ERP Services

      Nationwide team of consultants devoted to on-site, personalized training and education for Infor CSI (SyteLine) clients

      Program Management

      Business Process Workshops

      Client User Training

      ERP Conference Room Pilot

      ERP Go Live Support

    • FDA Validation Support

      FDA validation support, process templates, scripts and test plans for Infor CSI (SyteLine) solution deployment

      FDA Validation Template Processes

      FDA Validation OPQ Scripts & Test Plans

    • Qlik Services

      Tools, training, education and support services for analytics solutions

      Consulting Services

      Technical Services

      Training & Education

      Support

    • ERP Support
      Qlik Support
      View Resources Center
  • Industries & Clients
    • FDA Regulated

    • General Manufacturing

    • High Technology

    • Aerospace & Defense

    • Marine Industry

    • K-12

    • Higher Education

    • Police & Public Safety

    • Health & Human Services

    • State & Local Government

  • Company
    • News & Events
    • Resources
    • Videos
    • Careers
  • Blog
  • Contact Us

COVID-19

05/01/2020 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 

Filed Under: Featured News, News Tagged With: COVID-19, data, Loudoun County Public Schools, Qlik, Qlik Analytics Solution, The Copley Consulting Group

03/30/2020 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

Filed Under: News Tagged With: analytics, analytics technology, copley consulting group, coronavirus, COVID-19, data, data analytics, Qlik, qlik sense

Footer

Menu

  • Products & Solutions
  • Services
  • Industries & Clients
  • Company
  • Blog
  • Contact Us
  • Privacy Policy

Contact

Toll-Free
855-884-5305

General Questions
sales@copleycg.com

FDA Pack Support
fdapacksupport@copleycg.com

Qlik Support
qliksupport@copleycg.com

Subscribe to our News

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

FOLLOW US: