From the course: Introduction to Analytics Engineering

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Challenge: Build a simple data model

Challenge: Build a simple data model

(upbeat music) - [Instructor] We went through a lot of different ways to view a data model. For this challenge, we're going to write a model for Two Trees Olive Oil. Here, we want to build a new view or model that allows us to aggregate how much of each product was sold. You can go to the GitHub repo for the data and more instructions. To do this, we're going to have to join the Product table and the Orders table together. In this case, we aren't concerned with the specifics of the orders, so we can do a couple aggregations. good luck, have fun, and I'll see you in the solution video.

Contents