Home » SSAS Tutorial For Intermediate
5 / 5

Steps to Do an SSAS Project

ssas-tutorial-for-intermidiate-step1-data-source
ssas-tutorial-for-intermidiate-step1-data-source-view
ssas-tutorial-for-intermidiate-step3-construction-dimension-fact-cube
ssas-tutorial-for-intermidiate-step5-debugging
ssas-tutorial-for-intermidiate-step6-connect-to-application

This is a Complete Guide to SQL Server Analysis Services (SSAS) For Intermidiate| 2022.

 

This is a Complete Guide to SSAS for Beginners | 2022.

 

So let’s go!

When you want to perform an analytical project using SSAS (whether to practice or to perform an actual industrial project), you should take the following six steps in the same order as follows:

Data Source

data-source-in-ssas

Entry Point

Welcome to The Second Phase Of the SSAS Tutorial

We Read The Data From Various Sources

Up to here, you have gotten familiar with the main SQL Server Analysis Services (SSAS) concepts.

Now let me do the whole project process and work in the SSAS Cube environment in 6 efficient steps based on these concepts.

This practical section is equal to reading a 400-page book in the field of Microsoft Analysis Server, which I have prepared smartly and usefully in the form of these six steps!

I promise you that you will learn all the parts necessary for every Analysis Services project up to the point of delivering an actual industrial project.

Goal

Read initial data for analysis of them

Data Type

OLTP or Data Warehouse

The data source can either be OLTP data that we receive directly but must clean before analysis or data from a clean data warehouse.

Another point is that these data are not necessarily all from one place and may come from various sources.

Data Reading Environment

SQL Server 2019

We will read the data from here and store the final results of the analysis here.

Database Name

AdventureWorksDW2019

It was the AdventureWorksDW2019 we downloaded together in the last segment (SSAS Tutorial) and restored in the SQL server environment;

Now, we should read it here.

Data Analysis Environment

Visual Studio 2019

We are going to perform analyses on data.

Tools

Data Sources

Theory Prerequisites

Concepts: Architecture | OLTP | Data Warehouse

Create Data Source

Now that we have prepared everything, it is time to start our work.

Do you remember what we meant to do in the first step?

In this step, we will read the data from various sources.

We should specify the source of the data for the visual studio.

What was the source of our data in this training?

It was the AdventureWorksDW2019.

So we specify the data source at first.

So let’s go!

#1

First, Right-Click on “Data Sources” and select the “New data source” option.

create-data-source-in-ssas-01

#2

Click next In the Data Source Wizard window.

create-data-source-in-ssas-02

#3

Select the second option and click on the “New” button in this section.

We want to create a new connection.

create-data-source-in-ssas-03

#4

The Connection Manager window opens;

This window is where you need to specify your server name to connect.

 

  • Click the “Server Name” to see the list of servers.

  • Click the “Connect to a Database” to see the list of databases on that server.

  • Click the “Test Connection” to ensure that the connection between the data and server works properly.

create-data-source-in-ssas-04

#5

If everything is alright and the connection is made, we get a message indicating that the link has been created successfully.

Click on “ok” and hit “ok” again.

 

create-data-source-in-ssas-05

#6

You see here that the name of my server and its database appears.

Click next.

create-data-source-in-ssas-06

#7

Select the option of “use this service account” and click “Next.”

create-data-source-in-ssas-07

#8

Here I should specify a name for the data source, and I enter “AdventureWorksDW2019”. Then,

I hit “finish.”

We need this name in the next step.

create-data-source-in-ssas-08

Summary

Let’s summarize our discussion up to here:

What was the output of this step?

Specification of the source of the data we will perform analysis on, which was AdventureWorksDW2019 in our case.

First, we specified which server this database is on, then selected our desired database from that server.

#Final_Result

What you see right now is what you see by the end of this step in this section.

create-data-source-in-ssas-final-result

Written by: afrashteh

Get Exclusive SSAS Tips

That I Only Share With

Email Subscribers

Thank you for your message. It has been sent.
There was an error trying to send your message. Please try again later.

Leave A Comment