Restructuring data in Tableau connections

The Excel workbook World Population Data.xlsx, included in the Chapter 09 directory of the resources included with this book, is typical of many Excel documents. Here is what it looks like:

Excel documents like this are often more human-readable but contain multiple issues for data analysis in Tableau. The issues in this particular document include:

  • Excessive headers (titles, notes, and formatting) that are not part of the data
  • Merged cells
  • Country name and code in a single column
  • Columns that are likely unnecessary (Indicator Name and Indicator Code)
  • The data is wide: there is a column for each year ...

Get Tableau 10 Complete Reference now with O’Reilly online learning.

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