{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,26]],"date-time":"2026-07-26T21:56:54Z","timestamp":1785103014093,"version":"3.55.0"},"reference-count":25,"publisher":"Oxford University Press (OUP)","issue":"6","license":[{"start":{"date-parts":[[2023,9,22]],"date-time":"2023-09-22T00:00:00Z","timestamp":1695340800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/academic.oup.com\/pages\/standard-publication-reuse-rights"}],"funder":[{"name":"L'Oreal Research and Innovation chair in Digital Biology"},{"DOI":"10.13039\/501100000038","name":"Natural Sciences and Engineering Research Council of Canada","doi-asserted-by":"publisher","award":["CG118883"],"award-info":[{"award-number":["CG118883"]}],"id":[{"id":"10.13039\/501100000038","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2023,9,22]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>The emergence of massive datasets exploring the multiple levels of molecular biology has made their analysis and knowledge transfer more complex. Flexible tools to manage big biological datasets could be of great help for standardizing the usage of developed data visualizations and integration methods. Business intelligence (BI) tools have been used in many fields as exploratory tools. They have numerous connectors to link numerous data repositories with a unified graphic interface, offering an overview of data and facilitating interpretation for decision makers. BI tools could be a flexible and user-friendly way of handling molecular biological data with interactive visualizations. However, it is rather uncommon to see such tools used for the exploration of massive and complex datasets in biological fields. We believe that two main obstacles could be the reason. Firstly, we posit that the way to import data into BI tools are not compatible with biological databases. Secondly, BI tools may not be adapted to certain particularities of complex biological data, namely, the size, the variability of datasets and the availability of specialized visualizations. This paper highlights the use of five BI tools (Elastic Kibana, Siren Investigate, Microsoft Power BI, Salesforce Tableau and Apache Superset) onto which the massive data management repository engine called Elasticsearch is compatible. Four case studies will be discussed in which these BI tools were applied on biological datasets with different characteristics. We conclude that the performance of the tools depends on the complexity of the biological questions and the size of the datasets.<\/jats:p>","DOI":"10.1093\/bib\/bbad348","type":"journal-article","created":{"date-parts":[[2023,10,6]],"date-time":"2023-10-06T01:38:39Z","timestamp":1696556319000},"source":"Crossref","is-referenced-by-count":3,"title":["Use of Elasticsearch-based business intelligence tools for integration and visualization of biological data"],"prefix":"10.1093","volume":"24","author":[{"given":"Marie-Pier","family":"Scott-Boyer","sequence":"first","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Pascal","family":"Dufour","sequence":"additional","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Fran\u00e7ois","family":"Belleau","sequence":"additional","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Regis","family":"Ongaro-Carcy","sequence":"additional","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"},{"name":"D\u00e9partement de M\u00e9decine Mol\u00e9culaire , G1V 0A6, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Cl\u00e9ment","family":"Plessis","sequence":"additional","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Olivier","family":"P\u00e9rin","sequence":"additional","affiliation":[{"name":"L\u2018Or\u00e9al Advance Research , Aulnay-sous-Bois, 93600 , France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Arnaud","family":"Droit","sequence":"additional","affiliation":[{"name":"Centre de Recherche du CHU de Qu\u00e9bec-Universit\u00e9, Laval, Universit\u00e9 Laval , G1V 4G2, Qu\u00e9bec , Canada"},{"name":"D\u00e9partement de M\u00e9decine Mol\u00e9culaire , G1V 0A6, Qu\u00e9bec , Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"286","published-online":{"date-parts":[[2023,10,5]]},"reference":[{"key":"2023100601373670500_ref1","first-page":"1","volume-title":"Information Visualization: Human-Centered Issues and Perspectives","author":"Fekete","year":"2008"},{"issue":"12","key":"2023100601373670500_ref2","doi-asserted-by":"crossref","first-page":"1109","DOI":"10.1056\/NEJMp1607591","article-title":"Toward a shared vision for cancer genomic data","volume":"375","author":"Grossman","year":"2016","journal-title":"N Engl J Med"},{"issue":"D1","key":"2023100601373670500_ref3","first-page":"D498","article-title":"The reactome pathway knowledgebase","volume":"48","author":"Jassal","year":"2020","journal-title":"Nucleic Acids Res"},{"issue":"D1","key":"2023100601373670500_ref4","doi-asserted-by":"crossref","first-page":"D480","DOI":"10.1093\/nar\/gkaa1100","article-title":"UniProt: the universal protein knowledgebase in 2021","volume":"49","author":"The UniProt Consortium","year":"2021","journal-title":"Nucleic Acids Res"},{"issue":"D1","key":"2023100601373670500_ref5","doi-asserted-by":"crossref","first-page":"D478","DOI":"10.1093\/nar\/gkt1067","article-title":"SMPDB 2.0: big improvements to the small molecule pathway database","volume":"42","author":"Jewison","year":"2014","journal-title":"Nucleic Acids Res"},{"issue":"D1","key":"2023100601373670500_ref6","doi-asserted-by":"crossref","first-page":"D608","DOI":"10.1093\/nar\/gkx1089","article-title":"HMDB 4.0: the human metabolome database for 2018","volume":"46","author":"Wishart","year":"2018","journal-title":"Nucleic Acids Res"},{"issue":"9","key":"2023100601373670500_ref7","doi-asserted-by":"crossref","first-page":"1395","DOI":"10.1101\/gr.232397.117","article-title":"GrapeTree: visualization of core genomic relationships among 100,000 bacterial pathogens","volume":"28","author":"Zhou","year":"2018","journal-title":"Genome Res"},{"key":"2023100601373670500_ref8","doi-asserted-by":"crossref","DOI":"10.1038\/sdata.2017.151","article-title":"Clustergrammer, a web-based heatmap visualization and analysis tool for high-dimensional biological data","volume":"4","author":"Fernandez","year":"2017","journal-title":"Sci Data"},{"issue":"18","key":"2023100601373670500_ref9","doi-asserted-by":"crossref","first-page":"2347","DOI":"10.1093\/bioinformatics\/btq430","article-title":"Cytoscape web: an interactive web-based network browser","volume":"26","author":"Lopes","year":"2010","journal-title":"Bioinformatics"},{"issue":"2","key":"2023100601373670500_ref10","doi-asserted-by":"crossref","first-page":"97","DOI":"10.1089\/big.2015.0057","article-title":"Integration and visualization of translational medicine data for better understanding of human diseases","volume":"4","author":"Satagopam","year":"2016","journal-title":"Big Data"},{"key":"2023100601373670500_ref11","doi-asserted-by":"crossref","first-page":"63","DOI":"10.1016\/j.bbapap.2013.02.032","article-title":"Open source libraries and frameworks for mass spectrometry based proteomics: a developer\u2019s perspective","volume":"1844","author":"Perez-Riverol","year":"2014","journal-title":"Biochim Biophys Acta BBA - Proteins Proteomics"},{"issue":"8","key":"2023100601373670500_ref12","doi-asserted-by":"crossref","first-page":"1356","DOI":"10.1002\/pmic.201400377","article-title":"Open source libraries and frameworks for biological data visualisation: a guide for developers","volume":"15","author":"Wang","year":"2015","journal-title":"Proteomics"},{"key":"2023100601373670500_ref13","doi-asserted-by":"crossref","first-page":"721","DOI":"10.1145\/1142473.1142560","volume-title":"Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data","author":"Hanrahan","year":"2006"},{"issue":"178","key":"2023100601373670500_ref14","doi-asserted-by":"crossref","first-page":"39","DOI":"10.1002\/ir.20266","article-title":"Evolving business intelligence and data analytics in higher education","volume":"2018","author":"Drake","year":"2018","journal-title":"New Dir Institutional Res"},{"key":"2023100601373670500_ref15","doi-asserted-by":"crossref","first-page":"495","DOI":"10.1007\/978-981-13-1927-3_53","volume-title":"Smart Intelligent Computing and Applications","author":"Reddy","year":"2019"},{"issue":"17","key":"2023100601373670500_ref16","doi-asserted-by":"crossref","first-page":"2706","DOI":"10.1093\/bioinformatics\/btab157","article-title":"KibioR & Kibio: a new architecture for next-generation data querying and sharing in big biology","volume":"37","author":"Ongaro-Carcy","year":"2021","journal-title":"Bioinformatics"},{"issue":"5","key":"2023100601373670500_ref17","doi-asserted-by":"crossref","first-page":"677","DOI":"10.1108\/MRR-07-2020-0386","article-title":"35 years of research on business intelligence process: a synthesis of a fragmented literature","volume":"44","author":"Talaoui","year":"2020","journal-title":"Manag Res Rev"},{"issue":"9","key":"2023100601373670500_ref18","doi-asserted-by":"crossref","first-page":"1520","DOI":"10.1109\/TVCG.2011.279","article-title":"Empirical studies in information visualization: seven scenarios","volume":"18","author":"Lam","year":"2012","journal-title":"IEEE Trans Vis Comput Graph"},{"issue":"D1","key":"2023100601373670500_ref19","doi-asserted-by":"crossref","first-page":"D873","DOI":"10.1093\/nar\/gku843","article-title":"The digital ageing atlas: integrating the diversity of age-related changes into a unified resource","volume":"43","author":"Craig","year":"2015","journal-title":"Nucleic Acids Res"},{"issue":"D1","key":"2023100601373670500_ref20","first-page":"D148","article-title":"miRTarBase 2020: updates to the experimentally validated microRNA\u2013target interaction database","volume":"48","author":"Huang","year":"2020","journal-title":"Nucleic Acids Res"},{"key":"2023100601373670500_ref21","doi-asserted-by":"crossref","first-page":"e26726","DOI":"10.7554\/eLife.26726","article-title":"Systematic integration of biomedical knowledge prioritizes drugs for repurposing","volume":"6","author":"Himmelstein","year":"2017","journal-title":"Elife"},{"key":"2023100601373670500_ref22","volume-title":"pandas-dev\/pandas: Pandas","author":"The pandas development team","year":"2022"},{"key":"2023100601373670500_ref23","first-page":"D155","article-title":"miRBase: from microRNA sequences to function","volume-title":"Nucleic Acids Res","author":"Kozomara","year":"2019"},{"issue":"41","key":"2023100601373670500_ref24","doi-asserted-by":"crossref","first-page":"e2110025118","DOI":"10.1073\/pnas.2110025118","article-title":"Integrated spatial multiomics reveals fibroblast fate during tissue repair","volume":"118","author":"Foster","year":"2021","journal-title":"Proc Natl Acad Sci U S A"},{"issue":"1","key":"2023100601373670500_ref25","doi-asserted-by":"crossref","first-page":"341","DOI":"10.1109\/TVCG.2016.2599030","article-title":"Vega-Lite: a grammar of interactive graphics","volume":"23","author":"Satyanarayan","year":"2017","journal-title":"IEEE Trans Vis Comput Graph"}],"container-title":["Briefings in Bioinformatics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/academic.oup.com\/bib\/article-pdf\/24\/6\/bbad348\/51895265\/bbad348.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/academic.oup.com\/bib\/article-pdf\/24\/6\/bbad348\/51895265\/bbad348.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,6]],"date-time":"2023-10-06T01:38:55Z","timestamp":1696556335000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/bib\/article\/doi\/10.1093\/bib\/bbad348\/7291998"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,9,22]]},"references-count":25,"journal-issue":{"issue":"6","published-print":{"date-parts":[[2023,9,22]]}},"URL":"https:\/\/doi.org\/10.1093\/bib\/bbad348","relation":{},"ISSN":["1467-5463","1477-4054"],"issn-type":[{"value":"1467-5463","type":"print"},{"value":"1477-4054","type":"electronic"}],"subject":[],"published-other":{"date-parts":[[2023,11,1]]},"published":{"date-parts":[[2023,9,22]]},"article-number":"bbad348"}}