What users are saying about

Apache Spark

99 Ratings

Microsoft BI

602 Ratings

Apache Spark

99 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Microsoft BI

602 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Apache Spark

Spark is great as a workflow process and extract transform layer process tool. Is really good for machine learning especially for large datasets that can be processed in split file paralallelization. Spark streaming is scalable for close to real-time data workflow process.what it's not good for, is smaller subset of data processing.
Anson Abraham profile photo

Microsoft BI

Visualization of business data: it's good, fast, and cheap. What more can you ask? With more specialized visualization needs, use Tableau or write code. For complex scientific visualizations, write code.It's also so much easier communicating about the tool and its visuals to other people who don't spend their lives analyzing complex data. "It's Excel for Big Data!" is really quite simple.
Alexander Lubyansky profile photo

Feature Rating Comparison

BI Standard Reporting

Apache Spark
Microsoft BI
7.8
Pixel Perfect reports
Apache Spark
Microsoft BI
7.6
Customizable dashboards
Apache Spark
Microsoft BI
7.9
Report Formatting Templates
Apache Spark
Microsoft BI
7.8

Ad-hoc Reporting

Apache Spark
Microsoft BI
8.5
Drill-down analysis
Apache Spark
Microsoft BI
8.4
Formatting capabilities
Apache Spark
Microsoft BI
8.4
Integration with R or other statistical packages
Apache Spark
Microsoft BI
8.2
Report sharing and collaboration
Apache Spark
Microsoft BI
8.8

Report Output and Scheduling

Apache Spark
Microsoft BI
8.4
Publish to Web
Apache Spark
Microsoft BI
8.5
Publish to PDF
Apache Spark
Microsoft BI
8.6
Report Versioning
Apache Spark
Microsoft BI
8.7
Report Delivery Scheduling
Apache Spark
Microsoft BI
7.9
Delivery to Remote Servers
Apache Spark
Microsoft BI
8.1

Data Discovery and Visualization

Apache Spark
Microsoft BI
8.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Apache Spark
Microsoft BI
8.9
Location Analytics / Geographic Visualization
Apache Spark
Microsoft BI
8.4
Predictive Analytics
Apache Spark
Microsoft BI
8.3

Access Control and Security

Apache Spark
Microsoft BI
8.6
Multi-User Support (named login)
Apache Spark
Microsoft BI
8.5
Role-Based Security Model
Apache Spark
Microsoft BI
8.5
Multiple Access Permission Levels (Create, Read, Delete)
Apache Spark
Microsoft BI
9.0
Single Sign-On (SSO)
Apache Spark
Microsoft BI
8.3

Mobile Capabilities

Apache Spark
Microsoft BI
8.3
Responsive Design for Web Access
Apache Spark
Microsoft BI
8.2
Dedicated iOS Application
Apache Spark
Microsoft BI
8.6
Dedicated Android Application
Apache Spark
Microsoft BI
8.2
Dashboard / Report / Visualization Interactivity on Mobile
Apache Spark
Microsoft BI
8.1

Application Program Interfaces (APIs) / Embedding

Apache Spark
Microsoft BI
8.0
REST API
Apache Spark
Microsoft BI
8.1
Javascript API
Apache Spark
Microsoft BI
8.4
iFrames
Apache Spark
Microsoft BI
7.9
Java API
Apache Spark
Microsoft BI
7.8
Themeable User Interface (UI)
Apache Spark
Microsoft BI
7.9
Customizable Platform (Open Source)
Apache Spark
Microsoft BI
8.0

Pros

  • We used to make our batch processing faster. Spark is faster in batch processing than MapReduce with it in memory computing
  • Spark will run along with other tools in the Hadoop ecosystem including Hive and Pig
  • Spark supports both batch and real-time processing
  • Apache Spark has Machine Learning Algorithms support
No photo available
  • Wide variety of tools : Microsoft BI possesses a wide variety of tools to cater needs of presentation, performance caching, integration and ease of use.
  • Popular online and location communities : Online and local communities around Microsoft BI is very popular. You can find a lot of resources and helpful information online and within your communities more efficiently and effectively.
  • Tighter and broad integration options : Microsoft BI tools are very well integrated with other Microsoft products (Office 365, SharePoint, .NET Apps, Project Server etc...) and Line of Business (LOB) applications. Being a large player in BI domain, there are various third party components available which compliment MS BI.
Ved Mishra profile photo

Cons

  • Consumes more memory
  • Difficult to address issues around memory utilization
  • Expensive - In-memory processing is expensive when we look for a cost-efficient processing of big data
No photo available
  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft BI8.0
Based on 25 answers
Assuming that I will continue to have a need to monitor and report on the operational aspects of the organization using transactional data, Microsoft BI is a solid choice. Its kind of like how you still have legacy applications that serve a strong need that is critical to the day to day operations. The fact that the tools are similar to stuff the users have already been using makes the adoption and buy in that much easier.
Mashhood Syed profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

No score
No answers yet
No answers on this topic
Microsoft BI7.1
Based on 6 answers
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Jacob Saunders profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Breadth of Deployment

No answers on this topic
It was the main reporting tool used by all the different departments. It was used by the Executive level, operations, marketing, sales. Number of users were probably around 50. Types of users: VP's, Directors, Managers, Analysts.
Mashhood Syed profile photo

Alternatives Considered

There are a few newer frameworks for general processing like Flink, Beam, frameworks for streaming like Samza and Storm, and traditional Map-Reduce. I think Spark is at a sweet spot where its clearly better than Map-Reduce for many workflows yet has gotten a good amount of support in the community that there is little risk in deploying it. It also integrates batch and streaming workflows and APIs, allowing an all in package for multiple use-cases.
No photo available
-Tableau is clearly more cutting edge when it comes to data visualization and connecting to multiple data sources (support for MongoDB, Hadoop, etc).-Assuming your data is not that sophisticated, Microsoft BI is a great product. I would say its a good "all around" BI tool. It does a good job in building operational reports. The reports run very fast on the report server. Most IT folks and alot of business folks can get comfortable with this product and build their own reports. You can create a semantic layer for the business users to pull their own data from (and its drag and drop).-Microsoft BI pretty much smokes Crystal Reports, SAP Business Objects and even IBM Cognos (I have limited experience with Cognos but from what I saw, it was pretty horrible to use). When I say "smokes" I mean that Crystal Reports, SAP Business Objects IBM Cognos are like using Internet Explorer 6.0 and Microsoft BI is like using Firefox 2013. Why would you bother using such old products that haven't kept up with the needs of today's analysts? It's not so much about functionality as it is about UI design and a certain level of intuitiveness
Mashhood Syed profile photo

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Microsoft BI8.1
Based on 29 answers
The way it works is that the analyst/developer/report creator builds the report and publishes it to the report server. From there, anyone who is given access to the report (which is synched up with Active Directory for authentication) can view the report and download a copy of the report. When you download a copy of the report itself (not a PDF or XLS of the report but the report definition file) it actually will download the application (Report builder) along with the report definition file. From here you can edit the definition, share it with others etc. Access control is very simple because of how it synchs up with Active Directory
Mashhood Syed profile photo

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.6
Based on 28 answers
Microsoft BI allows for a large number of data sources to be imported and worked with easily. The data can be pulled real time or from a warehouse depending on the customer requirements. We did not pull data from a large number of disparate sources but multiple SQL databases can be connected to easily.
No photo available

Return on Investment

  • overall positive impact to the business for analysis of big data using hadoop file system
  • very well received by data scientists in the business despite its shortcoming on analytical dashboarding
Shiv Shivakumar profile photo
  • Provided visibility at the Transactions level from a profitability standpoint
  • Sales reps are now using BI Dashboards to measure their success not just net sales
  • Company now measures customers from as well at a profitability standpoint
Scott Lerner profile photo

Pricing Details

Apache Spark

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Apache Spark Editions & Modules
Apache Spark
Additional Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details