Best way to structure data in Excel for PivotTables

PivotTables in Excel are a great way to visualize your data. However, in order to easily query and summarize your data in the PivotTable, you need to properly structure your data set before building the PivotTable. Not only is the practice of streamlining your dataset into fewer columns good for PivotTables for different dimensions, this is a good practice for putting your data in a regular database down the line. The dataset I used in this episode is the Gender, Institutions and Development Database 2014: Violence against women from the OECD.

In the 2nd half of the episode, I talk about some episodes from other podcasts I found interesting: