Tag Archives: dashboard

Dear Analyst 124

Dear Analyst #124: Navigating people, politics and analytics solutions at large companies with Alex Kolokolov

We sometimes forget that a large organization is composed of groups and divisions. Within these groups, there are teams and individuals looking to advance their careers. Sometimes at the expense of others. When your advancement depends on the success of your project, the benefits of that project to your company may be suspect and the […]

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 […]