Alteryx Analytics vs Toad Data Point

Alteryx Analytics

I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.

Read full review

Susan Knolla

Director People Analytics

J.D. Irving, LimitedPaper & Forest Products, 10,001+ employees

View all 33 answers on this topic

Toad Data Point

An example of how we use Toad Data point is we have to connect data from external datasets outside of our company for government agents, access databases that we have built over the years, sharepoint lists and our core company data within an Oracle database. We previously had to do a very cumbersome process of exports to excel and try and pivot data. Now we can do it extremely quickly.

Read full review

Andrew Kuhn

System Analyst Manager

CignaHealth, Wellness and Fitness, 10,001+ employees

View all 7 answers on this topic

Feature Rating Comparison

Alteryx Analytics

7.9

Toad Data Point

8.6

Pixel Perfect reports

8.0

7.2

Customizable dashboards

6.7

9.0

Report Formatting Templates

9.0

9.7

Alteryx Analytics

8.5

Toad Data Point

8.8

Drill-down analysis

8.3

Formatting capabilities

8.2

8.4

Integration with R or other statistical packages

9.5

10.0

Report sharing and collaboration

8.0

8.7

Alteryx Analytics

8.7

Toad Data Point

8.8

Publish to Web

8.2

9.0

Publish to PDF

8.5

8.3

Report Versioning

9.0

9.6

Report Delivery Scheduling

8.9

9.1

Delivery to Remote Servers

—

8.0

Alteryx Analytics

7.9

Toad Data Point

8.1

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

8.0

7.8

Location Analytics / Geographic Visualization

7.5

8.0

Predictive Analytics

8.3

8.5

Alteryx Analytics

8.3

Toad Data Point

9.8

Multi-User Support (named login)

8.0

9.3

Role-Based Security Model

8.0

10.0

Multiple Access Permission Levels (Create, Read, Delete)

9.0

10.0

Single Sign-On (SSO)

—

10.0

Alteryx Analytics

4.0

Toad Data Point

8.6

Responsive Design for Web Access

4.0

8.6

Alteryx Analytics

—

Toad Data Point

9.5

REST API

—

9.0

Javascript API

—

8.6

iFrames

—

10.0

Java API

—

9.5

Themeable User Interface (UI)

—

10.0

Customizable Platform (Open Source)

—

10.0

Pros

Designing dashboards is very easy and intuitive in Alteryx. Although some form of analytical aptitude is needed, most of it is very user friendly.
Embedding R or Python Code is fairly straightforward in Alteryx. This makes it very sophisticated for data analysis and predictive data modelling.
Effective mathematical calculations-- which are difficult to code in SQL-- are very easy to write in Alteryx.

Read full review

Kunal Sonalkar

Data Research Analyst

Southwest Florida Water Management DistrictHigher Education, 5001-10,000 employees

View all 33 answers on this topic

Accesses and extracts data from 20 or more different data stores.
Can include data selection even from data stored in Excel spreadsheets.
Can automate a flow of tasks (some call it workflows) to provide an easy and automated solution, freeing the analyst from these types of data processing.
Analysts don't need to know the SQL query language at all. Toad Data Point has a comprehensive Query Builder that allows for the selection from a large variety of data stores to be included in a single output data request.
The data cleansing ability is top-notch. The analyst can 'fix' data at the data extract time. Of course, filtering (data selection) is an integral part of Toad Data Point...in both locating data to include as well as the data from each data store being included.

Read full review

Dan Hotka

Author/Instructor/Oracle Expert

Pearson EducationComputer Software, 1-10 employees

View all 7 answers on this topic

Cons

Improved Maps/ GeoCoding system for geographical analysis should be there.
Running data extracts can be made more efficient. Tableau does it much better.
Cross-Database joins should be allowed and the data extraction should be much simpler.

Read full review

Kunal Sonalkar

Data Research Analyst

Southwest Florida Water Management DistrictHigher Education, 5001-10,000 employees

View all 33 answers on this topic

At times the tool does seem a little slow some speed tweaks would be welcome.
To make it even more intuitive adding intellisense would be nice.
A data presentation dash would be a nice touch to customize data.

Read full review

Robb Glietz

Technology Advisor

RE/MAX Advantage RedlandsReal Estate, 51-200 employees

View all 7 answers on this topic

Likelihood to Renew

Alteryx Analytics6.5

Based on 14 answers

Alteryx has become integral to my job and to the expectation of upper management. They have now become accustomed to the lightening quick turnaround that Alteryx can provide. Not renewing Alteryx would take our department, and me, back to what would seem like the dark ages. Additionally, Alteryx (the company) is very aggressive in improving and upgrading Alteryx (the program) on a continual basis. It is very clear that they are in constant search for new features, capabilities and improvements. They do not rest on their laurels.

Read full review

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

View all 14 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Usability

Alteryx Analytics10.0

Based on 2 answers

Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.

Read full review

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

View all 2 answers on this topic

Toad Data Point8.0

Based on 1 answer

We use this product every day. It is invaluable to us.

Read full review

Verified User

Team Lead in Information Technology

Higher Education Company, 1001-5000 employees

View all 1 answers on this topic

Reliability and Availability

Alteryx Analytics10.0

Based on 1 answer

I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.

Read full review

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Support

Alteryx Analytics9.9

Based on 2 answers

Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available

Read full review

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Implementation

Alteryx Analytics10.0

Based on 1 answer

There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.

Read full review

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Alternatives Considered

I have used Tableau Desktop. We selected Alteryx because of the better pricing options they had for our firm. Although Tableau has amazing features like data blending, story designing dashboards, parameters switches, geo coding, etc. Alteryx provides decent solutions in most of these areas as well.Tableau Servers and licenses are very expensive on a per-user basis, and here Alteryx wins hands down.

Read full review

Kunal Sonalkar

Data Research Analyst

Southwest Florida Water Management DistrictHigher Education, 5001-10,000 employees

View all 33 answers on this topic

We have tried to use Tableau to try and accomplish a similar set of goals as we do with Toad Data Point. Toad is much more efficient once we have the data connections setup. We are able to easily drag and drop data sources. There are some advantages with Tableau but overall Toad has been a better utilization of our time.

Read full review

Andrew Kuhn

System Analyst Manager

CignaHealth, Wellness and Fitness, 10,001+ employees

View all 7 answers on this topic

Return on Investment

Definitely, an increase in employee efficiency. With the right tools and hardware, Alteryx can reduce the processing time significantly.
Automation and/or automatic report scheduling frees up a lot of time that can be used elsewhere.
Licensing updates are somewhat not handled easily and quite often create issues with modules to run slowly and/or not being active.

Read full review

Verified User

Analyst in Other

Retail Company, 10,001+ employees

View all 33 answers on this topic

No answers on this topic

Ask the community to sound off