From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

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

Solution: Count and amounts of products

Solution: Count and amounts of products

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Solution: Count and amounts of products

“

(joyful music) - I do hope you enjoyed that challenge. Let me show you how I would attack it. Remember, there are different ways to get to the end result. So, if I do mine a little bit differently, don't worry. We'll know if we got the same totals or not. I'll begin by going to my data tab. I'll do table a range. I'll click okay. This will type into power query. One of the first objectives is to actually combine the first and last that've been customer key. And again, there were not a lot of instructions on how to make that look. So if you did something a little bit different it's okay. I want to start by grabbing my first name, holding my control key, and grabbing the last name. I'll merge those first. Okay. I want to separate those with a space and I'll call them first last. Okay. I'll go ahead and move my customer key over. I'll grab my first last. Hold my control key and do my customer key. I would like a dash between these so I'll go ahead and right click and merge columns. I'm…

Contents