[ Concevoir et déployer un système analytique des ressources humaines ]
Volume 32, Issue 3, April 2021, Pages 381–400
Mohamed Baslam1, Youssef Fakir2, and Bouzekri Moustaid3
1 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
2 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
3 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
Original language: French
Copyright © 2021 ISSR Journals. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
The purpose of this article is to present a methodological approach about the construction of a decision-making system for the implementation of a number of descriptive and predictive techniques using the query tools (SQL OLAP or MDX) and the process of Data Mining. The field of human resources (HR) is chosen as an application area. This field is currently an important subject in both the business and the scientific research world. Also, Human Resource analytics (HR analytics) is one of the most important emerging and disparate technologies of HR for the coming years. Ralph Kimball's approach is used to build this system with Microsoft technologies.
Author Keywords: Data warehouse, multidimensional, data mining, Human Resource analytics, SQL Server, classification, SQL OLAP, MDX, Ralph Kimball.
Volume 32, Issue 3, April 2021, Pages 381–400
Mohamed Baslam1, Youssef Fakir2, and Bouzekri Moustaid3
1 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
2 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
3 Computer Sciences Department, University of Science and and Technics, Sultan Moulay Slimane University, Beni-Mellal, Morocco
Original language: French
Copyright © 2021 ISSR Journals. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Abstract
The purpose of this article is to present a methodological approach about the construction of a decision-making system for the implementation of a number of descriptive and predictive techniques using the query tools (SQL OLAP or MDX) and the process of Data Mining. The field of human resources (HR) is chosen as an application area. This field is currently an important subject in both the business and the scientific research world. Also, Human Resource analytics (HR analytics) is one of the most important emerging and disparate technologies of HR for the coming years. Ralph Kimball's approach is used to build this system with Microsoft technologies.
Author Keywords: Data warehouse, multidimensional, data mining, Human Resource analytics, SQL Server, classification, SQL OLAP, MDX, Ralph Kimball.
Abstract: (french)
Cet article a pour objet de présenter une démarche méthodologique pour la construction d’un système décisionnel visant la mise en application d’un certain nombre de techniques à caractère descriptive, prédictive et prévisionnel faisant recours aux outils de requête (SQL OLAP ou MDX) et au processus du Data Mining. Le domaine des ressources humaines est pris comme domaine d’application, ce qui inscrit ce travail dans la discipline de l’analytique ressources humaines. En effet, on assiste actuellement à un essor de l’analytique ressources humaines aussi bien dans le monde des entreprises qu’universitaire; où il est l’objet d’enseignements et de recherches. Aussi, ce sujet constitue l’une des technologies prometteuses émergentes et disparates les plus importantes des technologies RH pour les années à venir. L'approche de Ralph Kimball est utilisée pour la construction de ce système avec les technologies de Microsoft.
Author Keywords: Entrepôts de données, magasins de données, multidimensionnel, data mining, data warehouse, data mining, analytique, ressources humaines, SQL Server, classification, SQL OLAP, MDX, Ralph Kimball.
How to Cite this Article
Mohamed Baslam, Youssef Fakir, and Bouzekri Moustaid, “Design and deploy an analytical human resources system,” International Journal of Innovation and Applied Studies, vol. 32, no. 3, pp. 381–400, April 2021.
