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

SSAS full form is SQL Server Analysis Services.

Learn SSAS from Scratch

SSAS from Scratch

SSAS Cube development

SQL Basics would be the ideal

Multi-dimensional OLAP server as well as an analytics ee 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

· Managing[Backup and Restore]

· Monitoring & Trouble shooting

The basic concepts of OLAP include:

Cube

Dimension table

Dimension

Level

Fact table

Measure

Schema




DOWNLOAD
uploadgig.com