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.
Creating your first Analysis Services project - SQL Server Tutorial
From the course: SQL Server Analysis Services
Creating your first Analysis Services project
- [Instructor] Here we're going to create our analysis services project. So to create our analysis per services project, we'll want to go to Visual Studio 2022 and select Create a new project. The project that we want to create is for analysis services. So we want to select an Analysis Services Tabular Project and say Next. You can put this project in a number of different locations, I'm going to go ahead with a default and I'm going to call this SampleProject and I'm going to go ahead and say Create. But before that, I want to make sure that I place the solution and project in the same directory, 'cause it just makes things easier. In the Tabular model designer window, we're going to want to select the Integrated workspace. This option allows us to integrate with our local host. Underneath a compatibility level, this determines what version of analysis services you are going to be installing to. It's defaulted to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Introduction to data modeling in Analysis Services Tabular1m 6s
-
(Locked)
Creating your first Analysis Services project2m 10s
-
(Locked)
Create a data source to SQL Server3m 8s
-
(Locked)
Adding other data sources4m 13s
-
(Locked)
Challenge: Create and test your model4m 17s
-
(Locked)
Solution: Create and test your model5m 10s
-
-
-
-
-
-
-