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.
Solution: Best customer year
From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Solution: Best customer year
(upbeat music) - [Instructor] I'll start by adding a pivot table. I'll go to my insert tab, go to my pivot table, click okay. I do want to look at my customer and I want to look at them year over year. So I'll drag invoice date to columns. And again, by default, it gives me additional date. So I'll go ahead and pull the invoice date out in quarters. 'Cause I'm looking at a year over year performance and we're going to use that extended price. I'll go ahead and drag that in. Okay, great. So now I can see each customer and how they did each year based on that extended price. And what I want to do now is show this as a percentage so I can see how they rank. So I'm going to go ahead and show values as a percentage of the row total. And again, these total up to be a hundred percent. So this lets me see how this customer did each year. Okay, great. Now I'm going to add my sparklines. So I'll go to my insert. Going to go to my sparklines and I'll add my line, my data ranges here. And I want…
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.