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
From the course: Introduction to Analytics Engineering
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.