work / reporting / company relationship map

See how the whole company connects.

Leadership had no way to see how people, teams and work actually connected. I built an interactive relationship map from the ticketing data that shows who assigns, assists and comments on what, across the whole company.

role
Sole developer
client
Philippine automation agency
status
Used in every leadership meeting

Languages

PythonHTML5CSS

Tools & platforms

Django

AI & LLM

to build it
ChatGPT

Skills

Data modelingGraph visualizationBackend development
01// how I approached it

The thinking behind it

  1. 01 · What I noticed

    Leadership kept asking who works with whom, and the answer was buried in ticket history.

  2. 02 · What I decided

    Turn real ticket activity into a live map instead of drawing an org chart by hand.

  3. 03 · What I delivered

    A relationship map used in every leadership meeting.

02// old vs new

Old system vs new system

Old systempeople as the glue
  1. Dig through ticket history
  2. Ask around
  3. Sketch it on a whiteboard
New systemthe system does the work
  1. Ticket data pulled in
  2. Links built between people and teams
  3. Leadership explores the live map
03// how it works

Watch it run

Click through the four steps. In step 3, click any box to see what it does.

synthetic data · no client screens
Reconstruction with synthetic data · no client screens
04// the hard part

Making a busy company readable at a glance.

Ticket history held the answer to "who works with whom", but nobody could read it. The map turns real activity (assignments, help and comments) into links between people and teams that leadership can explore in a meeting.

05// key decisions

Why it's built this way

decision 1

Built from real ticket data

Connections come from actual work, not a hand-drawn org chart.

Trade-off: only shows what is in the tickets.
decision 2

People and teams together

Teams group people so overlaps are easy to spot.

Trade-off: more to show on one screen.
decision 3

Made for meetings

Simple enough to explore live with leadership.

Trade-off: less detail than a full report.