What users are saying about
Top Rated
41 Ratings
Top Rated
41 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
13 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

Anaconda

Anaconda shines if you need to set up a data analysis or data science lab in no time. Newcomers to Python or Jupiter can be up and running in minutes and playing with the most popular packages. I think the Anaconda Cloud package could benefit from some UX improvements to clarify the migration process. Integration with external data sources could be improved as well.
Daniel Blazquez profile photo

SQL Data Warehouse

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
No photo available

Feature Rating Comparison

Data Exploration

Anaconda
7.5
SQL Data Warehouse
Visualization
Anaconda
7.0
SQL Data Warehouse
Interactive Data Analysis
Anaconda
8.0
SQL Data Warehouse

Data Preparation

Anaconda
7.0
SQL Data Warehouse
Interactive Data Cleaning and Enrichment
Anaconda
7.0
SQL Data Warehouse
Data Transformations
Anaconda
8.0
SQL Data Warehouse
Data Encryption
Anaconda
6.0
SQL Data Warehouse
Built-in Processors
Anaconda
7.0
SQL Data Warehouse

Platform Data Modeling

Anaconda
5.7
SQL Data Warehouse
Automated Machine Learning
Anaconda
4.0
SQL Data Warehouse
Single platform for multiple model development
Anaconda
7.0
SQL Data Warehouse
Self-Service Model Delivery
Anaconda
6.0
SQL Data Warehouse

Model Deployment

Anaconda
4.5
SQL Data Warehouse
Flexible Model Publishing Options
Anaconda
5.0
SQL Data Warehouse
Security, Governance, and Cost Controls
Anaconda
4.0
SQL Data Warehouse

Pros

  • Integration of the most popular and useful Python packages
  • Managing multiple execution environments
  • Management of package dependencies
Daniel Blazquez profile photo
  • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
  • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
  • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
No photo available

Cons

  • Easier migration to cloud sharing
Daniel Blazquez profile photo
  • It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task.
  • It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on.
  • It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the SQL Data Warehouse.
No photo available

Alternatives Considered

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
SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
No photo available

Return on Investment

  • Extremely quick turnaround time to set up data science experiments
  • Reduction of troubleshooting time when deploying new packages and dependencies
  • Low risk environment due to the community edition
Daniel Blazquez profile photo
  • It definitely has a positive impact on ROI. We are able to use it to generate MORE revenue through predictive analytics and pricing optimization.
  • Because of the SQL Data Warehouse design, we're able to set up some self service reporting tools which allow our users to generate reports ad hoc instead of having a full time employee creating these by hand.
  • Having visibility into the data is very useful for management to make good business decisions.
No photo available

Pricing Details

Anaconda

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

SQL Data Warehouse

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