Communities across the world impacted by COVID-19 are navigating a sea of information to help them understand the current pandemic. A team of 黑料不打烊 students and professors have joined forces to offer their expertise on the information frontline through a new analytics dashboard called .
Over the Quebec-mandated closure of schools and universities in March, an eager team of 黑料不打烊 analytics and computer science students partnered with Professors Juan Serpa and Mehmet Gumus of the Master of Management in Analytics (MMA) program at the Desautels Faculty of Management to create a dashboard reporting on the situation in Montreal and Quebec.
鈥淲e have a team of almost 20 experts in data analytics, software engineering, computer science, and geographic information systems,鈥� says Serpa. 鈥淚n addition, we have professors supervising the project to ensure that, above all, the data is properly transmitted to the public.鈥�
On the team are Venkatesh Chandra and Ramy Hammam, two final-year MMA students who spearheaded creation of the (since-discontinued) back in March. Serpa credits the duo, now working on data visualization, with setting the groundwork for COVID QC.
A fight against misinformation
The team leverages data from local, provincial and national government to provide a credible dashboard depicting the situation in Montreal and Quebec.
Aware of how the situation unfolded in places like China, Italy and Iran, the team acted promptly to set up the dashboard, understanding that communicating information is key to the public understanding how the virus behaves.
鈥淚f you look at societies like South Korea, Hong Kong, and Singapore, they鈥檙e partly winning the battle against COVID-19 with granular and accurate data. This is the biggest weapon we can give to our citizens,鈥� says Serpa.
Most major publications share data on a global or national scale, but very few are able to capture the particular situation at the regional and local levels. People interested in delving deeper into the situation in Montreal and Quebec would previously have needed to navigate a multitude of information at the local, provincial and national level.
Now, COVID QC shares the data in one dashboard while comparing the situation in Montreal and Quebec against the national and global landscape.
A personal stake in the project
(MMA鈥�20), a student working on the project as a data collector, says that it was important for the team to design an intuitive dashboard to help Quebecers better understand the situation.
鈥淲e wanted to design this platform for Quebec residents, providing sufficient information by region and borough to give a holistic view of what鈥檚 going on,鈥� she says. 鈥淥ur focus is on offering an accurate, timely, and user-friendly dashboard.鈥�
While everyone on the project team understood the value that an analytics-powered tool would bring to the Quebec community, Jiang had a personal stake in the project.
鈥淚 am from Wuhan, which is the centre of this epidemic. I鈥檝e seen how cruel this virus can be 鈥� my hometown was on lockdown with my parents in quarantine for more than 70 days and I have lost beloved family members,鈥� says Jiang.
鈥淧ersonally speaking, this is a hard time,鈥� Jiang continues. 鈥淚 really want to help because I don鈥檛 want anyone else to go through it. I want to raise public awareness that this is a serious situation, and everyone should try their best to protect themselves and the ones they love.鈥�
Jiang hopes that COVID QC will alleviate challenges that arise from a fragmented data ecosystem and arm the Quebec community with the accurate, well-organized information needed to protect themselves.
A vision to share real-time hospital data
The team of analysts and computer scientists are continuing to expand the data sources to provide a more comprehensive snapshot of how the situation is unfolding in Quebec and Montreal. Their vision is to attain hospital data to provide a bed management resource for the province.
鈥淚 have seen patients who rushed to one hospital but found no medical resources available there,鈥� says Jiang. 鈥淚n their desperate situation, they needed to try another hospital. Ideally, we want the data to reflect the availability of resources in hospitals.鈥�
Serpa says that the team鈥檚 aim is to provide a bed management platform system that will eliminate the need for critically ill individuals to 鈥渟hop around鈥� for urgent medical help. The platform currently reports on the number of individuals who are hospitalized and in intensive care, but the team hopes to dig deeper.
鈥淥ne of my research areas is on how society utilizes inventory in times of war. In fact, I have been studying how war-ridden regions utilize their medical resources when they are under a war spell. This is the best context we have to look at today鈥檚 pandemic, because hospitals get overloaded.鈥�
In many countries, during war, citizens end up moving from one hospital to another, trying to find available beds. 鈥淚f we don鈥檛 share this information publicly, Quebec could end up in this situation, especially because the outbreaks are clustered in neighbourhoods like in C么te-Des-Neiges鈥擭otre-Dame-De-Gr芒ce currently,鈥� says Serpa.
鈥淚f we don鈥檛 transmit to people which hospitals are currently overloaded, in real time, our region will have mismatches in the supply and demand of hospital beds. Real-time information-sharing platforms have been successfully implemented in war-torn countries, and has been one of the most effective life-saving measures.鈥�
A cross-faculty collaboration
The development of COVID QC is a result of a collaboration between the Desautels Faculty of Management and the Faculty of Engineering at 黑料不打烊. In the initial meeting, the group of 20 students formed three teams 鈥� data management, Tableau graphs, and website development 鈥� and set forth on the project.
In a team of three, Jiang works on data collection and updates. As a first step the team collected historical case information and defined several measures to reflect the seriousness of the situation. Noticing the global trend of cases doubling in a matter of days, this was an important measure to report on. With a focus on accuracy, currency and accessibility, the data is collected daily, verified by the team and manually updated on the dashboard. The team is using graphs and tables to visualize the data and make national and global comparisons.
鈥淭his is a meaningful project for all of us,鈥� says Jiang. 鈥淥ur professor has invested a lot of time and effort into this project and everyone takes their responsibilities seriously. I feel like I鈥檓 contributing to the community, and making impact in this difficult time.鈥�
Organizers give a special thanks to all students involved in the project: Janna Agustin (BCom鈥�20), Ruben Alba (MMA鈥�20), Christina Baik (BCom鈥�21), Venkatesh Chandra (MMA鈥�20), Loreina Chew (BA鈥�20), Jonathan Guzzo (MMA鈥�20), Ramy Hammam (MMA鈥�20), Jasmine Jiang (MMA鈥�20), Omar Lafif (MMA鈥�20), Guillaume Lapierre-Berger (BCom鈥�20), Brendan Marks (BEng鈥�22), Bradley McBain (BEng鈥�22), Katianicia Nafissatou (MMA鈥�20), Bogdan Tanasie (BCom鈥�20), Demi Wei (MMA鈥�20), and Jessica Zhang (MMA鈥�20).
Get the most recent data on and follow on and for frequent updates.
听