Learn SSAS from Scratch
What you'll learn
SSAS from Scratch
SSAS Cube development
Requirements
SQL Basics would be the ideal
Description
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.
\n
SSAS Developer Roles:
· Understanding the Data base structure
· Designing the cubes
· Scripting
· Mdx language
SSAS Admin Roles:
· Installation
· Configuration
· Deployment
· Processing
· Security
· Managingackup and Restore
· Monitoring & Trouble shooting
The basic concepts of OLAP include:
Cube
Dimension table
Dimension
Level
Fact table
Measure
Schema