SQL Server Analysis Service (SSAS) for Data Analysis

OLAP Databases are used to perform a much efficient data analysis in a data warehouse system. 

In the previous blog posts, we looked at basic concepts of data warehousing and SSIS options for ETL.

OLAP Analysis tools are connected to the data warehouse as shown in the above figure. 

In the Microsoft tools set, there are two tools to support OLAP databases, MDM Cubes and Tabular. 

Since SSAS is a different animal, we need to understand the hardware configurations required for SSAS in order to facilitate a better environment. In SSAS MDM cubes, we can create, KPI, Perspective and Hierarchies in order to provide better capabilities for the Data Analysis professionals. 

Apart from the functional properties, there are non-functional requirements such as OLAP database backup and monitoring. 

There are few other options to be covered and will update once those are published. 

List of articles for SSAS 

OLAP Cube in SQL Server

Implementing an SSAS Tabular Model for Data Analytics

SQL Server Analysis Services SSAS Hardware Configuration Recommendations

Create Key Performance Indicators KPI in a SQL Server Analysis Service SSAS Cube

Enhancing Data Analytics with SSAS Dimension Hierarchies

Improve readability with SSAS Perspectives

SSAS Database Management

Monitoring SQL Server Analysis Services with Extended Events