Data visualization tools are important tools for making health decisions based on large amounts of data. However, very few comparisons of data visualization tools have been done in the context of health-related research. This paper compares commonly available visualization tools from the perspective of a dashboard developer in the context of scientific health research using real-world data and to provide general suggestions for dashboard developers’ future visualization efforts in health-related scientific discoveries. We evaluated four commonly available visualization tools (Tableau, Spotfire, PowerBI, and R Shiny). Each tool was evaluated on visualization outcomes (comparing the generated outputs of tables, scatterplots, correlation plots, treemaps, heatmaps, and geographic maps), usability, Cloud compatibility, analytic integration, and a few other factors. All tools generated comparable visualization outcomes in our tests and were equally usable with the exception of R Shiny which is not recommended for users with limited coding experience. Every tool except R Shiny supports connections to PostgreSQL, gSheets, and Athena without additional configurations. All tools support integration with R and Python; however, PowerBI requires some additional configuration. Every tool is capable of data pre-processing and supports data transformation, null detection and outlier detection. Each tool has its own unique advantages and limitations.
AzzamTEvergreenSGermuthAA, et al. Data visualization and evaluation. N Dir Eval2013; 2013: 7–32.
2.
RaviLYanQDascaluS, et al. A survey of visualization techniques and tools for environmental data. In: Proceedings of the 2013 intl conference on computers and their applications (CATA 2013), March, 2013, Honolulu, Hawaii, USA, pp.225–230.
3.
ParsonsPSedigK. Common visualizations: Their cognitive utility. New York: Springer, 2014
4.
ChishtieJBielskaIABarreraA, et al. Interactive visualization applications in population health and health services research: Systematic scoping review. J Méd Internet Res2022; 24: e27534.
5.
ChishtieJABabineauJBielskaIA, et al. Visual analytic tools and techniques in population health and health services research: Protocol for a scoping review. JMIR Res Protoc2019; 8: e14019.
6.
ChishtieJAMarchandJ-STurcotteLA, et al. Visual analytic tools and techniques in population health and health services research: scoping review. J Méd Internet Res2020; 22: e17892.
7.
IslamMJinS. An overview of data visualization. In: 2019 International Conference on Information Science and Communications Technologies (ICISCT), Tashkent, Uzbekistan, 2019, pp. 1–7. 2019. DOI: 10.1109/ICISCT47635.2019.9012031.
8.
BeltránETMPérezMQPastor-GalindoJ, et al. COnVIDa: COVID-19 multidisciplinary data collection and dashboard. J Biomed Inform2021; 117: 103760.
9.
DongEDuHGardnerL. An interactive web-based dashboard to track COVID-19 in real time. Lancet Infect Dis2020; 20: 533–534.
HuangHTornero-VelezRBarzykTM. Associations between socio-demographic characteristics and chemical concentrations contributing to cumulative exposures in the United States. J Expo Sci Environ Epidemiology2017; 27: 544–550.
12.
HuangHWangAMorello-FroschR, et al. Cumulative risk and impact modeling on environmental chemical and social stressors. Curr Environ Heal Rep2018; 5: 88–99.
13.
FuTChungFKwokK, et al. Stock time series visualization based on data point importance. Eng Appl Artif Intell2008; 21: 1217–1232.
14.
HaoMCDayalUKeimDA, et al. Importance-driven visualization layouts for large time series data. In: IEEE symposium on information visualization, 2005. INFOVIS 2005, Minneapolis, MN, 2005, pp.203–210.
15.
RaghupathiWRaghupathiV. Big data analytics in healthcare: promise and potential. Heal Inf Sci Syst2014; 2: 3.
16.
HamD-H. EKC 2009 proceedings of the EU-Korea conference on science and technology. Springer Proc Phys2010; 135: 213–222.
17.
LiuJTangTWangW, et al. A survey of scholarly data visualization. IEEE Access2018; 6: 19205–19221.
18.
ZhangLStoffelABehrischM, et al. Visual analytics for the big data era — a comparative review of state-of-the-art commercial systems. In: 2012 IEEE conference on visual analytics science and technology (VAST), Seattle, WA, 2012, pp.173–182.
19.
BehrischMStreebDStoffelF, et al. Commercial visual analytics systems–advances in the big data analytics field. IEEE Trans Vis Comput Graph2019; 25: 3011–3031.
20.
CaldarolaEGRinaldiAM. Big data visualization tools: a survey – the new paradigms, methodologies and tools for large data sets visualization. In: Proceedings of the 6th international conference on data science, technology and applications, Madrid, Spain, 2017, pp.296–305.
21.
CraftMDobrenzBDornbushE, et al. An assessment of visualization tools for patient monitoring and medical decision making. In: 2015 systems and information engineering design symposium, Charlottesville, VA, 2015, pp.212–217.
22.
CarrollLNAuAPDetwilerLT, et al. Visualization and analytics tools for infectious disease epidemiology: a systematic review. J Biomed Inform2014; 51: 287–298.
23.
GotzDBorlandD. Data-driven healthcare: challenges and opportunities for interactive visualization. IEEE Comput Graph Appl2016; 36: 90–96.
LiuXAlharbiMSChenJ, et al. Visualization resources: a survey. Inf Vis2023; 22: 3–30.
26.
ShemeshCSChanPLegrandFA, et al. Pan-cancer population pharmacokinetics and exposure-safety and -efficacy analyses of atezolizumab in patients with high tumor mutational burden. Pharmacol Res Perspect2020; 8: e00685.
27.
AliSMGuptaNNayakGK, et al. Big data visualization: tools and challenges. In: 2016 2nd international conference on contemporary computing and informatics (IC3I), Greater Noida, India, 2016, pp.656–660.
28.
KoIChangH. Interactive visualization of healthcare data using tableau. Healthc Inform Res2017; 23: 349–354.
29.
Gunnlaugsson Á. How Can tibco spotfire enhance icelandair’s Twitter marketing? Master’s Thesis, Reykjavik University, Reykjavik, Iceland, 2015.
30.
MuiseESSouzaSChiA, et al. Downstream signaling pathways in mouse adipose tissues following acute in vivo administration of fibroblast growth factor 21. PLoS One2013; 8: e73011.
31.
McCannDJPetryNMBresellA, et al. Medication nonadherence, “professional subjects,” and apparent placebo responders. J Clin Psychopharmacol2015; 35: 566–573.
32.
Palma-RuizJMTorres-ToukoumidisAGonzález-MorenoSE, et al. An overview of the gaming industry across nations: using analytics with power BI to forecast and identify key influencers. Heliyon2022; 8: e08959.
33.
WojciechowskiJHopkinsAUptonR. Interactive pharmacometric applications using R and the shiny package. CPT: Pharmacomet Syst Pharmacol2015; 4: 146–159.
34.
TataSJainRLudwigH, et al. Living in the cloud or on the edge: opportunities and challenges of IoT application architecture. In: 2017 IEEE international conference on services computing (SCC), Honolulu, HI, 2017, pp.220–224.
35.
Spotfire. Spotfire: transforming data into real-time insights and actionable decisions, https://www.spotfire.com/ (1998, accessed 7 February 2024).
LeeSJoJ-YKimY. Performance testing of web-based data visualization. In: 2014 IEEE international conference on systems, man and cybernetics (SMC), San Diego, CA, 2014, pp.1648–1653.
44.
DiamondMMattiaA. Data visualization: an exploratory study into the software tools used by businesses. J Instr Pedagogies2015; 17: 1–7.
The PostgreSQL Global Development Group. PostgreSQL: the world’s most advanced open source database, https://www.postgresql.org/ (1996, accessed 7 February 2024).
VashishtVJakhmolaNManjarwarP, et al. An effective approach for integrating microsoft power BI application with python for predictive analytics. In: SharmaDKSonLHSharmaRCengizK (eds.) Micro-electronics and telecommunication engineering. Lecture notes in networks and systems. Singapore: Springer, 2021, pp.469–477.
57.
RadR. Pro power BI architecture, development, deployment, sharing, and security for microsoft power BI solutions. Berkeley, CA: Apress, 2023.
ChenWGuoFWangF-Y. A survey of traffic data visualization. IEEE Trans Intell Transp Syst2015; 16: 2970–2984.
60.
SwatiKKumarDS. A comparative study of various data transformation techniques in data mining. Int J Sci Eng Technol2015; 4: 146–148.
61.
RahmEDoH. Data cleaning: problems and current approaches. IEEE Data Eng Bull2000; 23: 3–13.
62.
HeckertNFillibenJCroarkinC, et al. Handbook 151: NIST/SEMATECH e-handbook of statistical methods. Gaithersburg, Maryland: National Institute of Science and Technology, 2012.
63.
MaimonORokachL. Data mining and knowledge discovery handbook. 2nd ed. New York, NY: Springer, 2010.
64.
NairLRShettySDShettySD. Interactive visual analytics on Big Data: Tableau vs D3.js. J E-Learn Knowl Soc2016; 12: 139.
65.
D3 by Observable. The JavaScript library for bespoke data visualization, https://d3js.org/ (2011, accessed 7 February 2024).
66.
HBS Research Computing Services. Large data in R: tools and techniques and large_data_in_R, https://hbs-rcs.github.io/large_data_in_R/ (2021, accessed 7 February 2024).
MelonconLWarnerE. Data visualizations: a literature review and opportunities for technical and professional communication. In: 2017 IEEE international professional communication conference (ProComm), Madison, WI, 2017, pp.1–9.
Please find the following supplemental material available below.
For Open Access articles published under a Creative Commons License, all supplemental material carries the same license as the article it is associated with.
For non-Open Access articles published, all supplemental material carries a non-exclusive license, and permission requests for re-use of supplemental material or any part of supplemental material shall be sent directly to the copyright owner as specified in the copyright notice associated with the article.
