Dear Analyst

Best way to structure data in Excel for PivotTables


Listen Later


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

...more
View all episodesView all episodes
Download on the App Store

Dear AnalystBy KeyCuts

  • 3.8
  • 3.8
  • 3.8
  • 3.8
  • 3.8

3.8

5 ratings