Interactive Google Analytics Dashboards with Tableau 10


Visualizing your data is one of the quickest ways to discover insights and communicate complexities. Google Analytics Dashboards provide you with everything you need to highlight performance trends. However, the user experience and visuals aren’t that great. Using Tableau allows you to connect to the Google Analytics Database and overcome these shortcomings. The data can be presented with forecasting, segmentation and calculated fields which will provide crucial insights for future marketing initiatives.

Here is a quick an easy way to create a dashboard using 4 sheets in Tableau

  1. Open a new project in Tableau 10
  2. Connect to Data Source
  3. Choose Google Analytics and apply your credentials.
    Define your Dimensions. For my Executive E-commerce Dashboard, I made sure to define the the elements that are in line with the business’s financial objectives. The dimension are channel, country, city, date The accompanying metrics are revenue and transactions.
  4. Create 3 to 4 sheets with your desired visualizations. For this visualization: Provide a revenue by time chart to show trends and data. You can supercharge this by using forecasting options in Tableau. The more data points Tableau has the more accurate is at forecasting.Forecasting will help to give your management an idea of where you heading for the coming months.
  5. Create a transactions by country and region. Go one step further by increasing the level of detail to city. You can add channels to colors shelf and revenue to size for more detail. Using the maps feature to highlight regional sales.
  6. Lastly, allow your user to manipulate the data using a filters. You can use the filter to apply to multiple visualizations changing the multiple graphs with one selection.

About the Author

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz