Using Tableau Measure Names and Measure Values to Build Data Tables

The Data pane contains a few fields that are not part of your data, two of which are Tableau Measure Names and Tableau Measure Values. The Measure Values field always appears at the bottom of the Tableau Measures area of the Data pane and contains all the measures of your data collected into one field. The Tableau Measure Names field always appears at the bottom of the Dimensions area of the Data pane

Read More

How to Tell a Story with Data and Analytics in Tableau

After all your effort in learning how to analyze data and present it effectively in charts and dashboards, we are going to evolve our thinking even further by learning how to tell a story with data and analytics. Chip and Dan Heath in their classic book Made to Stick, said: “Statistics are rarely meaningful in and of themselves. Statistics will, and should, almost always be used to illustrate a relationship. It’s

Read More

Guide to Dual Axis Tableau Charts

Combo and Dual Axis Tableau Charts present two different variables on the same graph.  For example, sales and profits.  These are different than one metric, like sales, with multiple dimensions or segments (i.e. Consumers, Enterprise, SMBs).  Dual Axis Tableau Charts compare two different metrics, which often have different scales. If not presented correctly, they can lead to wrong data interpretation. However, when you have limited real estate and you want

Read More

Showing Correlation in Tableau for Better Analysis

Up to this point, we’ve mostly looked at how data can be segmented by some dimension or over time.  However, looking at correlation in Tableau by looking between numbers, and how one metric affects another, is an extremely valuable skill in analytics.  Correlation analysis in Tableau compares two or more quantitative variables to see if values in one vary systematically with values in another.  For example, as height in men

Read More

Using Maps in Tableau for Improved Spatial Analysis

People love maps in Tableau.  It’s true.  They look cool and plotting data on top of them is even cooler, just check the World Corruption Map here.  Open a copy of the New York Times on almost any given day and you’ll find a map graphic.  Any time you have any data that is related to geography – zip codes, state or city names, addresses, provinces, postal codes, etc. –

Read More

Finding and Formatting Tableau Subtotals and Grand Totals

Tableau can quickly and easily add Tableau totals and Tableau subtotals to a table or chart.  It enables you to show just Tableau totals, just Tableau subtotals, or both together.  Additionally, you can specify which fields you want Tableau subtotals on, and at what level of aggregation (i.e. sum, avg, etc.). How to Find Tableau Subtotals and Tableau Grand Totals 1. Let’s build a table.  Bring Measure Names to Columns.

Read More

How to Use the Tableau Rank Calculated Field to Rank Profits

Tableau has a variety of built-in solutions for Tableau ranking values in a data set.  For most simple sorts, simply use the sort icons at the top.  For more advanced cases, we use either the Tableau Index or Tableau Rank Calculated Fields.  This is our first foray into the world of Tableau calculations.  Using the Tableau Rank Calculated Field In a new tab, right click on Profit and Create>Calculated Field. 

Read More

Simple and Advanced Tableau Data Connection Tutorial

Today, we will go through the different ways you can connect data in Tableau: from simple Tableau data connections to Advanced Tableau data connections using extracts. Simple Tableau Data Connections and the Data Connection Interface  Download the detailed and updated “Superstore” Excel file below. (You can use your own data for this as well!) Open Tableau.  In Tableau, click the Connect to Data text in the top left.   Next, click Microsoft Excel under “In a

Read More

Tableau Parameters: Mastering the Most Useful Parameters Fast

Tableau Parameters are some of the most flexible, and frankly, most awesome features of Tableau.  A Tableau parameter allows you or your end-user to change the content that appears in worksheets and dashboards.  This can be something simple like a value or something much more advanced.  Here we’ll cover several of the most commonly used examples of Tableau parameters.  Pre-defined Lists for Faster Filtering  As a general rule, Tableau parameters

Read More

Tableau Date Functions and How to Use Them for Your Analysis

When it comes to Date Calculations in Tableau, your go-to solution in Tableau will be the Tableau Date Functions. It is part of the amazing things you can do with the Tableau calculated field. Today, we will discuss the most common Tableau Date Functions which we know will be highly useful in your data analyses. Tableau Date Calculations  Date calculations will likely be one of the most common calculations you

Read More
  • 1
  • 2