Welcome to The Second Phase Of the SSAS Tutorial
We Read The Data From Various Sources
You have become familiar with the primary 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.
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.
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.
We are going to perform analyses on data.
Concepts: Architecture | OLTP | Data Warehouse
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.
Get Exclusive SSAS Tips
That I Only Share With
Save my name, email, and website in this browser for the next time I comment.
SQL Server BI
SQL Server DBA
SSAS Tutorial for Beginners
SSAS Tutorial for Intermediate
SSAS Data Mining
United States & Turkey
© Copyright 2021 - 2023 | All Rights Reserved | Powered by Nill2Bill