Aggregating Data
Taking granular datasets and having to aggregate data within them is a very common, recurring, and sometimes exhausting task. No matter whether we need to get the total sales per item over a given period or the number of flights between cities, it all involves aggregating data. But sometimes, it is not just aggregating data but also having to re-shape it.
In this chapter, we’ll be going through some steps and recipes to accomplish these steps, in the best way possible. The recipes we will be covering are the following:
- Using Cross Tab to summarize values
- Preparing data for visualizations
- Grouping and summarizing your data
- Appending fields to data sources
