Tag Archives: michael lewis

12-copy-paste-pivot-table-slicer

Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)

I used to create a monthly 30-slide report and each slide had a different table or chart that I copied and pasted from Excel. As a naive analyst, I literally filtered my list of data using regular dropdown filters on each column to get the numbers I needed. I would filter, sum or average the […]

Dear Analyst #35: Analyzing what people dream about with the Shape of Dreams data visualization

Have you ever wondered what the underlying meaning of your dreams are? Chances are you may have tried Googling something like “What does it mean to dream about [INSERT DREAM].” In The Shape of Dreams, Federica Fragapane answers this very question of what people around the world dream about by using Google Search queries from […]