The Excel workbook World Population Data.xlsx, which is included in the Data directory of the resources that are included with this book, is typical of many Excel documents. Here is what it looks like:
Excel documents such as this are often more human readable but contain multiple issues for data analysis in Tableau. The issues in this particular document include the following:
- 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, ...
