-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Tableau Prep Cookbook
By :

Data is often produced by systems in what the engineers building the system thought was the most efficient manner. Rarely do data processing and storage systems store data with visualization in mind. Similarly, you may have data available that is appropriate for one type of visualization but not another. In this recipe, we'll look at a sales dataset. This dataset has sales revenue values per category. The categories are Electronics, Groceries, and Household Appliances. Each of the categories has its own column, which prevents us from easily making a line chart with overall revenue. To resolve this, we're going to pivot the data such that these three individual columns become a single Category column, and values are placed in a single Revenue column.
To follow along with this recipe, download the Sample Files 6.1 folder from this book's GitHub repository.
Start by opening the Sales Data.csv file from...