This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. Getting started with tabular model Analysis Services Checking you have Analysis Services Tabular running Running and Customising Visual Studio (this blog) Creating a tabular project in Visual Studio This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

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.

Getting started with tabular model Analysis Services
Checking you have Analysis Services Tabular running
Running and Customising Visual Studio (this blog)
Creating a tabular project in Visual Studio

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 11 November 2015

Running and Customising Visual Studio

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!

Displaying the Solution Explorer and Properties Windows

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.

Choosing where/how to display windows in Visual Studio

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.

Or horizontal:

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.

Changing Visual Studio start-up options

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
Getting started with tabular model Analysis Services Checking you have Analysis Services Tabular running Running and Customising Visual Studio (this blog) Creating a tabular project in Visual Studio

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC