Identification of trends in racial/ethnic disparities of patients with diabtes mellitus using web-based tableau dashboard- a cross sectional study

Many ways of creating data visualizations using the Business Intelligence tools have been implemented and new ways are continuously evolving. In this project, I have used Tableau Public software to analyze the trends of Race and Ethnic disparities in Diabetes Mellites patients by creating individual dashboards. A desktop application was created using the web programming languages like HTML and CSS to create more interactive and application embedded dashboard. The dataset selected was Health Facts® database, which is contributed of day-to-day patient care encounters. Data preparation and data pre-processing and data visualization were the two major steps to get the required results. In Data pre-processing, data mining tools such as SQL and Python were used to create the final dataset with 7 variables. An infographic was created with a dashboard with three views embedded into web pages. These three dashboard views were created based their specific information like one dashboard view showing the insights about the distribution of Hispanic with Diabetes Mellitus, another dashboard view showing the trends of African American and Caucasian races and the third view showing the distribution of patients with Diabetes Mellitus and specific cancers based on race and ethnicity. All the data obtained were analyzed and compared with the CDC data and the results confirmed. Moreover, to measure the usability of the desktop application, SUS (System Usability Score) was used. The result of the application clearly indicated the way such application can be used strategize the programs and interventions to reduce the disparities for Diabetes Mellitus amongst the African American population

Skills and competencies in health data analytics for health professionals: a scoping review protocol

Introduction Healthcare data analytics is a methodological approach to the systematic analysis of health data, and it provides opportunities for healthcare professionals to improve health system management, patient engagement, budgeting, planning and performing evidence-based decision-making. Literature suggests that certain skills and/or competencies for health professionals working with big data in health care would be required. A review of the skills and competencies in health data analytics required by health professionals is needed to support the development or re-engineering of curriculum for health professionals to ensure they develop the abilities to make evidence-based decisions that ultimately can lead to the effective and efficient functioning of a healthcare system.Methods Using Arksey and O’Malley’s framework, this study will review literature published in English from January 2012 to December 2022. The database search includes Academic Search Complete, CINAHL, and MEDLINE via EBSCOhost, PubMed, Science Direct, Scopus, and Taylor and Francis. The reference lists of key studies will be searched to identify additional appropriate studies to include. The review will be conducted using an inclusion and exclusion criteria. Iterative processes will be involved at the various stages of search strategy piloting, screening and data extraction. Articles will be reviewed through a two-step process (title and abstract, and full-text review) by at least two reviewers. Data will be described quantitatively and/or qualitatively and presented in diagrams and tables.Ethics and dissemination Ethical clearance has been received, and strict protocol measures will be followed to ensure the data reported is of quality and relevant to the review purpose. The results will be disseminated through a peer-reviewed scientific journal, presentation at national and/or international conferences, and other platforms such as social media (eg, LinkedIn, Twitter), and relevant stakeholders