Pivot pivot! - All about pivot tables part 1

What are pivot tables?

• A great way to summarise, analyse, explore, and present your data, creating them with just a few clicks

• Are highly flexible and can be quickly adjusted depending on how you need to display your results

• Great when data is dynamic

Example

Using my Crime Data, I want to see how many offences were committed by both males and females in Ararat Rural City and Manningham City.

Note: the shortcut to insert a pivot table is ALT + N + V.

STEP-BY-STEP GUIDE (based on video)

I’ll click the down arrow next to “Row Labels”, untick “Select All” and select “Ararat Rural City” and “Manningham City”. In other words, filtering. Click OK.

Give pivot tables a go by replicating my example here: Crime Statistics

Notes: Categorical data and images of this tutorial are based on the following:

• 'Pivot' GIF sourced from giphy.com

• List of council areas from State Government of Victoria, Victorian Local Councils - http://www.vic.gov.au/government-economy/local-councils/victorian-local-councils.html

• List of offences and offence category from Crime Statistics Agency (CSA) - https://www.crimestatistics.vic.gov.au/

• All other figures and data are my own and is for illustrative purposes only.