TrustRadius: an HG Insights company

Azure Analysis Services

Score7.9 out of 10

46 Reviews and Ratings

Get a Demo

What is Azure Analysis Services?

Azure Analysis Services delivers enterprise-grade BI semantic modeling capabilities with the scale, flexibility, and management benefits of the cloud. Azure Analysis Services helps transform complex data into actionable insights. Azure Analysis Services is built on the analytics engine in Microsoft SQL Server Analysis Services.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Azure Analysis Services has to offer, as determined by TrustRadius' reviewers.
Based on 46 ratings of Azure Analysis Services's features
View all features

Top Performing Features

  • Mobile Application

    A dedicated app for iOS and/or Android.

    Category average: 7.4

  • Single Sign-On (SSO)

    Allows users to use one set of login credentials to access multiple applications

    Category average: 8.5

  • Report Versioning

    Report versioning is the assignment of version numbers to each version of a report to help in tracking.

    Category average: 8.4

Areas for Improvement

  • Report Formatting Templates

    Category average: 8.1

  • Responsive Design for Web Access

    Web design aimed at producing easy-to-read sites across a range of different devices.

    Category average: 7.9

  • Dashboard / Report / Visualization Interactivity on Mobile

    In-app dashboard reports and data visualization.

    Category average: 7.9

Reviews

What users are saying about Azure Analysis Services.
View all reviews

"Microsoft's best cloud tool, Best for analytics"

Incentivized
Abhishek NandiView profile
Sr. Engineer in Research & Development at GreyOrange (1001-5000 employees employees)

Use Cases and Deployment Scope

Azure Analysis Services support various data sources like Azure SQL server, On-prem SQL, Oracle, etc. We can run models and various analytics services. The burden of maintaining servers and storage is not there as it is supported by Azure and is offered as a Platform as a service.

Pros

  • Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, trusted tabular semantic data model.
  • I have used AAS in establishing the Tabular Semantic model for one of my client's assignments.

Cons

  • There is very least content available on Microsoft docs and the Internet to get through with AAS.
  • i faced lots of connection issues while implementation.
  • The need for serious platform experience or expertise.

Return on Investment

  • Website analytics; We have realized so many benefits like traffic analysis, CRM, click-through funnels, and many more.
  • Aas allows us to do complex calculations and aggregations at slight efforts. It accommodates DAX expression, which in return is simple to apply.

Alternatives Considered

Amazon Web Services

Other Software Used

Google AdSense, Google Cloud AI, Amazon Connect

Can't Go Wrong With It!

Incentivized
Verified User
Manager in Human Resources (51-200 employees employees)

Use Cases and Deployment Scope

I've used this at two companies recently. It seems like when a truly large amount of data is needing to be stored in a cloud with the best security possible, Azure Analysis Services has been where we turn to. We love the security it gives our organization and how simple it is to use as well. Convenience is what I enjoy most as a user.

Pros

  • Cloud storage
  • Seemless layering
  • Most affordable cloud service we've used so far
  • Very secure

Cons

  • A better interface design would be more visually appealing.

Return on Investment

  • Its been significantly more affordable
  • Easy to implement so less training time

Other Software Used

IBM Cloud Backup

The best business analysis tool for any organization: MicrosoftAzure Analysis Services

Incentivized
Verified User
Engineer in Engineering (10,001+ employees employees)

Use Cases and Deployment Scope

Microsoft Azure Analysis Services is among one of the most helpful and advanced business intelligence tool. This solution is offered as a platform as a service. It is packed with great features and functionalities which makes the business more productive and drives the revenue growth as many critical decision are based on the analysis of this service. The solution can be integrated with different types of Azure services which makes our work easier. We use this tool for different type of use cases like providing secure access, analyzing data, getting insights, providing role based access, depth analysis of data and for other data related use cases. The tool has proved it's worth and never disappointed us.

Pros

  • Providing role based access or we can say privilege based on the role to the user if it is integrated with Azure active directory and hence securing the access to sensitive data.
  • We use to run different type of analytics services to get the better result which is hectic if done manually or with human efforts.
  • We also use to collect bulk of data with the help of this tool and run customized test cases for better efficiency of result and better decision making. The result are very crucial and helps in taking big decision.
  • It supports different or we can say heterogeneous database vendors like the Oracle, SQL, and hence make the task easy.

Cons

  • Microsoft Azure Analysis Services is very costly solution and in that price we can get some better business intelligence tool with lot more of capabilities
  • The dashboard or we can say user interface is complex and need time to understand and gain expertise in order for proper working.
  • It needs continuation monitoring which is sometime a big task.
  • Sometime, the tool shows unusual behavior and become unstable, so we need to clear temp files for proper functioning.

Return on Investment

  • The tool has helped us a lot for taking critical decision which has resulted in the increase of profit of organization by 18 percent.
  • Return on investment is 70 percent as we are unable to utilize the tool with full functionalities, so we are still testing some of the use cases.
  • Human effort has been reduced and task has become automated hence helped in cost management

Alternatives Considered

InsideSales.com / XANT PowerDialer for Salesforce (discontinued), AWS Trusted Advisor, IBM Analytics Engine and Google Analytics

Other Software Used

Forescout Continuum, Skybox Security, Fortinet FortiGate

Worth your investment

Incentivized
Verified User
Employee in Research & Development (201-500 employees employees)

Use Cases and Deployment Scope

We use this product in our organization for Data modeling that is further used for BI tools and excels to get analytics. This data is then used for generating insights and taking actions accordingly.

Pros

  • Analytics
  • Generating insights
  • Provides platform as a service for data models

Cons

  • Interface is challenging for beginners
  • Regular monitoring is needed.

Return on Investment

  • It greatly helped us to get combined analytics on data from different sources
  • Easily manageable in the organization
  • No negative impact till now

Alternatives Considered

HRMantra Software and TIMi

Other Software Used

Microsoft Teams, OneDrive, Microsoft Visual Studio Code

Good Analytics Tool

Incentivized
Verified User
Engineer in Engineering (1-10 employees employees)

Use Cases and Deployment Scope

Great product for Analytics and Visualizations of Data. Easy to scale and very powerful. Can add Role based authorizations to the dashboards as well to limit who views what. Easy to connect to various types of data sources. It also has the option to export dashboards in PDF, etc. Should definitely try it out.

Pros

  • Visualizations
  • Analysis
  • Dashboarding
  • RBAC

Cons

  • Documentation
  • Drill Down & Up Capabilities
  • Ability to connect to external sources of data

Return on Investment

  • Good Impact
  • Not too cheap
  • Can do better with pricing

Alternatives Considered

SAP Analytics Cloud