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

Solution: Getting started

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

Solution: Getting started

“

- [Instructor] Now, it's important to remember that your information may vary from mine. But if you got close or have some of the same types of information then you've done great on this challenge. The goal was to provide the top 50 customers based on their order amounts. And the business role that I determined was top customers based on the highest amount on any single order. Now that could vary based on customer. I also listed out the potential noise, like PickedByPersonID, and PickingCompletedWhen, and LastEditedBy information. I also had some additional questions like, does back order matter for this report? And then also I listed out my certain requirements like, make a copy of the data, remove the noise, confirm that I don't have any duplicates, do a multisort, remove duplicates, sort by the highest dollar amount, filter for the top 50, and then copy it to a new sheet. Again, these requirements could vary. As long as you wrote out how you would start the process and the information you needed, then you did great on this challenge.

Contents