How to View Your Website

Stats in Tableau

Ben Jones

@DataRemixed

Here’s what we’ll build in this tutorial

A website usage dashboard,

Including:

1. Large call-outs of overall stats

2. Ability to select which statistic

you’d like to see

3. Timeline with ability to change

range of dates

4. Top destinations, sources and

social sources

5. Visitor location world map and

top country list

6. Ability to filter all charts on the

dashboard by selection

7. Ability to navigate to destination

pages by clicking on red bars

8. Logo image file

Connect to Google Analytics from Tableau Desktop

1. Connect to Data 2. Enter Credentials 3. Choose Fields

Create Parameter & Calc Field to Switch Between Different Stats

1. Create a New Parameter 2. Create a New Calculated Field that

links to the Parameter

Create a Calc Field that turns the Destination into a URL

Create 4 Top Stats Callout Boxes

Create a Timeline View

Create a Bar Chart of Top Destination Pages

Be sure to add

“Site URL” to

the Level of

Detail

Create Similar Bar Charts for Source & Social Source

Create a World Map and Country List

Put them all together on a New Dashboard

Be Sure to:

• Apply Date Slider

Filter to All

Worksheets

• Use All Sheets as

Filters

• Add Images, etc.

Create a New Dashboard Action to Link

Destination Bars to URLs

Put the Finishing Touches on the Dashboard