What users are saying about

Aginity

6 Ratings

Yellowfin

22 Ratings

Aginity

6 Ratings
Score 8.5 out of 101

Yellowfin

22 Ratings
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

Aginity

Aginity is well suited for writing ad-hoc queries and data analysis, having all of the features that data analysts come to expect in a database querying tool. Aginity is also great for basic operation and management allowing an engineer or DBA to store multiple databases and credentials, see how tables are distributed or sorted, and see table sizes and row counts. However, for more advanced database management another tool or the RedShift console is still required
Jordan Squire profile photo

Yellowfin

Yellowfin BI is well suited within a self service BI scenario for many end users as well as for BI projects with only limited IT staff resources (department driven BI). It is also well suited whenever the ease of use and a clear user interface is necessary.
No photo available

Feature Rating Comparison

BI Standard Reporting

Aginity
Yellowfin
7.8
Customizable dashboards
Aginity
Yellowfin
7.9
Report Formatting Templates
Aginity
Yellowfin
7.7

Ad-hoc Reporting

Aginity
Yellowfin
8.1
Drill-down analysis
Aginity
Yellowfin
8.3
Formatting capabilities
Aginity
Yellowfin
7.6
Integration with R or other statistical packages
Aginity
Yellowfin
8.3
Report sharing and collaboration
Aginity
Yellowfin
8.3

Report Output and Scheduling

Aginity
Yellowfin
8.1
Publish to Web
Aginity
Yellowfin
8.2
Publish to PDF
Aginity
Yellowfin
8.0
Report Versioning
Aginity
Yellowfin
7.7
Report Delivery Scheduling
Aginity
Yellowfin
8.3

Data Discovery and Visualization

Aginity
Yellowfin
7.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Aginity
Yellowfin
7.3
Location Analytics / Geographic Visualization
Aginity
Yellowfin
7.7
Predictive Analytics
Aginity
Yellowfin
6.5

Access Control and Security

Aginity
Yellowfin
7.9
Multi-User Support (named login)
Aginity
Yellowfin
8.0
Role-Based Security Model
Aginity
Yellowfin
7.8
Multiple Access Permission Levels (Create, Read, Delete)
Aginity
Yellowfin
7.8

Mobile Capabilities

Aginity
Yellowfin
8.5
Responsive Design for Web Access
Aginity
Yellowfin
9.1
Dedicated iOS Application
Aginity
Yellowfin
8.5
Dedicated Android Application
Aginity
Yellowfin
8.2
Dashboard / Report / Visualization Interactivity on Mobile
Aginity
Yellowfin
8.5

Pros

  • Query auto-completion
  • Database exploration including schemas, tables, columns, distribution keys, sort keys, etc.
  • Common scenario query samples, and easy access to table DDL
  • Table size operational report
  • Free community edition
Jordan Squire profile photo
  • Ease of use due to a clear and good structured user interface
  • Easy to administrate and to develop new BI content even for personnel without IT background
  • Powerful features for collaboration and sharing (social BI)
  • Very helpful documentation (wiki), support portal and monthly webinar series
No photo available

Cons

  • It would be helpful if the table size report could make it more obvious which tables need to be vacuumed. You can figure it out with the report, but can't just glance down a list.
  • Error message windows often auto close before you can read them leaving me hovering my finger over the print screen trying to capture them.
  • The auto-complete feature is a bit finicky. Many common scenarios which happen while writing a query by hand such as an unclosed parenthesis can cause the auto-complete not to trigger.
Jordan Squire profile photo
  • Initially the Yellowfin business model was difficult to align to the VSV model but through some simple negotiations a workable model was reach which made in commercial application viable
  • Some additional licensing models could also be of value as we do not use the product in a pure business intelligence only application.
Johan Pietersen profile photo

Usability

No score
No answers yet
No answers on this topic
Yellowfin8.2
Based on 1 answer
Web-based centralised architecture with best user interfaces.
Samir Kumar Sahoo profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Yellowfin9.1
Based on 1 answer
99.9% availability
Samir Kumar Sahoo profile photo

Support

No score
No answers yet
No answers on this topic
Yellowfin8.2
Based on 1 answer
  • Availability of 24x7x365 support team to cover all regions
  • Technical team well trained
  • Knowledge of product
  • Proper product documentation and support guidelines
  • Defined SLA
Samir Kumar Sahoo profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Yellowfin9.1
Based on 1 answer
Yellowfin provides 3 levels of training to support consumers, business analytics, developers and Administrations :
  1. Yellowfin BI Training - Level 1 (Exploration)
  2. Yellowfin BI Training - Level 2 (Advanced)
  3. Yellowfin BI Training - Level 3(Expert)
Samir Kumar Sahoo profile photo

Online Training

No score
No answers yet
No answers on this topic
Yellowfin8.2
Based on 1 answer
Web-based training for large audiences for Level 1 and Level 2 I would suggest
Samir Kumar Sahoo profile photo

Implementation

No score
No answers yet
No answers on this topic
Yellowfin9.1
Based on 1 answer
Design the data model and views for each dashboard is very important and it is the success factor Configuration of cluster for large implementation
Samir Kumar Sahoo profile photo

Alternatives Considered

Like all of the other various SQL querying tools that I have used, the Aginity Workbench for RedShift has a free community version. Although unlike many of the other tools that I have used, Aginity feels like a tool that I would be willing to pay for. It is feature rich and stable.
Jordan Squire profile photo
Yellowfin BI has a strong focus on a clear structured and easy to use user interface. Furthermore, the licence model was adequate for a BI system with a lot of end users.
No photo available

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Yellowfin8.1
Based on 6 answers
The sharing and collaboration features of Yellowfin BI are a very powerful part of the BI application. Reports can be shared, distributed, broadcasted and embedded (e.g. into websites) with only a few clicks.
No photo available

Data Integration

No score
No answers yet
No answers on this topic
Yellowfin8.1
Based on 6 answers
The Yellowfin product has most datasources and supports data merging at a dynamic and interactive level. It also supports the Pintl strategy around multiple system sources of data brought into an abstracted cubed environment.
Johan Pietersen profile photo

Scalability

No score
No answers yet
No answers on this topic
Yellowfin8.2
Based on 1 answer
- Tested 500 con-current users in Linux platform with 4 cores systems - Tested with cloud based VM - Tested with 1000 reads per minutes
Samir Kumar Sahoo profile photo

Return on Investment

  • Since the tool is free it doesn't take much to get a positive ROI.
  • Since RedShift is a PostgreSQL derivative, tools designed for that DB can be used to access RedShift. However, it is much nicer to have a tool that is RedShift aware and understands the slight differences.
  • Query auto-completion makes writing queries much quicker and less error prone.
  • The database management features are a nice plus that many comparable tools for RedShift and other databases don't provide.
Jordan Squire profile photo
No answers on this topic

Pricing Details

Aginity

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

Yellowfin

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