Information of news
2-07-2021, 22:57

SQL Server Analysis Services(SSAS)

Category: Tutorials

SQL Server Analysis Services(SSAS)
Created by VenkatM M | Published 5/2021
Duration: 1h 50m | 4 sections | 12 lectures | Video: 1280x720, 44 KHz | 742 MB
Genre: eLearning | Language: English + Sub
Learn SSAS from Scratch


What you'll learn
SSAS from Scratch
SSAS Cube development

SQL Basics would be the ideal
SSAS full form is SQL Server Analysis Services.
Multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data.
SSAS is an analysis service platform, which can be used to create and manage the analysis database.
SSAS Contains Preaggregated data , internally creates analysis database, and once the analysis database is ready, it can be used for many purposes
It has 2 variants Multidimensional and Tabular.
One or more cubes can be presented in the analysis database.
Advantages of SSAS:
· High performance reports
· Multidimensional data analysis
· Slice and data analysis
· Data mining purpose
Using the Cube Data Base or Analysis Data Base:
There are several client tools to use Analysis database.
a. Analyzing the cube database data in the SSDT/BIDS browser.
b. Using the PIVOT table in the excel application to connect and work with cube database.
c. Using Reporting tools (SSRS, Cognos) to generate the reports.
d. By writing the MDX queries in the cube database.
e. Using Panorama Novaview and ProClarity tools to analyze the data.
SSAS Developer Roles:
· Understanding the Data base structure
· Designing the cubes
· Scripting
· Mdx language
SSAS Admin Roles:
· Installation
· Configuration
· Deployment
· Processing
· Security
· Managing[Backup and Restore]
· Monitoring & Trouble shooting
The basic concepts of OLAP include:
Dimension table
Fact table


Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news