SSAS

SSAS-SQL Server Analytical Services is used to create cubes using data from data marts / data warehouse for deeper and faster data analysis to develop Online Analytical Processing (OLAP) solutions. Hence these Cubes are multi-dimensional data sources which have dimensions and facts (also known as measures) as its basic constituents.

MDX- Multi-dimensional expression is the query language used to query a cube, similar to the way T-SQL is used to query a table in SQL Server.

It allows users to analyze data with a host of tools including SSRS and Excel, SSAS enables the discovery of data patterns that may not be immediately apparent through the data mining features built into the product. It helps to  design and develop the SSAS cubes that make sense and organize that data.

SSAS Includes;

Reading data from a dimensional model, then Configuring a schema in BIDS (Business Intelligence Development Studio) and Creating dimensions, measures and cubes from this schema which makes Fine tuning cube as per the requirements and hence deploying the cube.