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:
- Download the file from the Citizenship and Immigration Canada website using the following URL:
- Connect to the Excel file in this example. Make sure you choose Excel from the To a File section:
- When you first connect to this Excel file, this is what you will ...