Book Image

Learning Tableau

By : Joshua N. Milligan
Book Image

Learning Tableau

By: Joshua N. Milligan

Overview of this book

Table of Contents (18 chapters)
Learning Tableau
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
8
Adding Value to Analysis – Trends, Distributions, and Forecasting
Index

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 might be receiving periodic dumps of data in a specific format instead, which would be tedious to change each time. In such cases, there are techniques to deal 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 to handle these issues in Tableau. None of the solutions are the "only right way" to resolve the given issue. Often, there are several approaches that might work. Take time to understand how the proposed solutions build on the foundational principals we considered in previous chapters.

Restructuring data in Tableau connections

The World Population Data.xlsx Excel workbook, included in the Data directory of the resources included with this book, is typical of many Excel documents. Here...