Status:Closed    Asked:May 23, 2017 - 10:51 AM

Using data in Tableau


Does anyone know if there is a reasonable simple way to use this data in Tableau? I would like to get a data set for the 3-county Raleigh-Durham region that provides Telework data along with key demographics, such as age, sex, and race. That way I can see where people are telecommuting from and what they look like in different counties. Is is possible to get a data set from IPUMS that is compatible with Tableau that has these features? Thanks.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


This question may be difficult to address using IPUMS data. IPUMS CPS includes the variable WSWKHM which identifies if a respondent worked from home for their primary job as well as WSWKHMFREQ which identifies the frequency of working from home. These variables are not available in many samples, however, and are most recently available in the May sample of 2004. An additional limitation is identification of households by county. In the CPS, only about 45% of counties are identifiable due to confidentiality restrictions.


May 23, 2017 - 11:48 AM

Report it

Voted Best Answer

There are several ways to recieve your data in .csv format. The simplest way is to request .csv as the data format before submitting your extract. We also have several online video tutorials that walk through the steps.


May 24, 2017 - 08:26 AM

Report it


My recollection is that ACS does have that sort of information, too ( code 70). However, the numbers are very small, in the low single digit % range, so you will be lucky to have 50 or so telecommuting respondents for the whole Triangle area. I have tried something very similar about a year ago specifically for Triangle, and the numbers just aren't there.

I don't think there's anything magical about Tableau. It can read csv files, right? This is what you download from IPUMS.


May 23, 2017 - 02:11 PM

Report it

How do you get IPUMS to download as a .cvs file? I keep getting a .dat file. Do i just rename that as a .csv?


May 23, 2017 - 02:18 PM

Report it


No data set in "Download or Revise Extracts"
Is the 2010 Census Data Set Available?
How can I connect the data file to Tableau? I decompressed the file and tried...
I am researching the city of Buxton, Iowa in 1910. How do I get data showing ...
Login   |   Register

Recently Active Members

View More »

Share |