While looking for Paul Revere, I recently learned that you can define many-to-many database relationships in Tableau. I should not have been surprised, Tableau seems to do most things well. It should wear a cape all the time.
Anyways… before I forget, here how to to define a many-to-many database relationship in Tableau.
First, lets define the domain for this exercise. Lets say we have three tables, one for person (PERSON), one for organization (ORG), and an association table defining each persons membership into an organization (ORGPERSON). Each person can belong to none, one or many organizations and, of course, an organization can have any number of members as well.
Here is how this would look in a database:
I am coming from this Reddit post and from here… This post exists solely because I too wanted to find Paul Revere. I am not even going to use ‘big data’. Mainly because this data is not big, I do not have a graph database and because I think it would be fun to see what plain old SQL and Tableau can show us. For truly insightful posts, just visit Kieran Healy, the author of the original post instead.
Kieran makes a very compelling argument on what is possible for surveillance programs the general population may (or not) understand. His post is really fascinating. Follow along and you can learn to monitor your citizens as well.
Heck, I bet you could build your own surveillance network with freely available online services. Imagine what you could cook up with Google Alerts, Amazon S3, IFTTT and a bit of time!