10 Tableau Data Viz Tips I Learned from Google Analytics Feature

Five years ago, we were fortunate to be introduced to Tableau, a tool for data visualization that has led to personal opportunities and contributions to our clients’ businesses that we didn’t imagine would be possible in such a short amount of time.

Even before that though, we were introduced to Google Analytics.

It’s no surprise then that some of our inspiration for the design, usability, and analytics of our data visualizations have been drawn from Google Analytics over the years. Sure, the Audience Overview report features an overly large pie chart for New vs. Returning visitors – a measure that is largely useless in an age of multiple devices, cleared cookies, and anonymous users – but Google tends to get a lot of things right. Who are we to doubt a company with the most-visited website in the world and a market cap at $368 Billion as of this writing?

What follows is a list of 10 Tableau data visualization best practices we use that we either consciously or subconsciously picked up from Google Analytics. In no particular order…

Use a Maximum of 12 Dashboard Objects

One of the first ideas we remember consciously thinking, “Wow – that’s a good idea, Google Analytics; I should use that…,” was the 12 object limit Google Analytics has in place for their custom dashboards. Many data visualization specialists often remind us that “less is more”, and we have encouraged designers in our Data-Driven Storytelling series to Keep It Simple. In Google Analytics, you have no choice but to keep dashboard objects, or widgets in Google’s words, to 12 or fewer. Here is what you see when trying to add a 13th widget in a Google Analytics custom dashboard:

Google Analytics Custom Dashboard Widget Limit

This limit forces designers to prioritize which KPIs and views are truly pertinent to the story.

Improve User Experience by Leveraging Dashboard Actions

On Google’s Audience Overview report, which is my favorite report to start our analysis on, seven main KPIs are shown along with sparkline trends. By clicking a sparkline, the larger line graph at the top will change to that KPI. This makes it easier to see trends and find extra detail, which is provided if you hover over data points.

Google Analytics Audience Overview Report with Dashboard Actions

Similar usability can be set up in Tableau through the use of dashboard actions. Here is a simple example using a control sheet for Customer Segment and a sales trend over time. By adding both sheets to a dashboard and choosing to use the sheet containing the three different customer segments as a filter, clicking on a customer segment will filter the trend being shown:

Tableau Sales Trend by Customer Segment Dashboard Action

To use a sheet as a filter, click on the sheet, click the down arrow that appears in the top right corner, and click “Use as Filter”.

Allow End Users to Change the Date Aggregation of Line Graphs

Another feature we like about the Audience Overview report in Google Analytics is the ability to change the date aggregation of the trend being shown. By default, the trends are aggregated by Day, but users also have the option to change the granularity to Hour, Week, or Month:

Date Aggregation in Google Analytics

This feature can help find different stories in the data based on the aggregation being displayed. To learn how to replicate this in Tableau, see our Tableau 201 post, How to Change Date Aggregation Using Parameters.

Keep Crosstab Widths to a Maximum of Ten Columns

Tableau allows you to make crosstab views with up to 16 columns. If you ask us, this is about 11 too many. Spreadsheets are not data visualizations and they take far too long for analysts to process. Google Analytics is at least closer, never displaying more than 10 columns including the dimension in the first column (nine measures pictured below):

Crosstab View in Google Analytics

Sometimes it makes sense to use crosstabs in small doses, and are realistic that some audiences will require more detailed data in a text table. If at all possible, we would stick with this implied limit from Google Analytics of ten or fewer columns.

Use a Vertical Navigation in the Left Column

In Tip Five of our Data-Driven Storytelling series, we discuss using the Golden Ratio in data visualization. In addition to considering the dimensions of a dashboard, another aspect of the Golden Ratio is to prioritize content – placing more important dashboard components to the top and left of the view.

For this reason, we’ve always appreciated the intuitive, left navigation of Google Analytics. For reports that have a lot of changeable components, such as filters, the vertical space on the left side of a dashboard is an ideal place for navigation. Placing controls here serves the dual-purpose of prioritizing what changes can be made to find stories in the data and having a clear place to remind users what filters have been applied.

Google Analytics Left Navigation

This is not a must-use tip for every situation, but makes a lot of sense for dashboards that are meant to provide self-serve analytics. If you have certain dashboards that are not meant to be changed very often, deprioritize filters and buttons by moving them to the right navigation.

Choose Five or Fewer Colors for Your Workbooks

At times, the number of distinct categories within a dimension on a view will dictate how many colors are required in a data visualization. For example, we may have a unique color for each region: North, East, South, and West. When possible, we try to limit the number of colors to five or fewer; an unspoken rule we picked up from Google Analytics’ simple color choices.

Google Analytics does have a set of visuals called “Motion Charts” that contain more than five unique colors, but outside of that, it is challenging to find visuals with more than two different colors. Using five or fewer colors reduces the burden on the end user because they do not have to work as hard to look back and forth to the color legend to determine what the marks on a view represent.

If you are in a situation where more than five categories need distinct colors, consider a two-color palette – making the category of interest a color that stands out, and everything else a more muted color, such as gray. See tip three in our Data-Driven Storytelling Series for more on getting the most from color in data visualization.

Line Graph with One Category Highlighted

Stick Mostly to Lines and Bars

With only a few exceptions, Google Analytics’ powerful analytics platform is built almost entirely on what we call the kings of data visualization – lines and bars. Google Analytics has recently added treemaps to their Acquisition reports and Cohort Analysis, which are essentially highlight tables, are currently in Beta. They also use scatterplots in the aforementioned Motion Charts and we’re sad to say, pie charts make several appearances (by the way, Don’t Use Pie Charts).

Even with those other chart types, lines and bars dominate the dozens of available reports in Google Analytics, and for good reason. These simple chart types have been getting the job done for more than 200 years now, and in most cases, continue to be the best starting point for sharing trends and comparisons in data visualization.

Include Comparisons Such as Year over Year

When we develop data visualizations, we are constantly trying to avoid the dreaded question, “So What?” If we hear this question, it means we did not do a good enough job communicating the stories in the data. One way to avoid this awkward conversation about why you’ve spent days developing a data visualization that doesn’t tell anybody anything… is to use comparisons.

Some of our favorite approaches for showing comparisons are bar charts, small multiples, and period over period comparisons. The latter of which can be done very easily in Google Analytics by selecting a date range comparison when you set the date range.

Period Over Period Comparison in Google Analytics

Google Analytics allows you to compare your selected dates to a custom secondary range, the previous period of the same range (i.e. 15 days vs. 15 days) or to that same date range versus the prior year. Similar functionality can be set up in Tableau using parameters.

Bring Your Data Visualization to Life Using Segmentation

Another way we like to provide comparisons in my data visualizations is through the use of segmentation. Segmentation is one of the most powerful tactics for adding value to your analyses; making it easy to quickly identify your weakest and strongest performers. Segmentation allows you to hone in on your weakest performers to figure out what characteristics to avoid, or your strongest performers to determine what you should be doing more of.

In Google Analytics, several segments including Mobile Traffic, Referral Traffic, and Returning Users (just to name a few), come ready to use ‘out-of-the-box’. You can also set up customized advanced segments to compare users almost any way you can imagine. These standard and custom segments can be used to compare performance to each other, or the site as a whole:

Segmentation in Google Analytics

There are a couple of ways to leverage segmentation in Tableau. First, if you are using the Google Analytics connector, you can filter the data coming into Tableau on a specific segment. Note Step 4 below in the connection setup:

Segmentation in Tableau Google Analytics Connector

The drawback to this is – you can only segment the data to one thing at a time. A much more powerful use of segmentation in Tableau is to create and compare your own segments once the data is already being used in Tableau. For more on customizing your segmentation, see How to Create and Compare Segments in Tableau.

Include Alerts of Exceptional or Poor Performance

Last but not least, Google Analytics taught us the power of boiling the most important stories in the data to the top. Google Analytics does this in the form of Intelligence Events, which shows any performance on a site for a particular date range that fell outside of its algorithms’ expectations:

Intelligence Events in Google Analytics

Intelligence Events are a great place to start an analysis and we love them for a couple of reasons:

  • They do the heavy-lifting for you; making outliers apparent without making you dig to find them.
  • They are easily understood by analysts and non-analysts alike.

In Tableau, similar alerts can be built into your dashboards to make them more user-friendly and reduce time to insight. Here are 3 Ways to Add Alerts to Your Tableau Dashboards to get you started.

Google has taught us a lot over the years and these ten data visualization best practices from Google Analytics have served us well. One of the things we like most about Tableau is the software’s flexibility, and we encourage you to take the best ideas from other tools and incorporate – or even build on – them in your own dashboards.

Written By


This post is curated content from the Evolytics staff, bringing you the most interesting news in data and analysis from around the web. The Evolytics staff has proven experience and expertise in analytics strategy, tagging implementation, data engineering, and data visualization.