Hi. I'm Lisa.

Thanks for reading my blog. I share thoughts and information about things I am learning in the field of data and technology. I also share experiences from my work and side projects. I hope that my willingness to share my work, inspires you to share yours!

The Top 10 Tableau "Asking for a Friend" Questions

The Top 10 Tableau "Asking for a Friend" Questions

When starting out with Tableau, there are some things that trip up newbies--things that many tried and true Tableau users have known for awhile and assume everyone else already knows. Newbies are embarrassed to ask these questions, hence the use of the phrase "Asking for a Friend". Here are some of those questions. Remember that I am a bit of a newbie myself, so feel free to provide better answers or add any questions that I missed by adding a comment below.

1. In Tableau, what is the difference between a dimension and a measure?

A dimension is anything that is qualitative or categorical and not a number. So if you are visualizing breeds and numbers of dogs, the breeds of the dogs would be a dimension. The number of dogs is a measure. In a Tableau workbook, dimensions are blue pills and measures are green pills. Most of the time, Tableau is pretty intuitive and recognizes the difference, so when you connect to the data and open the workbook, the data usually ends up in the right spot, making this the least of your worries.

2. What is a .twb and how is it different than a .twbx? 

A .twb file is a Tableau workbook that does not contain data. It's basically an empty shell or template that won't open at all, or if it does, opens up as an empty Tableau workbook, showing the user nothing. You can send a data extract file (e.g. Excel file) along with the .twb, but that is a hassle for the user, especially if they are unfamiliar with how to connect data in Tableau.

Don't send a .twb unless your user is expecting it and knows how to connect to the data source. Instead, package your workbook with a data extract and send a .twbx file (Tableau workbook with data extract).

3. Now that I know the difference between a .twb and a .twbx, what is a Tableau Data Extract (TDE) and how do I get it?

A Tableau Data Extract (TDE) is simply that--the data extracted from your data source that is packaged with your .twb. In other words, ".twb + data extract = .twbx". This is the preferred format for sending Tableau workbooks. Don't frustrate your recipients by sending a .twb instead. To understand completely the concept of Tableau Data Extracts, read this detailed blogpost. If you are in a hurry and just need to know how to save your workbook as a .twbx, go to the Data Source tab at the bottom of your workbook, choose Extract under Connection in the top right corner of the Data Source screen > Edit > Save. Then once you save your workbook, your data extract will be included. If you don't want to save all of the data and would rather limit the amount of data saved in the extract, refer to these instructions.

4. What is Tableau Public and how do I publish my work there? Who then can see my work?

Tableau Public is a really wonderful free tool that allows anyone to use Tableau. You can use your Tableau Public profile as a portfolio or a sandbox to play around with visualizing public datasets.

You can download and use the Tableau Public software to create workbooks and then upload your workbooks (or a workbook created in Tableau Desktop) into a Tableau Public user profile that you create for yourself. Simply open your workbook--making sure you have a data extract saved--and choose the top tab Server > Tableau Public > Save to Tableau Public > Saved!


Warning: If you don't save a TDE (Tableau Data Extract) before trying to save your workbook to Tableau Public, you will get this message, preventing you from saving your workbook to Tableau Public until you first save the data extract.



You can even embed visualizations into your own website, if your webhost allows you to embed Tableau Public links. Just choose the Share button located below your dashboard and copy and paste the embed code into your webpage. Mine doesn't allow an embed, so I added a link to the snapshot of my dashboard:


Caveat: Anything you publish to Tableau Public (as in data sources) is considered in the public domain (even if you toggle the workbook eye icon visibility to hidden in your profile); therefore, be sure to refrain from uploading any workbooks using proprietary data sets.

Check here for more information about how to use Tableau Public.

5. What file type is a .csv considered when connecting to data? 

A .csv file is a comma-separated values file and Tableau sees it as a text file, not as an Excel file. When connecting to data in Tableau using a .csv file, remember to choose "Text file". 

6. What do I do when my numbers don't import correctly (e.g. return null values, return 1899 or 1905 for every date, etc.)?

It all depends. There are variations of problems involving connecting to data where Tableau changes the format to something other than what you were expecting. Take a deep breath and check to see how Tableau has classified your data (string, number, etc.). Sometimes, if you change the format, it just might fix the problem. Here is a post that addresses many of the most common problems encountered and the calculated fields recommended to remedy those problems. The specific 1905 date solution is to change the data type to string and to create a calculated field. Here is more information on the steps to how to make this happen.

Sometimes you will need to split a date and time column. Tableau Prep can help you solve these problems. If your problem is complex, and you are still unable to solve it, resort to finding solutions in Excel. Initially shaping your data in Excel can limit the chance of problems occurring when connecting the data in Tableau.

7. Should I use tiled or floating containers when designing a dashboard layout?

Beginners may want to start with tiled containers, but not necessarily. Floating containers offer more in the way of controlling size and allow for more creativity, but can be tricky to use. If you are already a confident graphic designer, try your hand at both. 

8. What size dimensions should I choose for my dashboard to make my workbook load correctly on any device?

Consider which device the reader will be using to view the dashboard. Choose the dashboard layout size dimensions that match that device. Caveat: "Automatic" is an option that is designed to allow the dashboard to load properly on any device, but it doesn't always work perfectly. Test it on the device to make sure it gives you the display you expect.

9. Can I share a workbook with someone who doesn't own Tableau?

Yes, but it is necessary for the recipient to first download Tableau Reader in order to be able to open and interact with your workbook.

10. Is Tableau Prep a part of Tableau Desktop or is it a separate download from Tableau Desktop?

Tableau Prep is a separate download from Tableau Desktop. You use the same key to get the download, though. It loads as a separate application on your device. You prepare/shape the data in Tableau Prep and save it as a Tableau Prep Flow File (.tfl). Installation instructions for Tableau Prep is located here.

I'm admittedly still a newbie in using Tableau. I just picked up the book, Practical Tableau, by Ryan Sleeper and am working through the examples used in each of his 100 chapters and am learning a lot. I highly recommend it!

If you are contemplating whether or not you should share your story, check out my recent blogpost about why it's a good thing, even if you don't consider yourself a genius or an expert.

Looking Back at Harold and the Purple Crayon

Looking Back at Harold and the Purple Crayon

This is How We Do It

This is How We Do It