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.

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.

Tip: Once you defined the look of one chart-bloc (font size, colors) feel free to copy-paste this nice chart block through your dashboard and then change the visualization.

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.