Case Study: New data perspectives

The six steps of the data analysis process that you have been learning in this program are:

  • ask
  • prepare
  • process
  • analyze
  • share
  • act

These six steps apply to any data analysis. Continue reading to learn how a team of people analysts used these six steps to answer a business question.

The analysts used the data analysis process to answer the following question: how can the organization improve the retention rate for new employees?

Ask

First up, the analysts needed to define what the project would look like and what would qualify as a successful result.

So, to determine these things, they asked effective questions and collaborated with leaders and managers who were interested in the outcome of their people analysis. These were the kinds of questions they asked:

  • Have you gathered data from new employees before? If so, may we have access to the historical data?

  • Do you believe managers with higher retention rates offer new employees something extra or unique?

  • By what percentage would you like employee retention to increase in the next fiscal year?

Prepare

The group built a timeline of three months and decided how they wanted to relay their progress to interested parties.

Also during this step, the analysts identified what data they needed to achieve the successful result they identified in the previous step.

In this case, the analysts chose to gather the data from an online survey of new employees. These were the things they did to prepare:

  • They developed specific questions to ask about employee satisfaction with different business processes, such as hiring and onboarding, and their overall compensation.

  • They established rules for who would have access to the data collected - in this case, anyone outside the group wouldn't have access to the raw data, but could view summarized or aggregated data.

  • They finalized what specific information would be gathered, and how best to present the data visually. The analysts brainstormed possible project- and data-related issues and how to avoid them.

Process

The group sent the survey out. Great analysts know how to respect both their data and the people who provide it.

The data analysts also made sure employees understood how their data would be collected, stored, managed, and protected. Collecting and using data ethically is one of the responsibilities of data analysts.

In order to maintain confidentiality and protect and store the data effectively, these were the steps they took:

  • They restricted access to the data to a limited number of analysts.

  • They cleaned the data to make sure it was complete, correct, and relevant. Certain data was aggregated and summarized without revealing individual responses.

  • They uploaded raw data to an internal data warehouse for an additional layer of security.

Analyze

From the completed surveys, the data analysts discovered that an employee’s experience with certain processes was a key indicator of overall job satisfaction. These were their findings:

  • Employees who experienced a long and complicated hiring process were most likely to leave the company.

  • Employees who experienced an efficient and transparent evaluation and feedback process were most likely to remain with the company.

The group knew it was important to document exactly what they found in the analysis, no matter what the results. To do otherwise would diminish trust in the survey process and reduce their ability to collect truthful data from employees in the future.

Share

Just as they made sure the data was carefully protected, the analysts were also careful sharing the report. This is how they shared their findings:

  • They presented the results to the managers to make sure they had the full picture.

  • They asked the managers to personally deliver the results to their teams.

This process gave managers an opportunity to communicate the results with the right context. As a result, they could have productive team conversations about next steps to improve employee engagement.

Act

The last stage of the process for the team of analysts was to work with leaders within their company and decide how best to implement changes and take actions based on the findings. These were their recommendations:

  • Standardize the hiring and evaluation process for employees based on the most efficient and transparent practices.

  • Conduct the same survey annually and compare results with those from the previous year.

Summary

  1. Ask: The analysts asked questions to define both the issue to be solved and what would equal a successful result.

  2. Prepare: They prepared by building a timeline and collecting data with employee surveys that were designed to be inclusive.

  3. Process: They processed the data by cleaning it to make sure it was complete, correct, relevant, and free of errors and outliers.

  4. Analyze: They analyzed the clean employee survey data.

  5. Share: They shared their findings and recommendations with team leaders.

  6. Act: Leadership acted on the results and focused on improving key areas.