I was in a bar making a list of friends I'd lost touch with and, inspired by Garofalo's Genealogy of Pop/Rock Music chart, I started sketching a chart of my friends over time. A little odd I agree, but for sure its an interesting way of showing a pattern in something that you don't usually see patterns in. Goes to show that even in areas where there doesn't appear to be any 'data', there is plenty there if you choose to look for it!

I got home and knocked out some quick charts in Excel. Here's the top-level view by 'source' of friend:
You'll see that I sadly haven't kept in touch with my school friends very well. They are on my call list for the next couple of months! University provided the most friends. And I'd say that the decent tail on the blue blob means that I've done a pretty good job of keeping up with them. Doing this helped me make a list of people I unfortunately haven't kept in touch with, though.

Here's the friend-level chart that created the top-level version:
This is comprised of actual friend-level data. I'm not going to label this version, because I KNOW I've missed people. This was done in a rush. But here it is, FYI. Please don't try to work out who is who, since some small categories are combined even here!

Finally, here's the chart that inspired me. Pretty impressive stuff!

Posted by
Labels: charts friends
3

View comments

  1. This is really interesting David. I've been planning on doing something like this for a while. I'm afraid that since getting married almost all my friend blocks have tailed off nearly to zero... New Years resolution is to be a little less loved up make more time for friends! What was the raw date you used for this, your own guestimates at the amount of time you'd spent with different friends or were you able to use quantify number/length of emails, calls and face-time? (that would be a bit geeky, but its something I've always wondered about doing as the number of my friends increases with time and the amount of free time I have decreases - one has to ratio and prioritise, however inhuman that might sound!)

    ReplyDelete

  2. I manually put numbers between 1 and 5 in a spreadsheet for each friend for each quarter over the period. It only took, perhaps an hour. The blank spreadsheet is up here http://beglen.googlepages.com/070105friendsdiagramBLANK.xls.

    If all email accounts were consolidated it would be possable to automate something to do this. And I used to do it be call length and by number of smss when Orange used to spit out csv files. And when I wansn't as busy at work :)

    But that all leaves the most important one: face time. So I think doing it manually is the only way to get a good answer out.

    ReplyDelete

  3. Yeah, I remember you doing that at NPC!

    I've been thinking for years that someone should create a some friendship management software, a lighter version of corporate Client Mananagements systems. It could import and sort data from phones and emails (weighing them by length and by recipients - e.g. long individual emails counting more than mass forwards to groups) and take in appointment data from your calender as well to estimate face time, as well as allowing you to add in data manually of course....

    ReplyDelete

  2. I gave a talk at the Big Data Insight Group in London recently and they've just posted my talk online.


    I talk about how we've helped EMI Music make use of data and about how we're doing so in zeebox.

    One of the themes throughout my talk is the importance of people. Both in terms of how we use data to help people make decisions and about how we need to understand the people we're trying to help, in order to give them what we need. Technology enables this, but without the right people and without understanding people, technology is as good as useless.


    I also talk about how important skills and judgement are. And that, although it's sometimes seen as the things that drives decisions, it's usually or perhaps always used alongside skills and judgement. 


    I think that admitting to the role of skills and judgement isn't being 'anti-data'. I think that being honest about this enables and empowers us to better use data in the right ways. And it certainly helps people to feel comfortable with data, also!

    With the right people in place and data playing the right role in an organisation, the opportunity for data to help an organisation is massive. The way that EMI Music has embraced data across the organisation alongside skills and judgement shows that this is the case.


    Posted by
    0

    Add a comment

  3. We all know there are decisions where you need data to help you make them and there are decisions where data just isn't that important. This morning XKCD did a wonderful job of illustrating it. http://xkcd.com/1036/

    Buying a lamp is a creative decision. Turn your eye away from the reviews and go with your heart :)

    The same is true of many decisions data folks are asked to help with every day in organisations. We shouldn't be afraid to champion this strategy there, either!

    Posted by
    0

    Add a comment

  4. We sat down recently to talk data and insight. Here is what we talked about, plus a little video of me talking about insight at both zeebox and EMI.

    http://www.thebigdatainsightgroup.com/site/article/david-boyle-emi-zeebox-data-driven-includes-video
    Posted by
    0

    Add a comment

  5. I don't like the term 'scientist' as it makes the role sound unaccessible and elite. Google's Hal Varian said "the sexy job in the next ten years will be statisticians" ... but I don't like that term either. I'd replace 'statisticians' with 'working with data' or something ... and then I believe it!  I think data people have a tendency to overplay the role of the 'statistics' and magic of it and underplay the importance of the 'bringing it to life' and 'helping people understand / make use of it' parts of working with data.

    I thought about this because of this cool article in The Guardian about data scientists.

    As it points out, "science" is defined as "systematic study of natural or physical phenomena". I guess that's us all. Perhaps I shouldn't shy away from that phrase.

    The journalist describes the role well, as "someone who can bridge the raw data and the analysis - and make it accessible. It's a democratising role; by bringing the data to the people, you make the world just a little bit better." Perfect, eh?

    One last quote: "the four qualities of a great data scientist are creativity, tenacity, curiosity, and deep technical skills." That list sounds pretty good to me, also. So perhaps I should rename this the 'data scientist' blog and be done :)



    Posted by
    0

    Add a comment

  6. Some fun from http://fosslien.com/ via http://www.freakonomics.com/2012/02/29/the-life-of-the-number-crunching-analyst/


    I particularly like this one:

    Posted by
    Labels: charts
    0

    Add a comment

  7. So much data, so easily displayed in such a small but easy to understand format. I need say no more. I'm in love with the new sparlklines just made available in Google Spreadsheets: http://support.google.com/docs/bin/answer.py?hl=en&answer=2371371


    It's this simple:

    Google Spreadsheets is rapidly becoming my go to choice for building business dashboards. Bye, bye cost. Bye, bye developers (would be VERY sad not to work with them, of course). Bye, bye Microsoft!

    Posted by
    Labels: charts Google sparklines
    6

    View comments


  8. I spoke on a panel last night on the subject 'data as the new black gold'. There are three challenges I think this metaphor poses to the data world.







    First, that of crude oil. Data is everywhere in organisations, but too often left in it's crude form: gloopy and unusable. The oil industry had to work this out before it could be mainstream. It had to refine oil to a form that works for consumers day-to-day and it had to make it available to consumers in ways that fitted in to their daily life. It's trivial to stop by a petrol station and pick up some oil in a format you can instantly make use of. Data doesn't yet work the same way: it's rare to find an organisation that appropriately refines it and then makes it available to it's people in a way they can access and make use of as part of their day-to-day work.


    Second, I think we need to demand higher 'miles per gallon' from our data. Often we gather fantastic raw data, capable of being a really powerful part of decision making ... but then business leaders don't ask interesting questions of it. They don't demand smart analysis and challenge the data to offer insight. It's like demanding that cars offer higher miles per gallon from the oil they are burning.


    Finally, I think we need to embrace hybrid technology. In cars that's about oil being only part of the story for how the car gets powered. In data it's about saying that data is only part of the story for how organisations get powered. We need to be honest and bold about the role of skills & judgement alongside data in powering organisations. Too many people believe / pretend that data alone can power organisations to greatness. Everything I've seen tells me that data is necessary but not sufficient: smart people to use the data alongside their expertise is ALWAYS required. The data world should be honest about this and build data and systems around that truth. I've always found that has a much greater impact :)
    Posted by
    0

    Add a comment

  9. I've used a lot of word clouds recently. But I think of them as charts really, since they are still pretty faithful to the underlying data. The size of the word is proportional to the number of times that word is in the data set. Simple.

    But reading a cool data visualization book I came across this. Really it not based on 'data', but it's interesting his words and their location on the page conveys such a lot of information. Perhaps some good, well placed words can replace the need to chart actual data?

    http://creativeroots.org/2011/03/italy-infographic-map/
    Posted by
    0

    Add a comment

  10. Simple, easy to read, but really powerful. Nice little sparklines spotted in the papers from the 20 week scan my wife just had. Cool little chart like this should be everywhere!

    And by the way, it's a boy!
    Posted by
    0

    Add a comment

Labels
Labels
If you like this you'll like:
If you like this you'll like:
Info Clarity Archive
Info Clarity Archive
Loading