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.
Visualizing pivot tables
From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Visualizing pivot tables
- [Instructor] A picture is worth thousands of lines of data, and this is where visualizing your pivot data can be impactful. This will allow you to explore your data visually versus just reading the numbers. I think it's important that you do use visuals to show the different stories of the data, but again, I like to have both the numbers, as well as the visual. Let's take our existing pivots and we'll create these different visualizations of the data. And we found after speaking with our team that they also found it impactful to look at the single year over year performance per product, but they noticed a few things that we need to adjust for our upcoming meeting. For example, they want to look at the volume in price versus the volume in quantity. So we'll go ahead and copy this sheet because it's really easy to make this change in a pivot. I'll go ahead and remove my sum of quantity. I'll go grab the TotalLine and drag that to values. Because they want to look historically at the…
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.