The Inspiration

Organisations constantly change — employees move roles, departments restructure, reporting lines shift, and new positions are created. However, this history is often scattered across spreadsheets, HR systems, and organisational charts.

We wanted to answer a simple question:

What if HR could see not just where the organisation is today, but how it got there?

This inspired us to build an Organisational History Explorer that connects organisational changes with employee movements.

How We Built It

We consolidated employee, role, department, reporting-line, and movement records, then reconstructed them into chronological events.

These events are presented through an interactive interface where HR users can explore a timeline, select a role or employee, and trace how their history connects with wider organisational changes.

Incomplete or inconsistent records are also flagged to ensure transparency and avoid misleading conclusions.

What We Learned

We learned that organisational history is more than a collection of individual records — the relationships between those records tell the bigger story.

We also discovered how important data quality is when reconstructing historical events. Missing or inconsistent information needs to be highlighted rather than hidden.

Challenges

Our biggest challenge was transforming fragmented and inconsistent HR records into a coherent timeline while keeping the interface simple enough to navigate.

We had to balance data complexity with usability, ensuring users could understand not only what changed, but also when, who was affected, and how the changes were connected.

The Outcome

Our solution turns fragmented HR records into an interactive organisational story, helping HR move beyond static records and understand how roles and people evolved together over time.

Built With

+ 7 more
Share this project:

Updates