blog #1: learning spreadsheet software
The first data analytics tool that I learned to use was Google sheets, it’s a spreadsheet software that’s flexible and versatile. I started to gravitate towards the pivot table feature to quickly summarize large amounts of data, analyze numerical data in detail, and answer unanticipated questions about my data.
Here's an example to demonstrate how pivot tables work.
- Consider this dataset. My main goal is to summarize the data and answer questions such as: how many apartments are there in the dataset? what’s the total cost of all the apartments? (After opening it click somewhere inside the data)