A big thank you to our FlowingData sponsors who help keep the servers running. This blog would be running at a snail’s pace otherwise. Check out their sites to see the useful visualization tools they have to offer.

Tableau Software — Data exploration and visual analytics for understanding databases and spreadsheets that makes data analysis easy and fun.

NetCharts — Build business dashboards that turn data into actionable information with dynamic charts and graphs.

IDV Solutions — Create interactive, map-based, enterprise mashups in SharePoint.

InstantAtlas — Enables information analysts to create interactive maps to improve data visualization and enhance communication.

East-West Center — The non-profit is looking for an information designer to put together a series of graphics for their online and print publication.

Want to be a FlowingData sponsor? Email me, and I’ll get back to you with the details.

Check out my guest post on The Guardian’s Data Blog on the current state of social data applications. There are what seems like a ton of them but none of them have really taken off (yet).

While the post is more of an overview of what’s available, I’d like to start a little discussion here on why these data apps haven’t gained more popularlity. There always seems be a lot of buzz around launch time, but then it fizzles.

Are people just not interested in interacting with data or do we need to approach the whole social data puzzle from a different angle?

We spend so much time trying to make our graphs accurate, simple, understandable, etc that we forget the lost art of making graphs that are inaccurate, unreadable, make absolutely no sense, and make your eyes want to vomit. I’m so tired of understanding data. I want to experience it, and I know you want to also.

So this one’s for you, crappy graph.
Read More

I’ve been working on my mapping skills lately in preparation for the first FlowingPrints poster, so when I came across this dataset for abortion rates in America, I had to map it.

The darker the shade of green, the higher the number of reported abortions per 1,000 live births.

New York has the highest rate with a whopping 507, which is a little over a third. That I’m not so sure about though. I’m thinking that there might be some high numbers in the ’70s driving that rate up, but I’d have to look deeper into that. Wyoming, on the other hand, only had a reported 14 abortions between 1970 and 2005.

In retrospect, the choice of green probably wasn’t the best color choice, but seeing as this is just practice, I don’t think it’s a big deal.

How I Made It

In case you’re wondering, I made the basemap in R using the maps and maptools packages. It was actually only 5 or 6 lines of code after I got the data how I wanted it. Then as I always do, I brought the PDF into Adobe Illustrator for some touch-ups and annotation.

Check out the full version here.

UPDATE: I revised the map using the Albers projection, so it doesn’t look so funky. Of course, it was more difficult than originally thought. Tutorial to come.

Are you an information designer looking for a project?

The East-West Center in Washington is currently looking for a designer to create a series of information graphics for an online and print publication. They want a series of graphics that will cover a broad range of topics from economics, politics, demographics, history and culture. They provide the data, and you provide the creativity.

The job description is a little wordy, but basically, they just want to see your portfolio and a sense of what kind of work you do. You can find more details here. It sounds like a fun opportunity.

As the newest release from Google Labs, Fusion Tables is a tool that aims to make your data more accessible.

Today we’re introducing Google Fusion Tables on Labs, an experimental system for data management in the cloud. It draws on the expertise of folks within Google Research who have been studying collaboration, data integration, and user requirements from a variety of domains. Fusion Tables is not a traditional database system focusing on complicated SQL queries and transaction processing. Instead, the focus is on fusing data management and collaboration: merging multiple data sources, discussion of the data, querying, visualization, and Web publishing.

Google Spreadsheets + phpMyAdmin

Fusion Tables will feel familiar to those of you who use Google Spreadsheets, but the use is somewhat different.

Where Spreadsheets is meant to mimic much of the feel of MIcrosoft Excel, Fusion Tables is somewhere in the middle between Excel and database (or at least it hopes to be eventually). You can filter data as well as merge your datasets with others, for example, by country.

Maybe the best way to describe Fusion Tables is a cross between Google Docs and phpMyAdmin, which is a user interface into a MySQL database.

Visualization Options

Probably of most interest are the visualization options. They’re what you’re used to seeing with line, pie, and bars, all looking very Google-y. The new ones to check out: motion chart and intensity map (above). There’s also a regular point mapping option. Again, we’ve seen these visualizations before, but Fusion Tables is trying to make it easier to use them.

What do you think of Google’s new offering? GIve it a whirl with their sample tables, and come back here and let us know what you think in the comments below.

[Thanks Andrew, NoodleGei, Oleks, and everyone else…]

Photo by penmachine

I threw out a random thought a couple of months back. I tweeted, “Remember when computers used to be just for geeks? Now they’re ubiquitous. We can do the same for data.”

To be honest, I was just babbling, but I’ve been giving it some thought, and you know, now I’m not so sure. There are so many applications popping up every day that promise to socialize data. To make it the YouTube of data. None of them have really taken off though.

Is it because the visualization tools aren’t advanced enough to make data accessible to the common user or is data simply meant to stay in the hands of experts?

So this begs the question:

If yes, what do you think makes data so distant to non-experts? If no, what will it take for non-experts to start interacting with data? Or are they already?

Do you have some data on your hands and don’t know what to do with it? Are you wondering what the best way to graph a dataset might be? Want some input on stuff you made?

If you do, I encourage you to post your questions and requests to the FlowingData forums. I get a lot questions via email, but from now on, I’ll only answer questions posted there.

It’s not that I don’t enjoy all of your emails. I really do. Rather, there’s two reasons why I’m making the shift. The first is that it occurred to me that others might be able to learn from my responses, so if someone has a similar question to yours later on, they might be able to find an answer.

The second reason is that sometimes I don’t know the answer (or don’t have time to reply). If you ask your question in the forums though, others might be able to help too. I like those odds.

Share Your Links

Finally, if you find any interesting data goodies from around the Web, please do post them to the forums. Or if you’ve just released one of your own projects, you can put it there too. In fact, the forums would be a better place to do it than emailing me. I’m so flooded with email these days (aren’t we all?) that it’s been hard to keep up.

Sign Up Now

Go ahead and register in the forums now if you haven’t done that already. It’s free, it’s easy, and will only take a few seconds.

Go on now, I’ll wait for you…

Done? Cool. See, I told you it was easy.

We’ve all seen the new Star Trek by now. If you haven’t, you should. There are amazing visuals throughout, especially on the bridge, where those aboard can just about interact with everything that can be touched. Albeit it’s purely fictional and non-functional, but it’s good to dream.

OOOii, the group behind the beautiful board in Minority Report and the immersive technologies in The Island, is responsible for bringing the interfaces in Star Trek to life. Read More

Vincenzo Cosenza maps social network dominance around the world according to traffic data from Alexa and Google Trends. We see Facebook has apparently overtaken MySpace in the US along with other countries; Orkut is a favorite in Brazil; the people love QQ in China; and then there are a few smaller networks that most of us have probably never heard of unless we live in the country of dominance.

It’s also worth noting that the map was done with IBM’s Many Eyes, so you can interact with the embedded map below. After data culling, the map was probably created in no time.

I personally don’t know anyone who uses anything other than Facebook or LinkedIn. Remember Friendster? People always laugh when I mention it. What do you use?

I finally upgraded to the most recent WordPress, and everything seems to have succeeded without any hitches. I always get a little nervous when I upgrade. I backup everything nightly, but it’s a hassle when something goes cukoo. Please do let me know if you see anything weird.

Threaded Comments

One significant change you should notice is threaded comments. You can now directly reply to others’ comments at the end of posts. I’m really happy with the results. Your comments add a lot of depth, new ideas, and character to the blog, and now it’s that much easier to have a real conversation. Enjoy.

As we’ve seen, javascript is growing into a viable solution for visualization on the Web. John Resig ported Processing to javascript about a year ago and we saw some projects in javascript to show off speed in Google Chrome.

Most recently, Nicolas Garcia Belmonte released version 1.1 of his InfoVis Toolkit, which provides a basic set of tools for creating interactive visualizations on the Web. Read More

Photo by majamarko

As we’ve all read by now, Google’s chief economist Hal Varian commented in January that the next sexy job in the next 10 years would be statisticians. Obviously, I whole-heartedly agree. Heck, I’d go a step further and say they’re sexy now – mentally and physically.

However, if you went on to read the rest of Varian’s interview, you’d know that by statisticians, he actually meant it as a general title for someone who is able to extract information from large datasets and then present something of use to non-data experts.
Read More

You know all those infographics that you like so much from GOOD Magazine? Well they’re all in one place now in their Flickr archive. Head on over to view all 80.

[Thanks, Amrit]

We all know Twitter has taken on a life of its own. With the very open API, Twitter allows developers to create countless applications on top of the service, and the sheer number of users has opened up opportunities in the area of real-time search. Needless to say, Twitter has a lot of opportunities worth considering, and it’s possible the service could look very different a year from now (underneath the frontend) as more people adopt and bubbling acquisition rumors perhaps come to fruition. The below flow chart from Steve Rubel shows Twitter’s possible future while the above from Brian Solis and Jess3 shows all the spawns of Twitter data.
Read More

This infographic from Wired explains how Living Machines work to combine waste management and a garden in an office lobby. Honestly, I’m posting this for one reason only. The title is Déjà Poo. Brilliant. Yes. I am that immature.

This infographic from Wired explains how Living Machines work to combine waste management and a garden in an office lobby. Honestly, I’m posting this for one reason only. The title is Déjà Poo. Brilliant. Yes. I am that immature.

[via Graphic Sociology]

This graphic on the history and future of information has been making the rounds. Several people sent it to me a while back, but it didn’t seem quite right, so I didn’t post it; however, this post from PZ Meyers compelled me to take another look. Meyers says:

Some days, I think other people must be aliens. Or I must be. For instance, there’s a lot of noise right now about this article analyzing the future of information and media that, if you read the comments, you will discover that people are praising to an astonishing degree. I looked at it and saw this graph [above graphic]. And my bullshit detector went insane. It’s supposed to be saying something about where people are and will be getting their information, but there’s no information about where this information came from, and it’s meaningless!

Yikes. Take out the boxing gloves. Looks like we’ve got another clash between the technical and the design-ish and mainstream crowds. The comments from both sides are also pretty interesting with one group saying how visually appealing and informative the graphic is with the other group criticizing the graphic for failing in every way.

Good or Bad?

Clearly the graphic is not based on any real data or metric. It goes off history and probably a lot of Wikipedia entries, and then shapes and sizes go off feeling. So as an analytical graph, it doesn’t work. But what about as an opinion in graph form? Does it work then? What do you think? Is this graphic a crime against all that is good in visualization or does it work for what it was trying to do?

[Thanks, Patrick]

It’s Friday. It’s summer. It’s time to relax in the backyard with an ice cold beer in hand. As you consume your beverage, here are 11 infographics about your beer, because the more you know, the more you enjoy. To start things off is a full history of beer (above). Read More

A large majority of us who have websites use Google Analytics as our traffic monitor, and why not? It’s free, it works, and it provides loads of data on traffic, referrals, and our content. We can then make decisions based on that data, but the trouble is there’s a fair amount of clicking before we get to the good stuff. Enter Dshbrd by DabbleDB. Yes, that’s dashboard with no vowels.

Taking the Guesswork Out of Analytics

The DabbleDB folks know data, and Dshbrd is no exception. Using data from your Google Analytics account, Dshbrd analyzes and finds the points of interest – and then shows them to you in a clear and concise way. I’ve grown incredibly tired of overused sparklines, but Dshbrd uses them well to show traffic trends alongside a vertical stacked area chart. The two are linked such that when you scroll over an event (e.g. rise in referrals from Digg), the area on the stacked chart highlights and vice versa.

View traffic from site referrals, search engines, and direct links or content popularity, etc. Basically, you can examine all of your analytics data in Dshbrd that you can in Google Analytics but in this new view. It might take a second to get used to time on the vertical axis, but once you get over that, this alternative interface is quite intuitive and more importantly, very useful.

Now if only DabbleDB would provide a reliable API I would be very happy.

Premium Analytics

Ultimately, I’m guessing DabbleDB would want to turn Dshbrd into a fee-based service if it gained enough traction. I personally wouldn’t pay for it since I really don’t need that much outside the usual Google view, but I could see how Dshbrd could be useful to others. What do you think? Would you pay for this sort of premium view into your Google Analytics data?

In celebration of Barack Obama’s 100th day as the 44th President of the United States, the MIT SENSEable City Lab visualized mobile phone activity during the historic inauguration. What we see is a sense of the worldwide celebration and when and where people traveled to Washington, D.C. to get to the event. They call it Obama | One People. Read More