How to realize human resource visualization management with BI

With the deepening of the reform of communication industry, the development situation and living environment of the industry are changing greatly, the boundary of communication and information becomes more and more blurred, and the market competition becomes more and more fierce. In recent years, a communication operator in the transformation of the business, the transformation of the network has made a huge breakthrough, but the pace of human resources management transformation is relatively slow, has been to some extent, has become the impact of enterprise transformation and refinement of management of the short board.

Human resources as the core competitiveness of enterprises, is the first resource of enterprises. A domestic telecom giant, in the system already has the department, the position, the personnel and so on unified, the complete structure information; Business systems and business processes are also rich in a large number of personnel information, but for the human sector, the company personnel, posts, salaries, KPIs and other resources to adjust the guidance has no actual visual reference, Many adjustments still rely on artificial judgment, artificial operation to complete, long-term past to the company's human resources allocation has brought many adverse effects.

Facing challenges:

1, data correlation degree is not enough, the data island is obvious

The company itself has a very rich EHR system, but the group itself also has a variety of other applications (business, billing, accounting, network management, monitoring), although these system functions are independent, but the data between them is inevitably associated. To make a global analysis of the data of human resources, it is necessary to integrate the interrelated data, but it can not expend too much effort to affect the project progress.

2, the Human resources department requires a higher degree of freedom of business analysis

The Human resources department's business involves the personnel's reseaving, namely the personnel recruitment, the selection, the training, the salary welfare, the appraisal and so on, the business thread is many, crosses many. We hope to make use of integrated data, more convenient and more timely analysis of multi-dimensional, free drilling, dimensional analysis, without relying too much on the information sector.

3, rapid integration implementation, put into operation

It is hoped that the BI visual analysis system of human resources can be successfully launched in the short term to assist the analysis decision of human resources.

Sail Soft Finebi Solution:

1, data integration, provide a clear view of human resources data

Business Intelligence Solutions Finebi can create a data warehouse that transforms all relevant data in an enterprise into ETL, data cleansing and data warehousing, and a comprehensive view of the business of the analyst and decision-makers, with which analysts and decision makers can easily perform instant business intelligence analysis.

Project personnel with the help of Finebi data extraction, cleaning tools Fineetl, the original system of structured and unstructured data integration into the analysis needs of business data package, data classification management, for the subsequent business analysis laid a clear data structure and foundation.

ETL Cleaning Example diagram:

2. Visual Multidimensional Analysis of drag-and-drop operation to enhance the self-help analysis ability of human Resource department

Multidimensional OLAP analysis, can ensure that users immediately see their analysis needs corresponding data statistics, and by switching dimensions and changing conditions, etc., easily get different analysis results under different dimensions, the business situation has a more comprehensive and objective understanding. And through a variety of common OLAP analysis operations, in addition to the basic group summary, but also can be any multi-dimensional analysis, multi-calculation indicators, filtering, linkage, drilling and re-dimension, multiplexing, data early warning and other analytical functions.

Multidimensional Analysis Operation example, drag data column, select calculation indicator, filter condition, complete visualization operation:

Human resources department, according to the needs of personnel, age, post sequence, salary, education and so on the correlation between the cross-analysis, to obtain the necessary argumentation conclusions.

Person-to-account analysis:

Real-time monitoring of employee changes and additions:

3, very short implementation cycle, on-line cycle in week units

In view of the short project period proposed, Finebi does not need a lot of SQL in data processing, and classifies and manages the data through visual ETL and New cube. The steps to establish the analysis do not need to be modeled, all of which are visualized, to some extent reducing the communication costs associated with changes in demand. After the system is on-line, there is no need to devote much effort to provide maintenance and data support to minimize the human and material cost of the enterprise.

How to realize human resource visualization management with BI