From the course: SQL Server Analysis Services

Unlock this course with a free trial

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

Challenge: Create and test your model

Challenge: Create and test your model - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

Challenge: Create and test your model

“

(upbeat music) - [Instructor] In this challenge, we're going to provide additional practice by performing similar steps that we followed within the video. We're going to be creating a data model, and this time use a different database, so you have additional practice. The database that we're going to be using is the Worldwide Importers DW Standard database. The database is available here in GitHub and we are going to download and restore it. Here is the database and I'm going to go ahead and download it. Next, I'm going to open up SQL Server Management Studio, and I'm going to right click on the database and restore the database that I just downloaded. Now the database is in a device and it's in my Download folder. Going to go ahead and select my Download, say OK, and I'm going to go ahead restore it and I'm just going to use the defaults here. I'm going to go ahead and say OK and it restored successfully. So now…

Contents