Deconstructing Hans Rosling’s Latest TED Talk

First off — Hans Rosling is an inspiration to us all in the business of analytics and data visualization. Not only this story is extremely relevant, but the way he shows the numbers — there is a lot to learn. I will make an attempt here to deconstruct his latest TED talk in terms of what a good BI tool show do, and also how this is a great use case of how great BI users behave:

BI Features Used by Hans Rosling:

  • The most prominent is the use of Time as a special type of “dimension”. The tool knows that Time will support the concept of a Play button. This is still very novel — most BI tool, OpenI included, treat Time as any other dimension — you can drill up, drill down, set date filters, or date ranges — but that’s about it.  Taking a lesson from here, what we should do instead is that the moment there is a Time dimension, user should have the option to “superimpose” Time in “Play” mode within a given analysis — this should result in a Video Player like slider widget appear at the bottom of the analysis with a big old Play/Pause button next to it
  • Notice how he first presents the data bubbles in dual-axis graph and then transitions it over to a map view. This makes the concept of “background canvas” a dynamic entity for presenting data. How many other choices a user can have (in addition to dual-axis and map overlay) to use as the context in which the data should be presented
  • He keeps only 1 attribute per axis – country in X-axis, and % of population with HIV on Y-axis, and everything else (gender, per capital income, etc.) is treated as a filter (in OLAP speak). This keeps the visual very clear on its message. I have often struggled with OLAP based analyses, which have multiple dimensions on each axis, which makes sense sometimes in the table view, but the chart-view is completely horrid. Single data attribute per axis is a way to address that
  • When it comes to drilling further into data, he basically clicks on a country bubble — and it can either split by income groups, or only the specific country goes on a time play motion while others stay the some, etc. — the key for me here is that drilling down is best done at the visual level — somewhere on the chart/graph itself the user should be able to isolate a data group (in this case a country bubble), and have a choice on drilling down or move it back and forth in time

Hans Rosling as a BI User/Presenter

  • Emotion, emotion, emotion… he is so far away from the stereotype of a statistician making a presentation. He cares about what he’s presenting. The numbers are real people — they get sick, and they can either get better or they can die.. you can feel that empathy as he presents. 
  • Al Gore did this first (that I can recall) in The Inconvenient Truth when he brought a crane ladder to hoist him up so he can point to the tallest bar in the chart that he is showing. Maybe a bit too melodramatic — but it drives the point, and also makes a more visceral connection with the data. Hans Rosling stands on top of a table at the beginning of the presentation to explain the different numbers he is presenting, and the audience is at once connected and engaged
  • His bringing of the long metal pole to point to the numbers instead of your generic laser pointer (“I have solidified the laser beam”) is another way to get more personal and physical to show how involved he is
  • Ultimately he has leverages the BI tool to make a presentation, to tell a compelling story. Earlier in my career, we worked on a feature with another BI tool that automatically generated powerpoints from its charts.  Yes, it was pretty crude, and didn’t really work that well usabilitywise — but the point is, this was definitely a feature aimed at helping users build a story off the various charts and grahps and analyses. People want to tell a story — the BI tool should help them do that.

Ultimately, watching Mr. Rosling is definitely inspirational — I can only hope that OpenI will one day does the things he’s shown us in this presentation. I’m sure we will get there in due time, but it is the spirit in which BI tools are used, and their ultimate message.. that’s the important thing to keep in mind as we move the product forward.

OpenI 2.0 Beta is Released!

Dear OpenI Community:

I am very happy to announce that today we released the beta version of OpenI 2.0. I want to thank our entire development team for all the hard work they have put in for this release.

Please download it from and try it out. We look forward to hearing your feedback on improving this release as we work on further testing of this version to get to general release.

There is also a demo available at (login is openi2/openi2)

New features and enhancements in OpenI 2.0 Beta:

  • Create New Project: Create new project option is added in the preferences menu that creates a new project by selecting a new template which can be either the duplicate of the current project or a new template. It also allows the users to define the category, project logo etc. for the project being created.
  • Multiple Dashboards: an enhancement in the dashboard user interface which allows the user to create multiple project dashboards. this feature is available for the admin user only.
  • Purge Files: this feature allows the admin user to purge the older files, the user is prompted the file type ( i.e file extension ) and the date , the files with that type and older than the given date will be purged

New Features from OpenI 2.0 Alpha:

  • Completely re-written based on Spring, Java Server Faces and AJAX
  • New enhanced UI layout, completely “ajaxified”
  • New Drag and Drop Navigator UI to move attributes across rows, columns, and filters
  • Enhanced repository system implemented. Now project contents can be deployed anywhere. No need to have project contents within the “webapps” folder of j2ee servers
  • Application can be deployed into any J2EE server
  • QA feature added to validate the MDX statements for all analyses within a project with a single command
  • Manage Feed feature enhancement – now contains split rows feature and better CSV file parser
  • Default analysis for project – you can now specify default analysis for a project which is the first analysis displayed to a user immediately after user login
  • Customizable chart series color (for non pie type chart only) – Now you can define custom color palettes for chart
  • Excel export enhancement – OpenI now generates excel binary file which embeds chart in file itself (previously it contained a web link to the chart, which could result in broken image links)
  • Dashboard UI enhancement – Better UI that enables displaying both table and chart view option
  • Better File Manager – shows file in explorer style tree
  • User/Role management (requires custom build from source) : now users/roles management can be done from OpenI

Plus there are gobs of bug fixes. Check out the release  notes for more details.

Please pass the word around. And as always, we look forward to hearing from you.



Sandeep Giri
Project Lead, OpenI.Org