What is Analysis Services?
Analysis Services (SSAS) is an online analytical processing (OLAP) engine and data mining tool that is part of SQL Server. Users are able to design, create, and manage multidimensional structures coming from multiple databases, disparate tables, and/or files. Analysis Services stores data in multi-dimensional cubes with pre-aggregated data, allowing for faster data analysis. With the release of SQL Server 2012, Microsoft released Tabular Mode as a new enhancement to Analysis Services. This was a deep plunge into the world of self-service BI as tabular models extend on concepts that are easier to understand and use than multidimensional models.
Analysis Services supports Data Definition Language (DDL), Data Manipulation Language (DML), and many different sets of APIs.
Analysis Services 2016
The release of SQL Server 2016 brought along with it a number of enhancements to Analysis Services. Microsoft continues to focus their efforts toward tabular models and the 2016 release puts that on full display. Highlighted in the release are modeling concepts like display folders for organizing your measures and out of the box bi-directional relationships. There are also many improvements to the tabular language, DAX. Additionally, Analysis Services is available as a cloud service in Azure.
Get the Most out of Your Analysis Services Solution
We here at Key2 Consulting have diversified and extensive experience with Analysis Services. We’ve used it to help our clients answer difficult questions by:
- implementing complex MDX and scoping statements
- incorporating complex many-to-many relationships
- designing complex SSRS reports with Analysis Services OLAP sources
- applying ragged hierarchies for parent-child dimensions having a varying number of levels
If you are considering implementing Analysis Services, or if you desire a custom tool that fits your exact business needs, we can help. Simply fill out the contact form below and we will be in touch shortly.