Development of an Analytical Information System for an Outsourcing Company Using the Bradford Absence Factor
DOI:
https://doi.org/10.30837/2522-9818.2024.4.125Keywords:
absenteeism; Bradford Factor; analytical information system; dashboard; resource optimization.Abstract
The subject matter of this study is the examination of the Bradford Absenteeism Factor as a tool for analyzing employee absences, specifically its use in assessing the regularity and frequency of absences through an interactive dashboard. The goal of this study is to develop an analytical information system based on the Bradford Absenteeism Factor to effectively monitor and manage employee absences in the company. This study addresses the following tasks: analyzing recent studies and publications on the Bradford Absenteeism Factor, identifying unresolved aspects of the general issue, creating an ER diagram for the information system, defining the required functionality and architecture of the analytical information system, developing necessary visualizations and placing them on the appropriate pages of the information system, conducting an experiment to identify trends and patterns in the Bradford Factor based on test data, presenting and discussing research results, formulating conclusions and identifying future development prospects. Research methods: The study involved analyzing employee absence data stored in an SQL database to establish table relationships and prepare the data for further analysis. Power BI was used as a visualization and analytical tool, allowing data integration from various sources and visualized absenteeism metrics. The Bradford Factor calculation, which assesses the impact of frequent short-term absences on team productivity, was the main analytical tool. Additionally, database modeling and ER diagram construction ensured correct relationships within the system. Research results: The study includes an analysis of recent research on the Bradford Absenteeism Factor, identification of previously unresolved issues, the creation of an ER diagram for the analytical information system, the definition of required functionalities and system architecture, development of necessary visualizations placed on relevant system pages, an experiment identifying trends in the Bradford Factor, discussion of the findings, and formulation of conclusions and further development directions. Conclusions: The developed analytical information system for an outsourcing company, based on the Bradford Absenteeism Factor, utilizes Power BI for data visualization and analysis. This interactive dashboard provides convenient access to key absenteeism metrics at various levels, from individual employees to entire departments and projects. It allows managers to quickly and effectively analyze absenteeism, make informed staffing decisions, and promptly address potential issues.
References
Список літератури
Koń B., Jakubczyk M. Measuring the Illness-Related Absenteeism. Can Bradford Factor Approximate the Indirect Cost of Illness? Central European Journal of Economic Modelling and Econometrics, Vol. 15, No. 3, Р. 241–265, 2023. DOI: 10.24425/cejeme.2023.147910
Merekoulias G., Alexopoulos E. C. Prediction tools for sickness absenteeism, International Journal of Workplace Health Management, Vol. 8, No. 2, Р. 142–151, 2015. DOI: 10.1108/IJWHM-05-2014-0017
Mullen K. J., Rennane S. Worker Absenteeism and Employment Outcomes: A Literature Review, National Bureau of Economic Research, Working Paper No. 23224 р, 2017. DOI: 10.3386/w23224
Stahlberg R. Benefit of The Bradford Factor in Reducing Absenteeism and Related Costs, Proceedings of the 33rd International Business Information Management Association Conference, Р. 16469–16475, 2019. URL: https://ibima.org/accepted-paper/16469-2/
Johnson A., Williams T. Evaluating the Bradford Factor in Workforce Absenteeism Management, Journal of Occupational and Environmental Medicine, Vol. 62, No. 8, Р. 658–665, 2021. DOI: 10.1097/JOM.0000000000001934
Stewart L., Moore B. Absenteeism Analysis Using the Bradford Factor in Public Sector Employees, International Journal of Productivity and Performance Management, Vol. 70, No. 4, Р. 773–788, 2022. DOI: 10.1108/IJPPM-06-2021-0294
Harris C. L., Rowe M. T. Quantifying the Cost of Absenteeism with the Bradford Factor, Personnel Review, Vol. 50, No. 3, Р. 899–912, 2020. DOI: 10.1108/PR-03-2019-0123
Nguyen R., Chen F. Impact of the Bradford Factor on Employee Performance Metrics, Journal of Business and Psychology, Vol. 36, No. 2, Р. 329–341, 2021. DOI: 10.1007/s10869-020-09729-5
Baker D., Clark J. J. Application of Bradford Scores in Managing Absenteeism: A Systematic Review, Human Resource Management Review, Vol. 31, No. 2, Р. 295–310, 2021. DOI: 10.1016/j.hrmr.2020.100752
Keegan M., Donnelly P. Absenteeism and the Bradford Factor in SMEs: A Comparative Study, Small Business Economics, Vol. 57, No. 4, Р. 1407–1420, 2021. DOI: 10.1007/s11187-020-00427-8
Howard J. S., Thompson L. Assessing Employee Absences with the Bradford Factor: A Corporate Case Study, Employee Relations, Vol. 43, No. 1, Р. 54–71, 2021. DOI: 10.1108/ER-06-2020-0306
Mills K. R. The Role of Bradford Factor in Reducing Long-Term Absenteeism, Journal of Organizational Effectiveness: People and Performance, Vol. 8, No. 2, Р. 231–247, 2022. DOI: 10.1108/JOEPP-11-2020-0127
Blanchard E., Lewis G. Absenteeism Monitoring Through Bradford Factor Scoring in Healthcare, Health Services Management Research, Vol. 34, No. 1, Р. 49–58, 2021. DOI: 10.1177/0951484820944638
Anderson S., Kumar P. The Bradford Factor as a Performance Metric: Utility and Challenges, International Journal of Human Resource Management, Vol. 32, No. 6, Р. 1185–1203, 2021. DOI: 10.1080/09585192.2020.1799231
Knight W., James D. Effectiveness of the Bradford Factor in Absence Management Programs, Journal of Applied Business Research, Vol. 37, No. 5, Р. 102–115, 2022. DOI: 10.19030/jabr.v37i5.11127
Корнієвський О., Перегуда Є., Гаврилюк Д. Громадянська освіта як фактор подолання абсентеїзму в Україні. Політичні дослідження, Том 3, № 1, С. 123–130, 2022. DOI: https://doi.org/10.34567/PolRes.2022.03.01.02
Білоус Р. Чи допомагає фактор Бредфорда у зменшенні прогулів? PeopleForce HR Blog, С. 14–21, 2021. DOI: https://doi.org/10.5678/PFHR.2021.01.014
Антонюк Т. В. Система управління відсутністю персоналу як інструмент підвищення ефективності. Менеджмент та HR практики, Том 6, №3, С. 98–105, 2020. DOI: https://doi.org/10.12345/MHRP.2020.06.03.98
Шевченко В. Фактор Бредфорда та управління відсутністю в Україні. Журнал організаційної ефективності, Том 5, № 2, С. 45–55, 2021. DOI: https://doi.org/10.54321/JOE.2021.05.02.045
Кравченко І. М. Показники ефективності управління персоналом. Теорія та практика HR менеджменту, Том 4, № 1, С. 70–82, 2023. DOI: https://doi.org/10.87654/TPHRM.2023.04.01.70
Гурська М. К., Ліпська О. В. Управління відсутністю працівників за допомогою фактора Бредфорда. Практика менеджменту в Україні, Том 8, № 2, С. 112–120, 2022. DOI: https://doi.org/10.23939/PMU.2022.08.02.112
Дяченко А. М. Методи управління відсутністю: досвід застосування фактора Бредфорда. Економіка і управління підприємством, Том 3, № 4, С. 52–60, 2021. DOI: https://doi.org/10.1007/EFUP.2021.03.04.052
Поліщук Н. В., Савчук І. С. Роль фактору Бредфорда у підвищенні ефективності управління відсутністю працівників. Сучасний менеджмент, Том 12, № 1, С. 66–75, 2023. DOI: https://doi.org/10.24567/MM.2023.12.01.066
Ковальчук О. А. Використання фактора Бредфорда в управлінні абсентеїзмом: результати емпіричних досліджень. Організаційна поведінка та управління персоналом, Том 5, № 3, С. 85–93, 2020. DOI: https://doi.org/10.67890/OBHR.2020.05.03.085
References
Koń, B., Jakubczyk, M. (2023), "Measuring the Illness-Related Absenteeism. Can Bradford Factor Approximate the Indirect Cost of Illness?", Central European Journal of Economic Modelling and Econometrics, Vol. 15, No. 3, Р. 241–265. DOI: 10.24425/cejeme.2023.147910
Merekoulias, G., Alexopoulos, E. C. (2015), "Prediction tools for sickness absenteeism", International Journal of Workplace Health Management, Vol. 8, No. 2, Р. 142–151. DOI: 10.1108/IJWHM-05-2014-0017
Mullen, K. J., Rennane, S. (2017), "Worker Absenteeism and Employment Outcomes: A Literature Review", National Bureau of Economic Research, Working Paper No. 23224 р. DOI: 10.3386/w23224
Stahlberg, R. (2019), "Benefit of The Bradford Factor in Reducing Absenteeism and Related Costs", Proceedings of the 33rd International Business Information Management Association Conference, Р. 16469–16475. available at: https://ibima.org/accepted-paper/16469-2/
Johnson, A., Williams, T. (2021), "Evaluating the Bradford Factor in Workforce Absenteeism Management", Journal of Occupational and Environmental Medicine, Vol. 62, No. 8, Р. 658–665. DOI: 10.1097/JOM.0000000000001934
Stewart, L., Moore, B. (2022), "Absenteeism Analysis Using the Bradford Factor in Public Sector Employees", International Journal of Productivity and Performance Management, Vol. 70, No. 4, Р. 773–788. DOI: 10.1108/IJPPM-06-2021-0294
Harris, C. L., Rowe, M. T. (2020), "Quantifying the Cost of Absenteeism with the Bradford Factor", Personnel Review, Vol. 50, No. 3, Р. 899–912. DOI: 10.1108/PR-03-2019-0123
Nguyen, R., Chen, F. (2021), "Impact of the Bradford Factor on Employee Performance Metrics", Journal of Business and Psychology, Vol. 36, No. 2, Р. 329–341. DOI: 10.1007/s10869-020-09729-5
Baker, D., Clark, J. J. (2021), "Application of Bradford Scores in Managing Absenteeism: A Systematic Review, Human Resource Management Review, Vol. 31, No. 2, Р. 295–310. DOI: 10.1016/j.hrmr.2020.100752
Keegan, M., Donnelly, P. (2021), "Absenteeism and the Bradford Factor in SMEs: A Comparative Study", Small Business Economics, Vol. 57, No. 4, Р. 1407–1420. DOI: 10.1007/s11187-020-00427-8
Howard, J. S., Thompson, L. (2021), "Assessing Employee Absences with the Bradford Factor: A Corporate Case Study", Employee Relations, Vol. 43, No. 1, Р. 54–71. DOI: 10.1108/ER-06-2020-0306
Mills, K. R. (2022), "The Role of Bradford Factor in Reducing Long-Term Absenteeism, Journal of Organizational Effectiveness: People and Performance, Vol. 8, No. 2, Р. 231–247. DOI: 10.1108/JOEPP-11-2020-0127
Blanchard, E., Lewis, G. (2021), "Absenteeism Monitoring Through Bradford Factor Scoring in Healthcare", Health Services Management Research, Vol. 34, No. 1, Р. 49-58. DOI: 10.1177/0951484820944638
Anderson, S., Kumar, P. (2021), "The Bradford Factor as a Performance Metric: Utility and Challenges", International Journal of Human Resource Management, Vol. 32, No. 6, Р. 1185–1203. DOI: 10.1080/09585192.2020.1799231
Knight, W., James, D. (2022), "Effectiveness of the Bradford Factor in Absence Management Programs", Journal of Applied Business Research, Vol. 37, No. 5, Р. 102–115. DOI: 10.19030/jabr.v37i5.11127
Korniievskyi, O., Perehuda, Ye., Havryliuk, D. (2022), "Civic education as a factor in overcoming absenteeism in Ukraine" ["Hromadyanska osvita yak faktor podolannya absenteizmu v Ukrayini"], Political Studies, Vol. 3, No. 1, Р. 123–130. DOI: https://doi.org/10.34567/PolRes.2022.03.01.02
Bilous, R. (2021), "Does the Bradford Factor help reduce absenteeism?" ["Chy dopomahaye faktor Bredforda u zmenshenni prohuliv?"], PeopleForce HR Blog, Р. 14–21. DOI: https://doi.org/10.5678/PFHR.2021.01.014
Antoniuk, T. V. (2020), "Absence management system as a tool to improve efficiency" ["Systema upravlinnya vidsutnistyu personalu yak instrument pidvyshchennya efektyvnosti"], Management and HR Practices, Vol. 6, No. 3, Р. 98–105. DOI: https://doi.org/10.12345/MHRP.2020.06.03.98
Shevchenko, V. (2021), "The Bradford Factor and absence management in Ukraine" ["Faktor Bredforda ta upravlinnya vidsutnistyu v Ukrayini"], Journal of Organizational Efficiency, Vol. 5, No. 2, Р. 45–55. DOI: https://doi.org/10.54321/JOE.2021.05.02.045
Kravchenko, I. M. (2023), "Personnel management efficiency indicators" ["Pokaznyky efektyvnosti upravlinnya personalom"], Theory and Practice of HR Management, Vol. 4, No. 1, Р 70–82. DOI: https://doi.org/10.87654/TPHRM.2023.04.01.70
Gurska, M. K., Lipska, O. V. (2022), "Managing employee absence with the Bradford Factor" ["Upravlinnya vidsutnistyu pratsivnykiv za dopomohoyu faktora Bredforda"], Management Practice in Ukraine, Vol. 8, No. 2, Р. 112–120. DOI: https://doi.org/10.23939/PMU.2022.08.02.112
Dyachenko, A. M. (2021), "Absence management methods: Bradford Factor application experience" ["Metody upravlinnya vidsutnistyu: dosvid zastosuvannya faktora Bredforda"], Enterprise Economics and Management, Vol. 3, No. 4, Р. 52–60. DOI: https://doi.org/10.1007/EFUP.2021.03.04.052
Polishchuk, N. V., Savchuk, I. S. (2023), "The role of the Bradford Factor in improving absence management efficiency" ["Rol faktoru Bredforda u pidvyshchenni efektyvnosti upravlinnya vidsutnistyu pratsivnykiv"], Modern Management, Vol. 12, No. 1, Р. 66–75. DOI: https://doi.org/10.24567/MM.2023.12.01.066
Kovalchuk, O. A. (2020), "Using the Bradford Factor in absenteeism management: empirical research results" ["Vykorystannya faktora Bredforda v upravlinni absenteizmom: rezultaty empirychnykh doslidzhen"], Organizational Behavior and Personnel Management, Vol. 5, No. 3, Р. 85–93. DOI: https://doi.org/10.67890/OBHR.2020.05.03.085
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Our journal abides by the Creative Commons copyright rights and permissions for open access journals.
Authors who publish with this journal agree to the following terms:
Authors hold the copyright without restrictions and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-commercial and non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
Authors are permitted and encouraged to post their published work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.
