564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This blog shows how to create your first tabular project in Visual Studio
Part three of a four-part series of blogs
Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.
To create a tabular model, you're going to have to run Visual Studio. Here are two ways to do this:
|SQL Server Data Tools||Visual Studio|
SQL Server Data Tools is a name for that part of Visual Studio devoted to working with SQL Server Analysis, Reporting and Integration Services.
Once in Visual Studio, you should make sure that you can see the Solution Explorer and Properties windows in a convenient way, and also change start-up options so that Visual Studio works in the way you want it to. All of this is shown below!
You won't get far without Solution Explorer visible!
To display Solution Explorer, choose this option or (as the screen-shot shows) press CTRL + ALT + L.
You can show the Properties window by pressing F4, or by choosing this menu option:
Choose this option from the Visual Studio menu to display the properties window.
Every Visual Studio window has a pin at the top right. This can be in two positions (you can click on the pin to change its orientation). Vertical:
If the pin is vertical, the window will remain permanently visible, and you can drag it to a different position on your screen.
If the pin is horizontal, the window will be collapsed to the edge of the screen, but you can make it appear by moving your mouse over it.
There are a huge number of options that you can configure for Visual Studio, but the one I'd change first is what happens when you load Visual Studio. First show the options dialog box:
From the Visual Studio menu, choose Tools -> Options.
Now select the required option on the Startup tab:
Choose the Startup tab on the left, and choose what you want to happen when you load Visual Studio.
The most convenient thing is usually for Visual Studio to open the project that you were last working with, as shown in the screen shot above.
Now that we've tamed Visual Studio, it's time to create your first tabular project!
|Parts of this blog|
25 Aytoun Street