Azure Analysis Services vs. Azure Data Lake Analytics

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Analysis Services
Score 8.6 out of 10
N/A
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.N/A
Azure Data Lake Analytics
Score 8.4 out of 10
N/A
Microsoft's Azure Data Lake Analytics is a BI service for processing big data jobs without consideration for infrastructure.N/A
Pricing
Azure Analysis ServicesAzure Data Lake Analytics
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure Analysis ServicesAzure Data Lake Analytics
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Azure Analysis ServicesAzure Data Lake Analytics
Top Pros

No answers on this topic

Top Cons

No answers on this topic

Features
Azure Analysis ServicesAzure Data Lake Analytics
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Azure Analysis Services
8.7
10 Ratings
7% above category average
Azure Data Lake Analytics
-
Ratings
Pixel Perfect reports8.810 Ratings00 Ratings
Customizable dashboards8.89 Ratings00 Ratings
Report Formatting Templates8.510 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Azure Analysis Services
8.9
10 Ratings
10% above category average
Azure Data Lake Analytics
-
Ratings
Drill-down analysis9.08 Ratings00 Ratings
Formatting capabilities8.99 Ratings00 Ratings
Integration with R or other statistical packages8.89 Ratings00 Ratings
Report sharing and collaboration9.110 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Azure Analysis Services
9.0
10 Ratings
8% above category average
Azure Data Lake Analytics
-
Ratings
Publish to Web9.110 Ratings00 Ratings
Publish to PDF8.99 Ratings00 Ratings
Report Versioning9.39 Ratings00 Ratings
Report Delivery Scheduling8.910 Ratings00 Ratings
Delivery to Remote Servers8.89 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Azure Analysis Services
9.0
9 Ratings
11% above category average
Azure Data Lake Analytics
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)9.38 Ratings00 Ratings
Location Analytics / Geographic Visualization9.19 Ratings00 Ratings
Predictive Analytics8.68 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Azure Analysis Services
9.2
10 Ratings
8% above category average
Azure Data Lake Analytics
-
Ratings
Multi-User Support (named login)9.29 Ratings00 Ratings
Role-Based Security Model9.310 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.110 Ratings00 Ratings
Single Sign-On (SSO)9.39 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Azure Analysis Services
8.8
9 Ratings
10% above category average
Azure Data Lake Analytics
-
Ratings
Responsive Design for Web Access8.58 Ratings00 Ratings
Mobile Application9.45 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.67 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Azure Analysis Services
8.8
9 Ratings
11% above category average
Azure Data Lake Analytics
-
Ratings
REST API8.97 Ratings00 Ratings
Javascript API8.77 Ratings00 Ratings
iFrames9.06 Ratings00 Ratings
Java API8.98 Ratings00 Ratings
Themeable User Interface (UI)8.36 Ratings00 Ratings
Customizable Platform (Open Source)9.25 Ratings00 Ratings
Best Alternatives
Azure Analysis ServicesAzure Data Lake Analytics
Small Businesses
BrightGauge
BrightGauge
Score 8.9 out of 10
Klipfolio
Klipfolio
Score 8.5 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
Alteryx
Alteryx
Score 9.0 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
Alteryx
Alteryx
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Analysis ServicesAzure Data Lake Analytics
Likelihood to Recommend
9.1
(11 ratings)
8.7
(6 ratings)
User Testimonials
Azure Analysis ServicesAzure Data Lake Analytics
Likelihood to Recommend
Microsoft
We would have many technical issues and glitches with previous similar providers but found that Azure Analysis Services can simply handle our workload and memory better. I remember we lost an account due to cloud issues not fully saving or corrupting some files. Granted, this is rare with any cloud but haven't had that issue with the same load of memory with Azure Analysis Services.
Read full review
Microsoft
Azure Data Lake Analytics services are beneficial when working with a lot of data. It can process enormous amounts of data extremely quickly. Service is secure and easy to set up, build, scale, and run on Azure. Regarding big data analytics and reporting, parallel processing has a significant impact. It consolidated our analytics from multiple systems and increased our analysis productivity. This tool has excellent support for reporting tools like Power BI and is very quick when performing analytics.
Read full review
Pros
Microsoft
  • 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.
Read full review
Microsoft
  • Process large data transformation jobs using pretty much any language needed.
  • Native integration with Azure storage.
  • Top notch security that fulfills all audit needs.
  • Easy to consolidate enterprise data under one location - Single source of truth.
Read full review
Cons
Microsoft
  • 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.
Read full review
Microsoft
  • There's a bit of bias towards cloud with ADL Analytics. Depending upon a company's infra strategy and investment plans, there are some challenges with migration and integeration.
  • Not worth the time/effort/money if the organization doesn't have "Volume" of data. Cost effective only when daily loads exceed around 1million.
  • While training materials are available online, Adoption rate - Yet to pick up.
Read full review
Alternatives Considered
Microsoft
The best thing about it is the ability to create a query and drill down the data to a more granular level when needed. The best thing about Azure Analysis Services is. It provides secured access anytime from anywhere, it also provides REST API for this, which is very easy to use, and it provides video tutorials for beginners means you get the whole package of learning and implementation!!
Read full review
Microsoft
We did some research about Alibaba Cloud Data Lake Analytics and even being cheaper than Azure Data Lake Analytics, we decided to go for the second one once we noticed they have more features and better documentation. Another thing we considered during this process was the fact that we have more people that already have Azure Cloud knowledge.
Read full review
Return on Investment
Microsoft
  • Azure Analysis Service scale resources to match our business needs.
  • Helps us to govern, deploy, test and deliver our BI solution with confidence.
  • Stores our business data and clients data in a safe place where it's easy to access and visible to all our teams.
Read full review
Microsoft
  • It lets us manage and scan data, making our work easy and efficient.
  • It helped me manage real-time data, process it, and send it to reporting.
  • Data centralization or data warehousing projects are being implemented with its help.
Read full review
ScreenShots