GetApp Lab

Choosing the right chart: data visualization tips for business

Here’s a quick memory challenge: think of the last bar chart from a presentation that you remember. Now compare that to a map of the United States that details the results of the 2016 presidential election. Obviously, you likely had a more personal investment in the election, but do you think the image would have stuck in your head had it been displayed as a drab 50-state bar chart? The same principle can be applied to the visualizations from your spreadsheet, your big data analysis, and your business intelligence stats.

In this article, I’ll go over some quick data visualization tips pulled from around the web. These tips can be used to give your presentations some kick and make your visualizations memorable. After all, what’s the point of presenting something if people are going to quickly forget it?

Use the right type of chart or graph

First and foremost, it’s important to choose the right type of visualization. And when I say “visualization”, I’m referring to any visual representation of your quantitative data. There are visualizations that venture more into the realm of a newsy infographic – and there’s nothing wrong with them – but I’d like to stick situations where you might need to present something from your business dashboard. So, let’s go for a quick refresher over some traditional types of data visualizations:

Those are some classic examples of ways of displaying info and what you’re most likely to see out in the wild. However, there are plenty more types of visualizations that you probably come across on a regular basis, such as bubble chart, radial tree, or even the NYC subway map. If you’re interested in seeing more visualizations, check out this guide from the Duke University library.

Information is beautiful

David McCandless is an expert in data visualization and runs Information is Beautiful. The site is worth spending time on and displays visualizations – usually interactive – on a variety of topics that include the gender pay gap, cooking oils compared, and the effectiveness of natural supplements. If you are looking for inspiration for a visual you want to put up, Information is Beautiful is a great option.


Color is important

If you’re more of a textual person like me, it’s easy to overlook the importance that color plays in your visualizations. I’m not an expert on color, but I can give you a few pointers to keep in mind, plus some resources that can your answers questions better than I can.

Don’t go wild with your new features

Although it can be tempting to create an interactive 3D scatter point chart that features 30 vibrant shades of green, it’s not the best option to show off all the features you have available. It’s the same as watching a PowerPoint presentation that includes a flashy animation and an accompanying sound for every slide transition; it would get distracting fast. Instead, focus on making your results clear. If you want to show consumer purchasing power across Europe, try overlaying different the figures over each country. Take it a step further and use a yellow to red scale and use shading to denote lower/higher purchasing power.

Tableau recommends checking every visual with the “5-second rule.” They write, “Research shows that the modern attention span for looking at things online is, on average, less than five seconds. So if you can’t grab attention within five seconds, you’ve likely lost your viewer.Be sure your viz includes clear titles and instructions. Tell people succinctly what the visualization shows and how to interact with it.”

Data Visualization software

There are many ways to create a visualization, but the most common way is using a spreadsheet program like Excel. However, many visualization features are found on business intelligence solutions. Below are some examples of software that is either dedicated to visualization or is part of a larger suite.

Helpful links and sources

This article only scratches the surface when it comes to data visualization. There’s a ton of great information out there that is worth bookmarking for future reference. Check out the links below for more info:

Categories: Insights
Tags: home
Matt Mullarkey-Toner :Matt is a writer at GetApp covering security, BYOD, and IoT. Prior to GetApp, he spent five years working for various news organizations in the United States and UK, before spending a year writing about mobile applications. His interests include cooking, the NBA, and rattling off trivial factoids.