SSAS Description

When deployed as an on-premises server, SQL Server Analysis Services provides comprehensive support for various model types, including tabular models at all compatibility levels based on the version, multidimensional models, data mining capabilities, and Power Pivot features for SharePoint. The standard process for implementation involves setting up a SQL Server Analysis Services instance, designing either a tabular or multidimensional data model, deploying this model as a database to the server instance, processing it to populate with data, and configuring user permissions to facilitate data access. Once the setup is complete, client applications that are compatible with Analysis Services can easily utilize the data model as a source. These models typically gather data from external systems, primarily from data warehouses utilizing either SQL Server or Oracle relational database engines, though tabular models can connect to a variety of additional data sources. This versatility makes SQL Server Analysis Services a powerful tool for analytics and business intelligence.

Integrations

Reviews

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Company Details

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

Media

SSAS Screenshot 1
Recommended Products
Passwordless Authentication and Passwordless Security Icon
Passwordless Authentication and Passwordless Security

Identity is everything. Protect it with Duo.

It’s no secret — passwords can be a real headache, both for the people who use them and the people who manage them. Over time, we’ve created hundreds of passwords, it’s easy to lose track of them and they’re easily compromised. Fortunately, passwordless authentication is becoming a feasible reality for many businesses. Duo can help you get there.
Get a Free Trial

Product Details

Platforms
Web-Based
On-Premises
Types of Training
Training Docs
Customer Support
Online Support

SSAS Features and Options

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

SSAS User Reviews

Write a Review
  • Previous
  • Next