Anaconda vs Microsoft Power BI

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.

Read full review

Maike Holthuijzen

Ph.D student

University of VermontHigher Education, 5001-10,000 employees

View all 12 answers on this topic

Microsoft Power BI

Do:

One time data analysis/reporting where you want to have some visual representations to help you understand your data.
Create dashboards that can help you take business decisions and just generally help you know if your business is on track.
With a pro license: deploy dashboards that can be consumed by other users.

Don't

Use a Pro install for regulatory reports (Static reports should be created with a reporting tool if available to avoid duplicating tools and costs).
Deploy at large (anyone can have it installed) if data governance is important in your organization. It should really be a tool used by people that really understand the data and how to merge it (integrating different sources).

Read full review

Mathieu Gaouette

Consultant BI senior/Administrateur - spécialité SAS

Prospective MG inc.Banking, 10,001+ employees

View all 57 answers on this topic

Feature Rating Comparison

Anaconda

7.5

Microsoft Power BI

—

Visualization

7.0

—

Interactive Data Analysis

8.0

—

Anaconda

7.0

Microsoft Power BI

—

Interactive Data Cleaning and Enrichment

7.0

—

Data Transformations

8.0

—

Data Encryption

6.0

—

Built-in Processors

7.0

—

Anaconda

5.7

Microsoft Power BI

—

Automated Machine Learning

4.0

—

Single platform for multiple model development

7.0

—

Self-Service Model Delivery

6.0

—

Anaconda

4.5

Microsoft Power BI

—

Flexible Model Publishing Options

5.0

—

Security, Governance, and Cost Controls

4.0

—

Anaconda

—

Microsoft Power BI

8.0

Pixel Perfect reports

—

7.7

Customizable dashboards

—

8.4

Report Formatting Templates

—

7.9

Anaconda

—

Microsoft Power BI

8.2

Drill-down analysis

—

8.5

Formatting capabilities

—

8.1

Integration with R or other statistical packages

—

8.0

Report sharing and collaboration

—

8.2

Anaconda

—

Microsoft Power BI

7.9

Publish to Web

—

8.8

Publish to PDF

—

7.8

Report Versioning

—

7.8

Report Delivery Scheduling

—

7.8

Delivery to Remote Servers

—

7.3

Anaconda

—

Microsoft Power BI

8.1

Pre-built visualization formats (heatmaps, scatter plots etc.)

—

8.4

Location Analytics / Geographic Visualization

—

8.5

Predictive Analytics

—

7.5

Anaconda

—

Microsoft Power BI

7.9

Multi-User Support (named login)

—

8.2

Role-Based Security Model

—

7.3

Multiple Access Permission Levels (Create, Read, Delete)

—

7.9

Single Sign-On (SSO)

—

8.3

Anaconda

—

Microsoft Power BI

7.8

Responsive Design for Web Access

—

7.9

Dedicated iOS Application

—

7.8

Dedicated Android Application

—

7.8

Dashboard / Report / Visualization Interactivity on Mobile

—

7.8

Anaconda

—

Microsoft Power BI

7.2

REST API

—

7.6

Javascript API

—

7.4

iFrames

—

7.1

Java API

—

6.4

Themeable User Interface (UI)

—

7.4

Customizable Platform (Open Source)

—

7.1

Pros

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.

Read full review

Verified User

Analyst in Marketing

Marketing and Advertising Company, 501-1000 employees

View all 12 answers on this topic

Easily connect to multiple databases or cloud solutions.
Possibility to modify datasets or change formatting in Power BI vs having to modify data at the source.
Since Power BI can cache locally some of the data, it's possible to continue working offline on datasets.

Read full review

Francois Salvert

Web Analytics and Data dashboarding (consulting mandate)

Keolis CanadaOnline Media, 1-10 employees

View all 57 answers on this topic

Cons

User Interface could be a little bit more clearer.
Error messaging can definitely be improved

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 12 answers on this topic

A bit heavy to run and not that intuitive compared to other tools.
Dashboarding is really a pain compared to other tools and the visualization provided with the tool are not what you should expect.
Very very frequent updates that require you to reinstall the software almost on a monthly basis. Will need admin rights from your organization.

Read full review

Francois Salvert

Web Analytics and Data dashboarding (consulting mandate)

Keolis CanadaOnline Media, 1-10 employees

View all 57 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

Ask the community to sound off

Microsoft Power BI10.0

Based on 1 answer

I find it helpful and easy to use

Read full review

jim paroly

Freelance Photographer

j. paroly photoGraphic Design, 1-10 employees

View all 1 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Ask the community to sound off

Microsoft Power BI8.9

Based on 3 answers

PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts

Read full review

Rohit Acharya

Business Intelligence Manager

ZALORA GroupInternet, 1001-5000 employees

View all 3 answers on this topic

Alternatives Considered

Anaconda is way easier to set-up. On Anaconda we have users working on Machine Learning in minutes, where on PyCharm is takes a lot longer to set-up and often involves getting help from IT. PyCharm is easier to integrate with Code repositories (such as GitHub), so if that's very important to you, you might want to take a look at PyCharm

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 12 answers on this topic

Power BI stacks up robustly on a visuals standpoint. It has great slicer tools and visuals that are stunning. Content is fresh, easy to transmit and the design of a new dashboard is easy. Power BI is useful in identifying outliers in your data (even data integrity issues). Great tool for visuals. What BI does lack is the CPM functionality to add and save data and/or entries. This can be a detractor for areas such as finance.

Read full review

Verified User

Employee in Finance and Accounting

Medical Devices Company, 51-200 employees

View all 57 answers on this topic

Return on Investment

We can get any new employee set-up on Python for Machine learning in minutes, without any assistance from IT. That's real $ savings.
We started to experiment with Machine Learning a lot more, which leads to creating new projects which can have a tremendous impact on the business.

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 12 answers on this topic

It's a good start for setting up customized dashboards.
Available for all users based on Office 365 platform we have in place.
Doesn't really allow depth of report - specifically customization of visual displays.

Read full review

Mark Metz

Enterprise Services Consultant

Bristol-Myers SquibbPharmaceuticals, 10,001+ employees

View all 57 answers on this topic

Pricing Details

Anaconda

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Additional Pricing Details

—

Microsoft Power BI

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Additional Pricing Details

—

Rating Summary

Anaconda vs Microsoft Power BI

Add comparison

Likelihood to Recommend

Anaconda

Microsoft Power BI

Feature Rating Comparison

Visualization

Interactive Data Analysis

Interactive Data Cleaning and Enrichment

Data Transformations

Data Encryption

Built-in Processors

Automated Machine Learning

Single platform for multiple model development

Self-Service Model Delivery

Flexible Model Publishing Options

Security, Governance, and Cost Controls

Pixel Perfect reports

Customizable dashboards

Report Formatting Templates

Drill-down analysis

Formatting capabilities

Integration with R or other statistical packages

Report sharing and collaboration

Publish to Web

Publish to PDF

Report Versioning

Report Delivery Scheduling

Delivery to Remote Servers

Pre-built visualization formats (heatmaps, scatter plots etc.)

Location Analytics / Geographic Visualization

Predictive Analytics

Multi-User Support (named login)

Role-Based Security Model

Multiple Access Permission Levels (Create, Read, Delete)

Single Sign-On (SSO)

Responsive Design for Web Access

Dedicated iOS Application

Dedicated Android Application

Dashboard / Report / Visualization Interactivity on Mobile

REST API

Javascript API

iFrames

Java API

Themeable User Interface (UI)

Customizable Platform (Open Source)

Pros

Cons

Likelihood to Renew

Usability

Alternatives Considered

Return on Investment

Pricing Details

Anaconda

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Additional Pricing Details

Microsoft Power BI

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Additional Pricing Details

Rating Summary