Application of Business Intelligence in Employee Demographic and Structure: A case study at Vodafone Portugal

Abstract

The human resources sector is of fundamental importance for companies and has key indicators to boost the business. In this sense, understanding how the control of the top management team works as well as providing information by functional level and ranges, where employees are allocated. In this sense, understand how the control of the top management team works, as well as providing information by functional level and ranges, where employees are allocated. In this context, the use of dashboards in Human Resources (HR) becomes a powerful tool for data evaluation. Given this, as companies seek competitive advantage in a knowledge-oriented and technology-based economy, technological advances have expanded the potential of BI methodologies in HR management, enabling automated decision-making processes. This study, based on empirical research at Vodafone Portugal, explored how to use dashboards in Human Resources (HR) to evaluate demographic data and organizational structure through a case study highlighting the strategic importance of business intelligence (BI) in HR, using a Kimball Lifecycle methodology. To achieve the objectives of the study, exploratory and empirical approaches were adopted, following eight phases: project planning, business requirements definition, technical architecture design and dimensional modeling, physical design, ETL design and development, BI application development, deployment and maintenance. This project, aimed at evaluating the potential of business intelligence (BI) tools, specifically Power BI, in supporting data-based decision making in the HR department, was developed to meet the specific needs of supervising the conduct of this sector in the HR department. Vodafone Portugal, showed through the creation of custom dashboards and key performance indicators (KPIs) how BI solutions can provide actionable insights into employee demographics and organizational structure, thereby supporting strategic planning and company development. corporate culture.