Best way to structure data in Excel for PivotTables
Podcast: Play in new window | Download
Subscribe: Spotify | TuneIn | RSS
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:
- The Tim Ferriss Show: Episode 359 – Tobi Lütke – From Snowboard Shop to Billion-Dollar Company
- JS Party: Episode 64 – TensorFlow.js and Machine Learning in JavaScript
- Syntax: Episode 121 – Hasty Treat – Tips to Succeed on YouTube
Trackbacks/Pingbacks
[…] have headers and sub-headers. People don’t typically organize and clean their data for the purposes of a PivotTable but rather for ease of use. With this in mind, I think these new Google Sheets functions are […]