Techniques for dealing with data structure issues
In some cases, restructuring data at the source is not an option. The source may be secured and read-only. Or you might not even have access to the original data and instead receive periodic dumps of data in a specific format. In such cases, there are techniques for dealing with structural issues once you have connected to the data in Tableau.
We'll consider some examples of data structure issues to demonstrate some techniques for handling those issues in Tableau. None of the solutions is the only right way to resolve the given issue. Often, there are several approaches that might work. Additionally, these are only examples of issues you might encounter. Take time to understand how the proposed solutions build on the foundational principles we've considered in previous chapters and how you can use similar techniques to solve your data issues.
Restructuring data in Tableau connections
The Excel workbook World Population Data.xlsx, included in...
