What is SSAS?

When implemented as an on-premises server, SQL Server Analysis Services offers extensive support for multiple model types, such as tabular models at different compatibility levels depending on the version, multidimensional models, data mining features, and Power Pivot functionalities for SharePoint. The typical implementation process consists of establishing a SQL Server Analysis Services instance, creating either a tabular or multidimensional data model, deploying this model as a database to the server instance, processing it to fill it with data, and setting up user permissions to enable data access. After this setup is finalized, client applications compatible with Analysis Services can readily access the data model as a source. These data models often aggregate information from external systems, primarily retrieving data from data warehouses that utilize SQL Server or Oracle relational database engines; however, tabular models are also capable of connecting to various other data sources. This flexibility and range of capabilities underscore the strength of SQL Server Analysis Services as a formidable resource for analytics and business intelligence, allowing organizations to derive meaningful insights from their data. Ultimately, such robust functionality positions SQL Server Analysis Services as an essential component for enterprises aiming to enhance their analytical capabilities.

Integrations

Screenshots and Video

SSAS Screenshot 1

Company Facts

Company Name:
Microsoft
Date Founded:
1975
Company Location:
United States
Company Website:
docs.microsoft.com/en-us/analysis-services/ssas-overview

Product Details

Deployment
SaaS
On-Prem
Training Options
Documentation Hub
Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

SSAS Categories and Features

Business Intelligence Software

Ad Hoc Reports
Benchmarking
Budgeting & Forecasting
Dashboard
Data Analysis
Key Performance Indicators
Natural Language Generation (NLG)
Performance Metrics
Predictive Analytics
Profitability Analysis
Strategic Planning
Trend / Problem Indicators
Visual Analytics