Interesting visualizations for a personnel in-out control

Question

I have a database with the data of all the company personnel in and out through several facilities (All people must put their fingerprint in the scanner to open doors)

I'm looking for interesting way to expose the data.

Have you worked on something similar or have a nice idea to implement?

Answer 1

My idea:

If you want to show the movement data to someone who is a bit more pragmatic, instead of using line charts, you could use a simplified map of the place.

• Each building - a rectangle
• Each person - a tiny circle/square
• Each department - a color-coded row of persons;if you want to track individuals as well, you could asign to each person a specific position in that row.
• Every building has rows for every department

Using the data you have, you take a snapshot of where everyone is every 5 minutes, and redraw the map every 5 seconds and animate the persons that move (for example from building 1 to building 3, to their respective department/rows)

Put a big clock at the top and voila, you can see:

• which department moves around the most
• which building is preffered by which department
• at what time do people move about the most etc.

I made a drawing, but: "... Earn more than 10 reputation to post images."

Edit: Here's the drawing:

Answer 2

Here's what I ended up building for now (not all the data collectors are operational)

1. A graph for the total hours worked every day of the month. Plus the average per day
2. A "Punchcard" graph showing the in/outs each hour each day of the week.
3. Two ranking showing the people that arrive at the office earlier and who worked the most (or at least stayed in the office the most :)