How to do data analysis well

Data analysis includes: classification analysis, matrix analysis, funnel analysis, correlation analysis, logical tree analysis, trend analysis, behavior trajectory analysis and so on. Taking the work of HR as an example, I explain how to do the above analysis in order to gain insight.

0 1) classification analysis

For example, the brain drain rate is analyzed by different departments, different job levels and different age groups. For example, if you find that the turnover rate of a certain department is particularly high, then you can analyze it.

02) Matrix analysis

For example, if a company has an assessment of values and abilities, it can make a matrix diagram of the assessment results to find out the proportion of employees with strong value matching, employees with weak value matching and employees with weak value matching, so as to find out the health status of talents in the company.

03) Funnel analysis

For example, recording recruitment data, submitting resumes, passing the initial screening, passing through one side, two sides, passing through the last side, accepting the Offer, successfully joining the job, and passing the probation period is a complete recruitment funnel. From the data, we can see which link can be optimized.

04) Correlation analysis

For example, the brain drain rate of each branch of the company is quite different, so we can analyze the correlation between the brain drain rate of each branch and some characteristics of the branch (geographical location, salary level, welfare level, employee age, manager age, etc.). ) find the key factors that can best retain employees.

05) logical tree analysis

For example, if employee satisfaction is found to have declined recently, it will be dismantled. Satisfaction is related to salary, welfare, career development and working atmosphere, and then salary is divided into basic salary and bonus. In this way, it will be dismantled layer by layer to find out the changing factors in the influencing factors of satisfaction, so as to get insights.

06) Trend analysis

For example, the change trend of brain drain rate in the past 12 months.

07) Behavior trajectory analysis

For example, tracking the behavior track of a salesperson, from entry, to starting to produce performance, to rapid growth of performance, to fatigue period, to gradual stability.