Skip to content
Sana.
All projects
ProfessionalCompleted

AI-assisted data analysis

Cleaning and evaluating Excel data with Codex.

Abstract illustration: scattered dots flowing into a tidy grid

About the project

The starting point were Excel files that had grown over a long period. Over the years they had been extended again and again, so that in the end they were hard to evaluate and every key figure meant a lot of manual work. I took on this data and cleaned it up with the help of Codex before evaluating it.

In the course of this I built new evaluation tables and reworked existing ones so that they are easier to maintain. Since then, HR key figures have been available faster and are more reliable than before, because less has to be put together by hand.

Goal

Get faster and more reliable HR key figures out of grown Excel data.

Results

  • New evaluation tables created and existing ones improved.
  • A basis for faster and more reliable HR key figures.