A trajectory data warehouse solution for workforce management decision-making
In modern workforce management, the demand for new ways to maximize worker satisfaction, productivity, and security levels is endless. Workforce movement data such as those source data from an access control system can support this ongoing process with subsequent analysis. In this study, a solution...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
KeAi Communications Co. Ltd.
2023-06-01
|
| Series: | Data Science and Management |
| Subjects: | |
| Online Access: | http://www.sciencedirect.com/science/article/pii/S2666764923000103 |
| _version_ | 1797787229628661760 |
|---|---|
| author | Georgia Garani Dimitrios Tolis Ilias K. Savvas |
| author_facet | Georgia Garani Dimitrios Tolis Ilias K. Savvas |
| author_sort | Georgia Garani |
| collection | DOAJ |
| description | In modern workforce management, the demand for new ways to maximize worker satisfaction, productivity, and security levels is endless. Workforce movement data such as those source data from an access control system can support this ongoing process with subsequent analysis. In this study, a solution to attaining this goal is proposed, based on the design and implementation of a data mart as part of a dimensional trajectory data warehouse (TDW) that acts as a repository for the management of movement data. A novel methodological approach is proposed for modeling multiple spatial and temporal dimensions in a logical model. The case study presented in this paper for modeling and analyzing workforce movement data is to support human resource management decision-making and the following discussion provides a representative example of the contribution of a TDW in the process of information management and decision support systems. The entire process of exporting, cleaning, consolidating, and transforming data is implemented to achieve an appropriate format for final import. Structured query language (SQL) queries demonstrate the convenience of dimensional design for data analysis, and valuable information can be extracted from the movements of employees on company premises to manage the workforce efficiently and effectively. Visual analytics through data visualization support the analysis and facilitate decision-making and business intelligence. |
| first_indexed | 2024-03-13T01:20:00Z |
| format | Article |
| id | doaj.art-ff18a8d2518b4c00adc946cf90c728e5 |
| institution | Directory Open Access Journal |
| issn | 2666-7649 |
| language | English |
| last_indexed | 2024-03-13T01:20:00Z |
| publishDate | 2023-06-01 |
| publisher | KeAi Communications Co. Ltd. |
| record_format | Article |
| series | Data Science and Management |
| spelling | doaj.art-ff18a8d2518b4c00adc946cf90c728e52023-07-05T05:17:16ZengKeAi Communications Co. Ltd.Data Science and Management2666-76492023-06-01628897A trajectory data warehouse solution for workforce management decision-makingGeorgia Garani0Dimitrios Tolis1Ilias K. Savvas2Corresponding author.; Digital Systems Department, University of Thessaly, Larisa, 41500, GreeceDigital Systems Department, University of Thessaly, Larisa, 41500, GreeceDigital Systems Department, University of Thessaly, Larisa, 41500, GreeceIn modern workforce management, the demand for new ways to maximize worker satisfaction, productivity, and security levels is endless. Workforce movement data such as those source data from an access control system can support this ongoing process with subsequent analysis. In this study, a solution to attaining this goal is proposed, based on the design and implementation of a data mart as part of a dimensional trajectory data warehouse (TDW) that acts as a repository for the management of movement data. A novel methodological approach is proposed for modeling multiple spatial and temporal dimensions in a logical model. The case study presented in this paper for modeling and analyzing workforce movement data is to support human resource management decision-making and the following discussion provides a representative example of the contribution of a TDW in the process of information management and decision support systems. The entire process of exporting, cleaning, consolidating, and transforming data is implemented to achieve an appropriate format for final import. Structured query language (SQL) queries demonstrate the convenience of dimensional design for data analysis, and valuable information can be extracted from the movements of employees on company premises to manage the workforce efficiently and effectively. Visual analytics through data visualization support the analysis and facilitate decision-making and business intelligence.http://www.sciencedirect.com/science/article/pii/S2666764923000103Business intelligenceDecision-makingWorkforce managementTrajectory data warehouse (TDW)Moving objectSemantic modeling |
| spellingShingle | Georgia Garani Dimitrios Tolis Ilias K. Savvas A trajectory data warehouse solution for workforce management decision-making Data Science and Management Business intelligence Decision-making Workforce management Trajectory data warehouse (TDW) Moving object Semantic modeling |
| title | A trajectory data warehouse solution for workforce management decision-making |
| title_full | A trajectory data warehouse solution for workforce management decision-making |
| title_fullStr | A trajectory data warehouse solution for workforce management decision-making |
| title_full_unstemmed | A trajectory data warehouse solution for workforce management decision-making |
| title_short | A trajectory data warehouse solution for workforce management decision-making |
| title_sort | trajectory data warehouse solution for workforce management decision making |
| topic | Business intelligence Decision-making Workforce management Trajectory data warehouse (TDW) Moving object Semantic modeling |
| url | http://www.sciencedirect.com/science/article/pii/S2666764923000103 |
| work_keys_str_mv | AT georgiagarani atrajectorydatawarehousesolutionforworkforcemanagementdecisionmaking AT dimitriostolis atrajectorydatawarehousesolutionforworkforcemanagementdecisionmaking AT iliasksavvas atrajectorydatawarehousesolutionforworkforcemanagementdecisionmaking AT georgiagarani trajectorydatawarehousesolutionforworkforcemanagementdecisionmaking AT dimitriostolis trajectorydatawarehousesolutionforworkforcemanagementdecisionmaking AT iliasksavvas trajectorydatawarehousesolutionforworkforcemanagementdecisionmaking |