From the course: Learning Data Analytics: 1 Foundations

Challenge: Count and amounts of products

From the course: Learning Data Analytics: 1 Foundations

Challenge: Count and amounts of products

I hope you're excited about this challenge. We're going to take some of the skills we just learned and apply them. So here's the challenge. You need to combine first and last name with the customer key to create one field. You'll want to convert your product ID to text. And then you want to provide a separate data set that gives you a total number of products ordered, and also a total amount of sales for each product. Be sure to use the challenge data in your folder.

Contents