Your first analytics project

01The problem

Kolanut's HR manager is worried: "It feels like we keep losing people, especially in customer service. Is that true, and what should we do?"

This lesson walks through a small but complete analysis of that question. The course's final project then asks you to take it further on your own.

02The concept

A complete analysis, even a small one, has five parts. You'll produce them for the final project:

1. The question, in measurable form.
2. The data you used and anything you cleaned or excluded.
3. The analysis: the calculations and a chart or table.
4. The finding, in one or two sentences.
5. The recommendation and its limits: what the data can't tell you.

A note on small numbers. Kolanut has 80 employees. When you split them by department, some groups have only 6 or 8 people. One resignation in a group of 8 moves the rate by 12.5 percentage points. Report the counts next to the rates, and be careful about strong conclusions from small groups.

03Example

Question. Of everyone Kolanut has employed since 2018, what share has resigned, and does it differ by department?

Data. employees.csv: one row per employee, with department, job_level and status (Active or Resigned).

Analysis.

Finding. Customer Service has the highest share of resignations (3 of 8 people, 37.5%), about three times the company-wide rate. By job level, all 11 people who left were Junior or Mid level; no Senior staff or Managers resigned.

Recommendation. Hold short exit and "stay" conversations with Customer Service staff to understand why people leave, and review junior pay and workload there. Limit: these are small numbers, and the data has no reasons for leaving, so treat this as a signal to investigate, not proof.

04Walkthrough

How to produce the table above in a spreadsheet:

1. Open employees.csv in Google Sheets or Excel.
2. Insert a pivot table (Sheets: Insert → Pivot table; Excel: Insert → PivotTable).
3. Put department in Rows.
4. Put employee_id in Values, summarised by COUNTA (Sheets) or Count (Excel). That's the Staff column.
5. Put status in Columns. You now have Active and Resigned counts per department.
6. Next to the pivot, calculate Resigned ÷ Staff × 100 for each department.
7. Sort by the percentage, largest first.

05Practice

06Check your understanding

When you've finished this lesson, take the final assessment, then open the final project from the course page.