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

Unlock this course with a free trial

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

Building total queries

Building total queries

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

Start my 1-month free trial Buy for my team

Building total queries

“

- [Instructor] Working with data over time, you will learn that sometimes you build datasets only to get to the totals. What I mean is the person who asked you for the top customers doesn't want to receive every single line of data that's required to get to the top customers. They just want that data that represents the top. We've gone through our process and we've confirmed our data is accurate. We've even created a query called customers list. This is customers without all the noise in the main table. We've confirmed that we have our orders and our details. So we're really ready to start working with the data to get that complete data set for top customers. Let's go ahead and take a look at the order table. So I'll go ahead and double-click orders. Now, what I want you to notice is that this has a ton of information. It has our order ID and our customer ID, but what it doesn't have is a total order amount. Let's open up order details. Order details also has the order ID and it has…

Contents