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
One Monitoring Tool for IT, OT and Cloud | Free Trial Icon
One Monitoring Tool for IT, OT and Cloud | Free Trial

Vendor-agnostic monitoring across on-prem servers, cloud platforms and OT devices, all in one dashboard. No more tool sprawl.

Modern infrastructure spans data centers, cloud platforms and factory floors, and every blind spot between them is a risk. PRTG supports SNMP, WMI, SSH and other standard protocols to monitor IT, OT and hybrid environments through one customizable dashboard. Build the views your team needs, from network health to application performance, without switching tools. Try PRTG free for 30 days now.
Try PRTG Free

Product Details

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

SSAS Features and Options

SSAS User Reviews

Write a Review
  • Previous
  • Next