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

Abstract

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.