Workdiamond2020

Improve HR Decision-Making Based On Data Mart and OLAP

Alaa Khalaf Hamoud · Maysaa Abd Ulkareem Naser · Hisham Noori Hussain · Zahraa Abdulkareem Mohammed · Gadeer Mustafa Salih

15 citations0/0 files storedJournal of Physics Conference Series

No readable copy stored yet — this record is metadata only.

No open-access location is known for this record yet.

Literature note Cite in a project Citation map

Big Data and Business Intelligence Decision Support System Applications AI and HR Technologies

Abstract

Abstract The organizations always need to manage their operations, process the data electronically, and find a platform that help them to support their strategic decisions. The success of the human resource department can reflect overall organizational success. The human resource department professionals try to ensure finding the right person at the right time for the job that fits the person according to skills and qualifications. This task needs a platform that supports making the right decision based on historical managerial information. The data mart is a departmental based decision support system that used departmental data to help decision-makers to support short term decisions. Human resource (HR) data mart is the base stone for building an enterprise data warehouse. The paper presents the implementation process of HR data mart starting from implementing data mart schema to online analytical processing (OLAP) reports. The data mart is implemented on retired employees’ data of Basra Oil Company for over 15 years. A human resource data mart can provide a base platform to perform a different analysis operation to support the right decisions. Different OLAP reports are implemented to help analysts and decision-makers to get the answers for their questions as OLAP queries. Two categories of reports are implemented offline reports using Microsoft Excel Pivot Table 2010 and web OLAP reports using SQL Server Reporting Service 2014 (SSRS). The tools used to implement data mart vary from SQL Server Management Services (SSMS) 2014, SQL Server Integration Service 2014 (SSIS), SQL Server Analytical Service 2014 (SSAS), SQL Server Reporting Service 2014 (SSRS), SQL Server Data Tools 2013 (SSDT), and Microsoft Excel Pivot Table 2010.

Paper brief

Loading…

Cite this work

Citation unavailable for this work.

BibTeX RIS CSL-JSON

No public copy is stored for this record, so only the metadata is cited.

Citations in this library

Citation map →

Stored only when both papers are in the corpus — 15 citations exist upstream.

References

2008Building a Data Warehouse 1998Building the data warehouse 2013The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 1998The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses 2005Integrated decision support systems: A data warehousing perspective 2001Designing data marts for data warehouses 1999starER 2012Domain driven data mining in human resource management: A review of current research

Cited by

2022The levels of artificial intelligence application in human resource systems 2024Moderating the role of cybernetic controls on data accuracy and decision-making in accounting information systems in construction projects in Iraq

Explore the map →

Papers that cite the same references — the relational fallback while embeddings are still backfilling.

Imported from OpenAlex (CC0) — nothing here is generated.