From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

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

Solution: Products are not categorized

Solution: Products are not categorized

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Solution: Products are not categorized

“

(upbeat music) - [Instructor] Welcome back. I really hope you learned a lot with that example. Really, for some people, the light bulb goes off on joins. They are unstoppable. Let me show you how I would tackle this challenge. Okay, I'll start by going to create, I would bring up a query. All right, I'm going to go ahead and add my product table and my product subcategory because I know that's what I'm looking at. Now the very first thing I'll do is go hit those product counts. Okay, I only have 504, so I know I have less coming because I don't know how many are not categorized but I know of the 504, some of them are not, okay? Now I'm going to look for those key fields. So I'll expand my table here. Oh, I think I see it. So here's product subcategory. I'm going to left click and hold and drag it to product subcategory. All right, so my goal is to get a list of products so I'll get that product ID and name, I'll get that subcategory and the name. All right, let's run it and see what…

Contents