This is a project that I worked on for Belton ISD in the central Texas area in the fall of 2021 to help report positive COVID-19 cases in their district. This was a major expansion of the dashboard that I created last year for the ISD.
Using Microsoft 365 applications, I designed an infrastructure that allows administration to input new positive COVID-19 cases, both lab-confirmed and probable, as they occur which then updates the website’s dashboard on a daily basis. This data updates automatically and not only populates the public-facing website dashboard but also multiple administrative dashboards that are used to inform decisions made by the administration.
Microsoft Power BI was used to create the dashboard, as seen in the screenshot below. One of the main aspects that Belton wanted for their dashboard was to let the public see both Lab-Confirmed and Probable cases.
Belton ISD Dashboard
The following are the key components of the dashboard:
- Each campus has the current positive COVID-19 cases for Lab-Confirmed and Probable cases displayed.
- The total percentage of the population with positive cases is also given.
- A timeline of total confirmed cases (Lab-Confirmed and Probable) in the last 10 days is given. Users can filter the timeline by campus if wanted.
In order to ensure that Belton ISD did not have to manually update the dashboard, I set up the infrastructure so that after district administration input the new cases as they occur, everything is updated automatically. It was decided to schedule the Power BI refresh for each morning before school starts so that parents can make the best decision on whether to keep their child(ren) home or not.
I designed the entire reporting infrastructure for Belton ISD: from the data capture from nurses and administration, data storage, and data analysis. This process helped to save 10+ working hours per week for the district.
This project was a pleasure to work on and it has helped parents, teachers and staff to make the best decision on whether to keep class in-person or move to a virtual solution.
Boles Data Consulting 