{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,2]],"date-time":"2026-02-02T20:58:51Z","timestamp":1770065931618,"version":"3.49.0"},"reference-count":29,"publisher":"MDPI AG","issue":"2","license":[{"start":{"date-parts":[[2026,1,31]],"date-time":"2026-01-31T00:00:00Z","timestamp":1769817600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"Romanian Ministry of Research, Innovation and Digitalization","award":["CF 193\/28.11.2022"],"award-info":[{"award-number":["CF 193\/28.11.2022"]}]},{"name":"Romanian Ministry of Research, Innovation and Digitalization","award":["760078\/23.05.2023"],"award-info":[{"award-number":["760078\/23.05.2023"]}]},{"name":"Romania\u2019s National Recovery and Resilience Plan (PNRR)\u2014Pil-lar III, Component C9, Investment 18","award":["PNRR\/2022\/C9\/MCID\/I8"],"award-info":[{"award-number":["PNRR\/2022\/C9\/MCID\/I8"]}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Systems"],"abstract":"<jats:p>Modern telemedicine requires advanced analytical solutions for efficient management of chronic diseases. This study presents the development of a comprehensive business intelligence (BI) framework using Microsoft Power BI, applied to the optimization of diabetes mellitus management. The methodology integrates Power Query transformations, 35 DAX measures organized into five functional categories, and Python 3.14.2. capabilities for advanced statistical analysis. The framework was implemented and demonstrated using a public clinical dataset of 100,000 patient records, generating five interactive dashboards covering epidemiological, demographic, clinical, geographical, and equity perspectives. A global prevalence of 8.5%, exponential growth with age, gender differences (9.75% males against 7.62% females), and substantial connections between metabolic indicators (BMI, HbA1c, and blood glucose) are all confirmed by the results. Heart disease rates are 6.2 times higher in diabetic people, according to comorbidity research. Complete methodological openness through thorough documentation, Python integration for sophisticated visualizations, and interactive multidimensional drill-down features are some of the major additions. The predictive elements are included as interpretable, exploratory components embedded in the BI environment rather than as clinically validated prediction models. This approach provides an affordable and user-friendly approach that makes advanced analytical capabilities accessible to a broader range of healthcare organizations managing chronic diseases.<\/jats:p>","DOI":"10.3390\/systems14020155","type":"journal-article","created":{"date-parts":[[2026,2,2]],"date-time":"2026-02-02T09:48:08Z","timestamp":1770025688000},"page":"155","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["A Comprehensive Business Intelligence Framework for Diabetes Management in Telemedicine: Advancing Data-Driven Decision Support Through Integrated Visualization and Predictive Analytics"],"prefix":"10.3390","volume":"14","author":[{"given":"Emilia-Alexandra","family":"Pop","sequence":"first","affiliation":[{"name":"Department of Finance, Information Systems and Business Modelling, Faculty of Economics and Business Administration, West University of Timisoara, 300115 Timisoara, Romania"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9982-4813","authenticated-orcid":false,"given":"Gabriela","family":"Mircea","sequence":"additional","affiliation":[{"name":"Department of Finance, Information Systems and Business Modelling, Faculty of Economics and Business Administration, West University of Timisoara, 300115 Timisoara, Romania"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Claudia-Roxana-Maria","family":"Iliescu","sequence":"additional","affiliation":[{"name":"Department of Finance, Information Systems and Business Modelling, Faculty of Economics and Business Administration, West University of Timisoara, 300115 Timisoara, Romania"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2026,1,31]]},"reference":[{"key":"ref_1","unstructured":"Choksi, P. (2024). 100,000 Diabetes Clinical Dataset, Kaggle. Available online: https:\/\/www.kaggle.com\/datasets\/priyamchoksi\/100000-diabetes-clinical-dataset."},{"key":"ref_2","unstructured":"World Health Organization (2016). Global Report on Diabetes, World Health Organization. Available online: https:\/\/www.who.int\/publications\/i\/item\/9789241565257."},{"key":"ref_3","doi-asserted-by":"crossref","unstructured":"Ramesh, J., Aburukba, R., and Sagahyroon, A. (2021). A Remote Healthcare Monitoring Framework for Diabetes Prediction Using Machine Learning. Healthc. Technol. Lett., 8, Available online: https:\/\/ietresearch.onlinelibrary.wiley.com\/doi\/full\/10.1049\/htl2.12010.","DOI":"10.1049\/htl2.12010"},{"key":"ref_4","unstructured":"American Diabetes Association (2023). Standards of Medical Care in Diabetes 2023. Diabetes Care, 46, S1\u2013S291."},{"key":"ref_5","doi-asserted-by":"crossref","first-page":"1679","DOI":"10.1056\/NEJMp2003539","article-title":"Virtually Perfect? Telemedicine for COVID-19","volume":"382","author":"Hollander","year":"2020","journal-title":"N. Engl. J. Med."},{"key":"ref_6","unstructured":"Power, D.J. (2025, October 19). A Brief History of Decision Support Systems. DSSResources.com 2007, Version 4.1. Available online: http:\/\/DSSResources.COM\/history\/dsshistory.html."},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"1165","DOI":"10.2307\/41703503","article-title":"Business Intelligence and Analytics: From Big Data to Big Impact","volume":"36","author":"Chen","year":"2012","journal-title":"MIS Q."},{"key":"ref_8","first-page":"380","article-title":"Clinical Data Warehouse: An Effective Tool to Create Intelligence in Disease Management","volume":"36","author":"Karami","year":"2017","journal-title":"Healthc. Manag."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1186\/2047-2501-2-3","article-title":"Big data analytics in healthcare: Promise and potential","volume":"2","author":"Raghupathi","year":"2014","journal-title":"Health Inf. Sci. Syst."},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"129","DOI":"10.1089\/big.2015.0059","article-title":"Improving the Efficiency and Ease of Healthcare Analysis Through Use of Data Visualization Dashboards","volume":"4","author":"Stadler","year":"2016","journal-title":"Big Data"},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"317","DOI":"10.5455\/aim.2015.23.317-321","article-title":"An Assessment of Performance Dashboards in Healthcare Organizations: Key Practical Issues","volume":"23","author":"Ghazisaeedi","year":"2015","journal-title":"Acta Inform. Med."},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"459","DOI":"10.1016\/j.procs.2015.08.368","article-title":"Developing Strategic Health Care Key Performance Indicators: A Case Study on a Tertiary Care Hospital","volume":"63","author":"Khalifa","year":"2015","journal-title":"Procedia Comput. Sci."},{"key":"ref_13","unstructured":"Microsoft Corporation (2024). Microsoft Power BI Desktop, Microsoft Corporation. Available online: https:\/\/powerbi.microsoft.com."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"103737","DOI":"10.1109\/ACCESS.2021.3098691","article-title":"Machine Learning Tools for Long-Term Type 2 Diabetes Risk Prediction","volume":"9","author":"Fazakis","year":"2021","journal-title":"IEEE Access"},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"9930985","DOI":"10.1155\/2021\/9930985","article-title":"Machine Learning Based Diabetes Classification and Prediction for Healthcare Applications","volume":"2021","author":"Butt","year":"2021","journal-title":"J. Healthc. Eng."},{"key":"ref_16","doi-asserted-by":"crossref","first-page":"6","DOI":"10.1186\/s41512-020-00075-2","article-title":"Logistic Regression Has Similar Performance to Optimised Machine Learning Algorithms in a Clinical Setting: Application to the Discrimination Between Type 1 and Type 2 Diabetes in Young Adults","volume":"4","author":"Lynam","year":"2020","journal-title":"Diagn. Progn. Res."},{"key":"ref_17","first-page":"32405","article-title":"Efficient Prediction of Early-Stage Diabetes Using XGBoost Classifier with Random Forest Feature Selection Technique","volume":"82","year":"2023","journal-title":"Multimed. Tools Appl."},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"5353","DOI":"10.1109\/TVCG.2022.3147154","article-title":"A Framework for Evaluating Dashboards in Healthcare","volume":"28","author":"Zhuang","year":"2022","journal-title":"IEEE Trans. Vis. Comput. Graph."},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"bbab489","DOI":"10.1093\/bib\/bbab489","article-title":"Evaluating the State of the Art in Missing Data Imputation for Clinical Data","volume":"23","author":"Luo","year":"2022","journal-title":"Brief. Bioinform."},{"key":"ref_20","doi-asserted-by":"crossref","unstructured":"Rabiei, R., Bastani, P., Ahmadi, H., Dehghan, S., and Almasi, S. (2024). Developing Public Health Surveillance Dashboards: A Scoping Review on the Design Principles. BMC Public Health, 24.","DOI":"10.1186\/s12889-024-17841-2"},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"278","DOI":"10.1210\/er.2015-1137","article-title":"Sex and Gender Differences in Risk, Pathophysiology and Complications of Type 2 Diabetes Mellitus","volume":"37","author":"Harreiter","year":"2016","journal-title":"Endocr. Rev."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"1639","DOI":"10.2147\/DMSO.S222271","article-title":"Association Between Glycated Hemoglobin (HbA1c) and the Lipid Profile in Patients with Type 2 Diabetes Mellitus at a Tertiary Care Hospital: A Retrospective Study","volume":"12","author":"Alzahrani","year":"2019","journal-title":"Diabetes Metab. Syndr. Obes."},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"403","DOI":"10.2337\/diacare.22.3.403","article-title":"Racial and Ethnic Differences in Glycemic Control of Adults with Type 2 Diabetes","volume":"22","author":"Harris","year":"1999","journal-title":"Diabetes Care"},{"key":"#cr-split#-ref_24.1","unstructured":"European Union (2016). Regulation"},{"key":"#cr-split#-ref_24.2","unstructured":"(EU) 2016\/679 of the European Parliament and of the Council of 27 April 2016 on the Protection of Natural Persons with Regard to the Processing of Personal Data and on the Free Movement of Such Data (General Data Protection Regulation). Off. J. Eur. Union, L119, 1-88. Available online: https:\/\/eur-lex.europa.eu\/eli\/reg\/2016\/679\/oj."},{"key":"ref_25","doi-asserted-by":"crossref","unstructured":"World Medical Association (2013). World Medical Association Declaration of Helsinki: Ethical principles for medical research involving human subjects. JAMA, 310, 2191\u20132194.","DOI":"10.1001\/jama.2013.281053"},{"key":"ref_26","unstructured":"U.S. Department of Health & Human Services (2025, November 07). Health Insurance Portability and Accountability Act (HIPAA), Available online: https:\/\/www.hhs.gov\/hipaa\/index.html."},{"key":"ref_27","first-page":"258","article-title":"Social determinants of health and diabetes: A scientific review","volume":"44","author":"Adler","year":"2020","journal-title":"Diabetes Care"},{"key":"ref_28","doi-asserted-by":"crossref","unstructured":"Vines, A., Bologa, A.-R., and Bostan, A.-I. (2025). Enabling Intelligent Data Modeling with AI for Business Intelligence and Data Warehousing: A Data Vault Case Study. Systems, 13, Available online: https:\/\/www.mdpi.com\/2079-8954\/13\/9\/811.","DOI":"10.3390\/systems13090811"}],"container-title":["Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2079-8954\/14\/2\/155\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,2,2]],"date-time":"2026-02-02T10:15:48Z","timestamp":1770027348000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2079-8954\/14\/2\/155"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,1,31]]},"references-count":29,"journal-issue":{"issue":"2","published-online":{"date-parts":[[2026,2]]}},"alternative-id":["systems14020155"],"URL":"https:\/\/doi.org\/10.3390\/systems14020155","relation":{},"ISSN":["2079-8954"],"issn-type":[{"value":"2079-8954","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,1,31]]}}}