From the course: Learning Data Analytics: 1 Foundations
Challenge: Count and amounts of products
(upbeat electronic music) - [Instructor] 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 want to convert your product ID to text and then you want to provide a separate dataset 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.
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.
Contents
-
-
-
-
-
-
-
-
-
Convert data in Power Query4m 4s
-
Finding and removing duplicates8m
-
Changing case and replace values3m 37s
-
Combining data with merge columns4m 22s
-
Creating logical functions2m 46s
-
Building aggregate datasets4m 56s
-
Challenge: Count and amounts of products33s
-
Solution: Count and amounts of products3m 33s
-
-