Presented by Jung Ma at the 93rd Annual Mosquito and Vector Control Association of California (MVCAC) Conference in Oakland, CA.

Abstract:

Vector control agencies rely on regular data reports to make informed decisions across multiple departments. Compiling data and generating reports on a routine basis can be a lengthy and repetitive process with room for human error. At the San Gabriel Valley Mosquito and Vector Control District, a semi-automated method of generating surveillance reports has been developed using Microsoft’s Power BI and connecting it to the VectorSurv Gateway, a database where mosquito data is entered and stored.  This process involves melding and organizing data sources in Power BI through data manipulation and using the compiled data to set up calculations and visualizations such as tables, maps, and graphs, in a predetermined layout. After the report file is set up, the displayed calculations and visualizations semi-automatically update as the VectorSurv database is updated with new data entries. Making new reports for isolated events also becomes a simplified process when the relevant data is already compiled and organized. This method of generating reports has reduced the amount of time and effort needed to produce complex deliverables and has improved accuracy by eliminating many opportunities for human error.

Resources: 

Do you have a question for me or want to get in contact with me?