Summary
The ideal way to structure your data depends on how the result is defined. You may notice within a workflow that data needs to be transformed in a certain way, and the two ways this can be done are by using the Transpose tool to unpivot data, changing data from a wide dataset to a narrow dataset, and by using the Crosstab tool to pivot data, changing data from a narrow dataset to wider dataset. In this chapter, we reviewed many aggregation types available within the Summarize tool. The granularity of data can be defined within the Group By actions and the aggregation types are an action selection away to achieve the desired result. The Running Total is a great option for obtaining a cumulative sum of your data up to a certain point, defined by the Group By options, and the Weighted Average is used for applying a contribution amount for more records than others. This tool also contains the Group By option, specifying how data needs to be grouped together. These tools, available within...