What users are saying about

Anaconda

Top Rated
33 Ratings

Anaconda

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

SQL Data Warehouse

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

Add comparison

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

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

Pros

  • Installing packages is very easy with Anaconda. Anaconda comes with 'anaconda navigator', a terminal-like utility from which you can easily install R packages and python libraries.
  • Launching R and python IDEs as well as Jupyter notebooks from anaconda navigator is simple, and Anaconda makes it very easy to keep these packages up-to-date.
  • I really like the fact that if you don't want to install the full version of Anaconda, you can opt to install a lightweight version (called Miniconda) that includes less python libraries and only core conda. I've installed it when I didn't want to take up as much disk space as Anaconda requires, but it works just the same.
Maike Holthuijzen 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

  • User Interface could be a little bit more clearer.
  • Error messaging can definitely be improved
No photo available
  • 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

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
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

  • 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.
No photo available
  • 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