It's bracket season! On this episode of AskAndrew, we use a data set of 2024 hoops data to show how to use pivot tables to quickly crunch metrics.

Disclaimer: Pivot Tables aren't a guarantee you'll win your bracket BUT they can help you get faster mining data for trends.

The goal for today’s time is to showcase the basics of pivot tables: when to use them, how to set them up, how to filter, and how to sort. If you’re a little rusty or have avoided pivots, today’s show is for you. We will touch on a few common errors that may arise when playing with data to help you have the confidence of Caitlin Clark shooting from half-court.

Resources:

Data set

Google sheet (Copy the sheet to play with creating your own pivots)