What users are saying about
6 Ratings
22 Ratings
6 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 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 is well suited for:
  • All type of organisations from small, medium to large enterprises applications
  • All type of users in an organisations - Business users , Analysts and consumers
  • Large clustering installation with high volume of transaction under Linux platform with high number of concurrent users
  • Low budget customer engagements
Samir Kumar Sahoo profile photo

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
  • Yellowfin’s Storyboard, Timeline and Collaborative tools make it easy to share data and insights across an organisation.
  • Strong Operational and Executive Dashboards that reflect the business KPIs and can send out prompts to people within the business based on rules.
  • Yellowfin makes it incredibly easy to create dynamic reports and dashboards which incorporate maps through locational intelligence functionality.
  • Yellowfin is a single license and all access is via a web browser making it perfect for both on-premise and cloud deployment. Mobile apps are also available.
  • User roles and source filtering allows Admin/IT to offer different functions/views by user group/role.
  • Mobile BI applications to support any device ..
  • API connectors ( YF 7.2 on the way in Mar16 ) for a range of third-party Web-based applications, data sources, Enterprises CRM/ERP apps & open data platform apps, including Salesforce, Google Analytics, Twitter, Youtube , Zoho CRM, XE.com & more coming to make endusers to integrate their applications for better benefits
  • Yellowfin Integration with Predictive analytical and Big Data processing tools like R, UDF, Spark to build rich applications for end users
Samir Kumar Sahoo profile photo

Cons

  • For one, I don't like how the parenthesis are automatically created as a set. Often times I only need to type one part of the parenthesis, but it creates a set of ( and ), forcing me to delete them because I didn't need the other half at where my cursor was. Same goes with any other sort of characters, such as ' '. I understand that it's suppose to be smart, but more often than not, it's causing more inconvenience and wasting more time, than actually saving time simply because it types an extra ) or ' for me.
  • The error message and the log. I would think there probably is a log somewhere, but the fact that I've been using Aginity for close to a year now, and I still haven't found something similar to a log, is saying something about this feature. A log is like a standard thing nowadays, for running codes, to check against what has happened with the code, and for debugging what you have done wrong within the code. It also contains error messages, and help you troubleshoot with a clearer picture. The error message display current is very small and hard to read, sometimes the error message itself is not as easy to understand either. I use SAS on a daily basis as well, I feel like SAS has done a way better job on this issue, than Aginity.
Roger Luo profile photo
  • The ability to predefine a colour for a specific graph as a selection option dynamically.
  • The ability to customise the label of a chart, especially with respect to performance related reporting graphs we need an increase in dynamic charting options to meet our more specialised requirements.
Nicky Downing 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

I use Aginity extensively for quick data research. Examples include figuring out what the table structure look like, how the data looks like, quick 100 record sample selection, creating a DDL with a list of the column names for further manipulation and analysis. However, for more complicated analysis, or processes that involve multiple steps, including the creation of temporary or permanent tables, I refer to SAS. Especially since SAS allows me to implement macro variables and programs, to automate and optimize repeatable processes.
Roger Luo 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
Yellowfin BI is able to connect to a wide range of data sources. Furthermore, the application comes with an inbuilt InMemory DB.
No photo available

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

  • I think Aginity really allows us to quickly dive into the data, by providing easy and quick access to our database. This allowed us to solve our business problems on an efficient and timely manner. But since it is not a critical component of our department, (a lot of people also use Toad for the same thing, since Netezza is retiring soon, and Aginity, which belongs to IBM, has had legal issues, and is no longer available to new hires of our department. It is sort of our legacy software.)
Roger Luo 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