From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Join today to access over 25,300 courses taught by industry experts.
Modifying pivots for readability
From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Modifying pivots for readability
- [Instructor] Pivots are critical storytellers. When our decision-makers are asking for pivots or numbers, they're really wanting to be able to look at the numbers and make some decisions and gain understanding. The issue is that numbers, and specifically lots of them and large ones, like what we have in our dataset here, can be challenging for someone reading a pivot to get the information they need and get it quickly. Let's work through the three most common scenarios, which are values as a percentage of the grand total, percentage of the row total and a percentage of the column total. The very first thing I want to do is go ahead and name this sheet. I'll double-click that and call it Original Data Pivot. Then I'll control drag and drop a copy, cause I don't want to rebuild it each time, and I'll go ahead and name this one Percentage Values. I'm not exactly sure if I want all three or if I just want one of them. So Percentage Value's a good name for now. Okay, the very first thing…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.