What users are saying about
48 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
48 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Likelihood to Recommend

Anaconda

Anaconda is great for academic and private organizations that cannot afford more expensive Python/R package managers. Also, it is more appropriate for intermediate to advanced Python users--Anaconda can be somewhat frustrating for beginners, as it takes some practice to get comfortable with the workflow. I find it particularly useful for working in teams, because if everyone uses the same package manager, it is easier to troubleshoot issues and makes for reproducible research. For wealthier organizations, a premium package management system (with tech support) would be ideal. Anaconda is also great for people working independently on code development.
Maike Holthuijzen profile photo

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

Feature Rating Comparison

Platform Connectivity

Anaconda
7.0
Microsoft BI
Connect to Multiple Data Sources
Anaconda
10.0
Microsoft BI
Extend Existing Data Sources
Anaconda
8.0
Microsoft BI
Automatic Data Format Detection
Anaconda
3.0
Microsoft BI

Data Exploration

Anaconda
7.5
Microsoft BI
Visualization
Anaconda
8.0
Microsoft BI
Interactive Data Analysis
Anaconda
7.0
Microsoft BI

Data Preparation

Anaconda
7.5
Microsoft BI
Interactive Data Cleaning and Enrichment
Anaconda
8.0
Microsoft BI
Data Transformations
Anaconda
9.0
Microsoft BI
Data Encryption
Anaconda
6.0
Microsoft BI
Built-in Processors
Anaconda
7.0
Microsoft BI

Platform Data Modeling

Anaconda
8.1
Microsoft BI
Multiple Model Development Languages and Tools
Anaconda
10.0
Microsoft BI
Automated Machine Learning
Anaconda
6.5
Microsoft BI
Single platform for multiple model development
Anaconda
8.5
Microsoft BI
Self-Service Model Delivery
Anaconda
7.5
Microsoft BI

Model Deployment

Anaconda
6.5
Microsoft BI
Flexible Model Publishing Options
Anaconda
7.0
Microsoft BI
Security, Governance, and Cost Controls
Anaconda
6.0
Microsoft BI

BI Standard Reporting

Anaconda
Microsoft BI
8.0
Pixel Perfect reports
Anaconda
Microsoft BI
7.8
Customizable dashboards
Anaconda
Microsoft BI
7.9
Report Formatting Templates
Anaconda
Microsoft BI
8.2

Ad-hoc Reporting

Anaconda
Microsoft BI
8.4
Drill-down analysis
Anaconda
Microsoft BI
8.2
Formatting capabilities
Anaconda
Microsoft BI
8.4
Integration with R or other statistical packages
Anaconda
Microsoft BI
8.2
Report sharing and collaboration
Anaconda
Microsoft BI
8.9

Report Output and Scheduling

Anaconda
Microsoft BI
8.2
Publish to Web
Anaconda
Microsoft BI
8.3
Publish to PDF
Anaconda
Microsoft BI
8.8
Report Versioning
Anaconda
Microsoft BI
8.1
Report Delivery Scheduling
Anaconda
Microsoft BI
7.5
Delivery to Remote Servers
Anaconda
Microsoft BI
8.2

Data Discovery and Visualization

Anaconda
Microsoft BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Anaconda
Microsoft BI
8.4
Location Analytics / Geographic Visualization
Anaconda
Microsoft BI
7.9
Predictive Analytics
Anaconda
Microsoft BI
8.1

Access Control and Security

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

Mobile Capabilities

Anaconda
Microsoft BI
8.2
Responsive Design for Web Access
Anaconda
Microsoft BI
8.2
Dedicated iOS Application
Anaconda
Microsoft BI
8.4
Dedicated Android Application
Anaconda
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
Anaconda
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

Anaconda
Microsoft BI
7.8
REST API
Anaconda
Microsoft BI
7.9
Javascript API
Anaconda
Microsoft BI
8.3
iFrames
Anaconda
Microsoft BI
7.7
Java API
Anaconda
Microsoft BI
7.6
Themeable User Interface (UI)
Anaconda
Microsoft BI
7.8
Customizable Platform (Open Source)
Anaconda
Microsoft BI
7.5

Pros

Anaconda

  • Package Management. Some packages are difficult to install on different platforms. This is simplified with Anaconda.
  • Dedicated servers. More control over security.
  • Collaboration. Analysts can interact with and checkout notebooks and datasets.
No photo available

Microsoft BI

  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang profile photo

Cons

Anaconda

  • Easier migration to cloud sharing
Daniel Blazquez profile photo

Microsoft BI

  • Report Builder 3.0 shipped with MSSQL 2012 is a nice free tool but our client users sometimes encounter problems such as the tool automatically shut down without saving the changes being made. We haven't implemented the new RB with MSSQL 2016 yet thus cannot comment on the latest version.
Haibo Yang profile photo

Likelihood to Renew

Anaconda

Anaconda 7.0
Based on 1 answer
It's really good at data processing, but needs to grow more in publishing in a way that a non-programmer can interact with. It also introduces confusion for programmers that are familiar with normal Python processes which are slightly different in Anaconda such as virtualenvs.
Matthew Deakyne profile photo

Microsoft BI

Microsoft BI 8.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

Anaconda

Anaconda 8.0
Based on 1 answer
It's really good at installing and getting started. It's less usable and configurable after that. If you stay in the ecosystem, and don't know how to Python any other way - it works really well.
Matthew Deakyne profile photo

Microsoft BI

Microsoft BI 7.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

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 7.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

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 7.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

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 6.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

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 8.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

Anaconda

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Alternatives Considered

Anaconda

Other systems might be easier to set-up but Anaconda is a fairly flexible analytics toolkit. It can be configured in a way that truly matches the way in which your business or analytics department works. Built on top of lots of open source projects so things aren't siloed and you can avoid vendor lock-in.
No photo available

Microsoft BI

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo

Return on Investment

Anaconda

  • I am using the Opensource
SURA SREENIVASULU profile photo

Microsoft BI

  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

Pricing Details

Anaconda

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Anaconda Editions & Modules

Anaconda
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

Add comparison