Welcome to The Second Phase Of the SSAS Tutorial
We Read The Data From Various Sources
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.
Read initial data for analysis of them
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.
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 2022
We are going to perform analyses on data.
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!
First, Right-Click on “Data Sources” and select the “New data source” option.
Click next In the Data Source Wizard window.
Select the second option and click on the “New” button in this section.
We want to create a new connection.
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.
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.
You see here that the name of my server and its database appears.
Select the option of “use this service account” and click “Next.”
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.
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.
What you see right now is what you see by the end of this step in this section.
Written by: Moslem Afrashteh
Get Exclusive SSAS Tips
That I Only Share With
Leave A Comment