Open Data is everywhere. But, how can you make gold out of it? How can you make meaning of rough data?
In this blog-post, we would like to show you how to create in a few minutes in Jolicharts charts and data visualizations that you can share in one click.
STEP 1 – Finding Data
We chose to elaborate on the topic of education and research. We were all interested in this topic, and it’s also quite easy to find open data in these fields.
Few Google searches for “Top American Research Universities Data” lead us to get some reliable data from The Center for Measuring Universities Performance of the Arizona State University.
We found the fields of the spreadsheets of the results of their last study were already concatenated: Total Research, Federal Research, Endowment Assets, Annual Giving, National Academy Members, Faculty Awards, Doctorates Granted, Postdoctoral Appointees, and SAT/ACT range.
For your interest, you should be able to find some link about very reliable governmental open data initiatives on the Wikipedia page about Open Data.
STEP 2 – Cleaning Data
The messy, real-world data spreadsheet file had to be modified into the data tables Jolicharts expects. Only few changes were made.
Even if this step is very important when you use data that aren’t designed to be processed, it is not always compulsory. More and more data is already well shaped for analytic tools (like, for example, most of the data you directly export from software or web apps).
STEP 3 – Uploading Data on Jolicharts
Because all the data was on the same Excel sheet, everything was quickly loaded in only one “Adding a data source” click.
STEP 4 – Design Charts
As usual, charts were made with drag and drops. We decided to always filter the only ten first results on each chart. It makes the Dashboard more synthetic and understandable at first glance.
Sharing is caring! You can also choose to share this dashboards with your colleagues, enable them to have real-time insights on your creation in order to get some feedback of your work.
STEP 5 – Design the dashboard
Some colors, icons and source explanation were added, to give it a more pleasant overview and also some visual aid.
STEP 6 – Share the dashboard
One click was enough to share our dashboards online. Here is our result, go and see by yourself!
It took less than 2 hours to build this dashboard. Of course, it is not the first time I was making visualizations with Jolicharts, but if you know already precisely what kind of visualization you want to have as a result, Jolicharts is the tool that helps you turn ideas into reality.