Abstract
OurStats (https://www.cbrc.net/ourstats) is a data visualization dashboard developed by the Community-Based Research Centre (CBRC) to increase access to data from the Sex Now surveys—Canada’s largest community-based surveillance study of gay and bisexual men. An evaluation of the OurStats dashboard was conducted using an online survey distributed through the CBRC and Advance Alliance—an alliance of Canada’s leading HIV and queer men’s health organizations. Since being launched in November 2019 (through December 2019), 350 unique visitors used the OurStats Dashboard (5.8 per day). Based on responses from 10 community partners, all respondents said they would probably/definitely use OurStats again and would probably/definitely recommend it to colleagues; nine felt it was much/somewhat better than traditional academic outputs (e.g., poster presentations, journal articles); and seven felt it was much/somewhat better than traditional knowledge translation outputs (e.g., fliers, posters, and social media posts). Respondents said they would use OurStats to identify needs of gay and bisexual men (n = 9), prepare grant/funding applications (n = 9), prepare presentations about Sex Now data (n = 7), and evaluate the impact of local programs (n = 4). Overall, half felt that OurStats was somewhat/extremely easy to use and half felt that it was somewhat difficult to use. The most commonly identified requested improvement was to provide help documentation that explained how each of the display settings changed the visualizations. From these findings, we conclude that dynamic visualizations for community-based survey data are highly feasible and acceptable, provided appropriate support is available to help community partners use these tools.
Similar content being viewed by others
Data and/or Code Availability
A live version of OurStats is available at https://www.cbrc.net/ourstats.
References
Althoff, K. N., Rebeiro, P. F., Hanna, D. B., Padgett, D., Horberg, M. A., Grinsztejn, B., et al. (2016). A picture is worth a thousand words: Maps of HIV indicators to inform research, programs, and policy from NA-ACCORD and CCASAnet clinical cohorts. Journal of the International AIDS Society, 19(1), 20707. https://doi.org/10.7448/IAS.19.1.20707.
Bajunirwe, F., Tumwebaze, F., Abongomera, G., Akakimpa, D., Kityo, C., & Mugyenyi, P. N. (2016). Identification of gaps for implementation science in the HIV prevention, care and treatment cascade; A qualitative study in 19 districts in Uganda. BMC Research Notes, 14. https://doi.org/10.1186/s13104-016-2024-4.
Cologne, J., Grant, E. J., Nakashima, E., Chen, Y., Funamoto, S., & Katayama, H. (2012). Protecting privacy of shared epidemiologic data without compromising analysis potential. Journal of Environmental and Public Health. https://doi.org/10.1155/2012/421989.
Community-based Research Centre. (2018). G.R.O.W. + L.I.F.T.: A checklist for community-research engagement. Retrieved July 25, 2020, from, https://www.cbrc.net/g_r_o_w_l_i_f_t_supplemental_report.
Dennis, S., Garrett, P., Hamm, J., Osth, A., Sreekumar, V., & Stone, B. (2019). Privacy versus open science. Behaviour Research Methods, 51, 1839–1848. https://doi.org/10.3758/s13428-019-01259-5.
Elliott, K., & Resnik, D. (2019). Making open science work for science and society. Environmental Health Perspectives, 127(7), 075002. https://doi.org/10.1289/EHP4808.
Gagliardi, A. R., Berta, W., Kothari, A., Boyko, J., & Urquhart, R. (2016). Integrated knowledge translation (IKT) in health care: A scoping review. Implementation Science, 11(1), 38. https://doi.org/10.1186/s13012-016-0399-1.
Gkoulalas-Divanis, A., & Loukides, G. (2015). Medical data privacy handbook. Berlin, Germany: Springer.
G.R.O.W + L.I.F.T. Checklist. (2018). Community-based research centre. Retrieved May 6, 2020, from https://www.cbrc.net/g_r_o_w_l_i_f_t_checklist.
Milligan, J. (2019, August 22). Dynamic parameters in tableau. VizPainter. Retrieved December 31, 2019, from https://vizpainter.com/dynamic-parameters-in-tableau/.
Montaner, J., Guillemi, S., & Harris, M. (2015). Therapeutic guidelines for antiretroviral (ARV) treatment of adult HIV infection. Vancouver, BC: British Columbia Centre for Excellence in HIV/AIDS. Retrieved July 25, 2020, from http://www.cfenet.ubc.ca/sites/default/files/uploads/Guidelines/bccfe-art-guidelines-Oct_14_2015.pdf.
Peterson, A., Wahlström, M., & Wennerhag, M. (2018). ‘Normalized’ pride? Pride parade participants in six European countries. Sexualities, 21(7), 1146–1169. https://doi.org/10.1177/1363460717715032.
Reeck, D. (2017). Introducing the tableau bridge: Live queries to on-premises data from Tableau Online. Tableau Software. Retrieved December 31, 2019, from https://www.tableau.com/about/blog/2017/5/introducing-tableau-bridge-live-queries-premises-data-tableau-online-70767.
Salway, T. J., Morgan, J., Ferlatte, O., Hawkins, B., Lachowsky, N. J., & Gilbert, M. (2019). A systematic review of characteristics of nonprobability community venue samples of sexual minority individuals and associated methods for assessing selection bias. LGBT Health, 6(5), 205–215. https://doi.org/10.1089/lgbt.2018.0241.
Stadler, J. G., Donlon, K., Siewert, J. D., Franken, T., & Lewis, N. E. (2016). Improving the efficiency and ease of healthcare analysis through use of data visualization dashboards. Big Data, 4(2), 129–135. https://doi.org/10.1089/big.2015.0059.
Statistics Canada. (2015). 2011 Census data quality and confidentiality. Retrieved April 11, 2017, from http://www12.statcan.gc.ca/census-recensement/2011/ref/quality-qualite-eng.cfm.
Tableau. (2019a). Retrieved January 2, 2020, from https://www.tableau.com/.
Tableau. (2019b). Dashboards. Retrieved December 31, 2019, from https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm.
Tableau. (2019c). Filter data from your views. Retrieved December 31, 2019, from https://help.tableau.com/current/pro/desktop/en-us/filtering.htm.
Tan, D. H. S., Hull, M. W., Yoong, D., Tremblay, C., O’Byrne, P., Thomas, R., et al. (2017). Canadian guideline on HIV pre-exposure prophylaxis and nonoccupational postexposure prophylaxis. Canadian Medical Association Journal, 189(47), E1448–E1458. https://doi.org/10.1503/cmaj.170494.
Tennant, J. P., Waldner, F., Jacques, D. C., Masuzzo, P., Collister, L. B., & Hartgerink, C. H. (2016). The academic, economic and societal impacts of open access: An evidence-based review. F1000Research. https://doi.org/10.12688/f1000research.8460.3.
Trussler, T., & Ham, D. (2016). Gay generations: Life course and gay men’s health—community-based research centre. Vancouver, BC: Community Based Research Centre. Retrieved January 2, 2020, from https://www.cbrc.net/gay_generations_life_course_and_gay_mens_health.
Wilson, M. G., Lavis, J. N., Travers, R., & Rourke, S. B. (2010). Community-based knowledge transfer and exchange: Helping community-based organizations link research to action. Implementation Science, 5, 33. https://doi.org/10.1186/1748-5908-5-33.
Yang, Q., Ogunnaike-Cooke, S., & Halverson. (2016). Estimated national HIV incidence rates among key sub-populations in Canada, 2014 (p. EPH3.5). Presented at the Canadian Conference on HIV/AIDS Research, Winnipeg, MB.
Zakkar, M., & Sedig, K. (2017). Interactive visualization of public health indicators to support policymaking: An exploratory study. Online Journal of Public Health Informatics. https://doi.org/10.5210/ojphi.v9i2.8000.
Acknowledgements
We would like to thank our partners at the Community-Based Research Centre Society and the Advance Alliance, and the participants of the 2015 and 2018 Sex Now Surveys.
Funding
OurStats was funded by a Canadian Institutes of Health Research Planning and Dissemination Grant (FRN: 161853).
Author information
Authors and Affiliations
Contributions
KGC and JS built the OurStats Dashboard. KGC wrote the manuscript. BK, RH, LT, AA, JJ, and NJL reviewed the manuscript and provided feedback throughout this project.
Corresponding author
Ethics declarations
Conflict of interest
None of the authors have conflicts or competing interests to declare.
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
About this article
Cite this article
Card, K.G., Sorge, J., Klassen, B. et al. Democratizing Access to Community-Based Survey Findings Through Dynamic Data Visualizations. Arch Sex Behav 50, 119–128 (2021). https://doi.org/10.1007/s10508-020-01806-8
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10508-020-01806-8