Using the Data Interpreter and pivots

Tableau works best with clean, tall, and narrow data instead of short and wide data. The same measures should ideally be provided in a single column instead of spread out.

Let's clean up the following spreadsheet on Canada International Student Permits and ready it for Tableau:

  1. Download the file from the Citizenship and Immigration Canada website using the following URL:

http://www.cic.gc.ca/opendata-donneesouvertes/data/IRCC_IS_0004_E.xls

  1. Connect to the Excel file in this example. Make sure you choose Excel from the To a File section:
  2. When you first connect to this Excel file, this is what you will ...

Get Tableau 10 Bootcamp now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.