From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Challenge: Ad hoc presentation

Challenge: Ad hoc presentation

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Challenge: Ad hoc presentation

“

(upbeat music) - [Instructor] Here's our challenge. We've been asked to provide counts of POs and total amounts for each customer for a presentation. We want our data to be sorted by the total amount, highest to lowest. We also want to highlight the total counts of POs that are above the average, using red as an indication that these should be further explored. We also want to highlight the total amounts that are in the top 15% in green because they're the highest values, and, actually, they're good. We also want to display a line chart of the PO counts and embed it into a PowerPoint presentation. This is so our manager can discuss it with their leadership. Because our brand colors are blue, we want to leverage themes that are primarily blue. We'll use the ad hoc challenge files in our challenge folder. This challenge should take you five to ten minutes to perform.

Contents