SQL Server Analysis Services (SSAS) | Zinovate Academy

SQL Server Analysis Services SSAS is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing OLAP solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.

Cubes are multi-dimensional data sources which have dimensions and facts also known as measures as its basic constituents. From a relational perspective dimensions can be thought of as master tables and facts can be thought of as measureable details. These details are generally stored in a pre-aggregated proprietary format and users can analyze huge amounts of data and slice this data by dimensions very easily. Multi-dimensional expression - MDX is the query language used to query a cube, similar to the way T-SQL is used to query a table in SQL Server.

In this tutorial we will step through a number of topics

Creating and deploying a cube
Extend hierarchies and exploit advanced dimension relationships
Configuring many-to-many dimension relationships
Building aggregations
Implement Key Performance Indicators to monitor business objectives
Cube storage mode - MOLAP, ROLAP and HOLAP
Implementing an action to open a Reporting
Services report or to analyse data using Excel
Automating cube processing with an XMLA script
MDX Query language

For more updates on courses and tips follow us on: