Development of interactive dashboards for monitoring endemic animal pathogens in Ontario, Canada: Ontario interactive animal pathogen dashboards

J Vet Diagn Invest. 2023 Nov;35(6):727-736. doi: 10.1177/10406387231190076. Epub 2023 Aug 4.

Abstract

The advancement of web-based technologies makes it possible to build user interfaces or web pages that present and summarize complex data in easy-to-read graphical formats that emphasize key information. Taking advantage of this technologic progress, we addressed the need for real-time visualizations of trends for major pathogens in the largest livestock industries in Ontario: poultry, swine, and cattle. These visualizations were built using test data from the laboratory information management system of the Animal Health Laboratory at the University of Guelph, a large veterinary diagnostic laboratory in Ontario. The data were processed using R software and used to construct interactive and dynamic visualizations using Tableau Desktop v.2021.4 (Tableau Software). We designed 12 dashboards: in chickens-influenza A virus, fowl adenovirus, infectious bronchitis virus, and infectious laryngotracheitis virus; in turkeys-influenza A virus; in swine, influenza A virus, rotavirus, and porcine reproductive and respiratory syndrome virus; in cattle-bovine viral diarrhea virus, Mycoplasma bovis, Salmonella Dublin in individual samples, and Salmonella Dublin in bulk tank milk samples. Data for each pathogen are presented in 2 dashboards. One shows the data of the last 10 y (general view) and the other the data of the last 3 y, but in more detail (comprehensive view). Information on gaining access to all dashboards is available at https://iapd.lsd.uoguelph.ca/. The visualizations provide near-real-time access to aggregated assay results for selected pathogens for veterinarians, animal health regulatory agencies, researchers, and other users who are interested in livestock pathogen surveillance.

Keywords: cattle; dashboard; data; livestock; poultry; swine; turkeys; visualization.

MeSH terms

  • Animals
  • Cattle
  • Chickens*
  • Ontario / epidemiology
  • Rotavirus*
  • Software
  • Swine
  • Turkeys