Eng. Meisam Fallahnezhad, Reza Safdari,
Volume 15, Issue 3 (8-2021)
Abstract
Background and Aim: Large amounts of hospital costs are not reimbursed annually by health insurance as deductions. Therefore, reducing deductions is very important for the hospital. In the study of design and implementation of analytical dashboard of insurance deductions based on medical intelligence business, to improve financial management with the aim of focusing on assessing the level of satisfaction and its applicability has been done.
Materials and Methods: To design the questionnaire, first 27 questions were prepared through library studies and interviews with members of the hospital board of directors, and the validity and consistency of its items were determined through content validity and Cronbach’s alpha coefficient. Data were analyzed in SPSS software and the results were used to design and implement the dashboard.
Results: The study is of development-applied type. In the first phase, to determine Content Validity Ratio CVI (Content Validity Index), and CVR (Content Validity Ratio) a researcher-made questionnaire was provided to 20 experts. In the second phase, by building a data warehouse in SQL (Structured Query Language), the information of the tables related to the deductions of the hospital HIS system was transferred to it and the operational information of the organization was extracted and converted into DW format and the map information was tested. OLAP (Online Analytical Processing) services were then loaded on the created analytics database. In the last step, Power BI tool was selected and used to create business intelligence mechanisms, display and visualize information. In the third phase, using the QUIS (Questionnaire for User Interface Satisfaction) standard questionnaire, the level of satisfaction and usability of the dashboard was evaluated by 15 experts.
Conclusion: In this study, two questionnaires were used. CVR was measured in all items of the first questionnaire, more than 0.50 and CVI was measured in the upper areas of 0.90 and Cronbach’s alpha coefficient was obtained between 0.8 and 0.9, which indicated a good level. The second questionnaire was to evaluate the level of satisfaction and usability of the dashboard that the average of the total evaluation based on the indicators of the QUIS questionnaire is equal to 85.40. Therefore, the level of satisfaction and usability of the dashboard was “very good” for the evaluators.
Mrs Fatemeh Rangraz Jeddi, Ehsan Nabovati, Shima Anvari Tafti, Parisa Yousefi Konjdar,
Volume 17, Issue 5 (12-2023)
Abstract
Background and Aim: A medication dashboard could provide executive directors and managers with the ability to manage medication resources in hospitals. This study aimed to design, implement, and evaluate a medication resources management dashboard for general hospitals.
Materials and Methods: This study was of the development-applied type conducted in an academic therapeutic community center. Based on scientific sources, the dashboard’s key performance indicators (KPIs) and functional requirements were identified. The data collection tool was a questionnaire comprising demographic information, KPIs, and functional requirements. The dashboard conceptual model was designed using Rational Rose software, and then POWER BI software was used to develop the system. The usability of the dashboard was evaluated using the standard questionnaire for End User Computing Satisfaction by 10 users. The data were analyzed in SPSS software using descriptive statistics.
Results: The most important KPIs determined for a medication resources management dashboard in general hospitals were “the ratio of antibiotic consumption to total number of drugs”, “the ratio of the antibiotic prescribed by general practitioners to total number of drugs”, “the ratio of patients for whom antibiotics were prescribed to all patients”, and “the ratio of the number of drug items prescribed by specialists to all physicians”. The most important functional requirements determined were “updating information at specific intervals “, “checking the dashboard at different time intervals”, “defining access levels to view the information”, and “choosing between graphical and tabular displays”. Usability evaluation showed that users’ satisfaction with the dashboard content variable was “very high” and for the other variables was at a “high” level.
Conclusion: The KPIs associated with antibiotics and drug costs within the medication dashboard of general hospitals are high priority. Future studies should evaluate the impact of using a medication dashboard on hospital executive directors’ and managers’ decision-making.
Malihe Ghanaatjoo, Nader Jahanmehr, Dr. Hamed Dehnavi, Aida Samadi,
Volume 18, Issue 2 (5-2024)
Abstract
Background and Aim: The increase in the amount of information and the need for their daily monitoring have led to the development of tools called management dashboards that have the ability to analyze graphical data. In addition to preparing quick reports in different time frames and user-specific format, the dashboard can be useful for providing dynamic updated information for accurate decision-making and quick response to changes.
Materials and Methods: The current research was carried out in the form of qualitative studies and participatory action research method in 9 steps. In this applied and developmental research that was conducted cross-sectionally using the data of the first half of 2022, 11 members of the leadership team of a super-specialized children’s hospital were selected as research participants. The data collection tool was an interview using a questionnaire to determine the importance of indicators and a usability questionnaire (usability) of the dashboard based on three independent variables (usefulness, ease of use and satisfaction). The Excel file of data needed for the dashboard was collected from the HIS system of the hospital, and the dashboard was designed with Power BI software, and the capabilities and access levels of users were determined based on their duties. Data analysis was done using descriptive statistics and Excel software version 2016.
Results: In the stage of determining key performance indicators, out of 39 indicators selected by the research team, 22 indicators scored an average score of 4 or higher (from 5 points) and 21 indicators were able to be implemented. The data repository in Excel format was used as an intermediate environment. The dashboard was displayed on six pages (indicators related to the performance of inpatient beds, mortality, emergency and other indicators) and the capabilities of each page were determined. After implementing the dashboard and determining the access levels of users, obtaining a high score from the questions of the usability questionnaire (5 out of 7 points) and obtaining an average score of 71.8 out of 5 questions related to usefulness variables, 70.5 out of 8 questions related to ease of use. And 71 out of 3 questions related to the satisfaction variable showed that the dashboard designed for the hospital had high usability.
Conclusion: Hospital management dashboard information can be a basis for informed decision-making to achieve benefits such as identifying the best performance, improving performance quality, making faster decisions, reducing errors, improving capacity management and work flow, allocating resources and planning for growth and development.
