What users are saying about

Aginity

6 Ratings

GoodData

48 Ratings

Aginity

6 Ratings
Score 8.5 out of 101

GoodData

48 Ratings
Score 7.9 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

GoodData

It is great for classic BI reporting, especially on processes where volumes of data are not big.
Bulat Yapparov profile photo

Feature Rating Comparison

BI Standard Reporting

Aginity
GoodData
8.1
Pixel Perfect reports
Aginity
GoodData
7.6
Customizable dashboards
Aginity
GoodData
8.8
Report Formatting Templates
Aginity
GoodData
7.9

Ad-hoc Reporting

Aginity
GoodData
7.9
Drill-down analysis
Aginity
GoodData
8.8
Formatting capabilities
Aginity
GoodData
7.7
Integration with R or other statistical packages
Aginity
GoodData
6.8
Report sharing and collaboration
Aginity
GoodData
8.1

Report Output and Scheduling

Aginity
GoodData
8.4
Publish to Web
Aginity
GoodData
7.6
Publish to PDF
Aginity
GoodData
8.8
Report Versioning
Aginity
GoodData
8.3
Report Delivery Scheduling
Aginity
GoodData
8.9

Data Discovery and Visualization

Aginity
GoodData
7.7
Pre-built visualization formats (heatmaps, scatter plots etc.)
Aginity
GoodData
8.8
Location Analytics / Geographic Visualization
Aginity
GoodData
6.4
Predictive Analytics
Aginity
GoodData
8.0

Access Control and Security

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

Mobile Capabilities

Aginity
GoodData
6.4
Responsive Design for Web Access
Aginity
GoodData
7.6
Dedicated iOS Application
Aginity
GoodData
4.5
Dashboard / Report / Visualization Interactivity on Mobile
Aginity
GoodData
7.1

Pros

  • Transparent database -> table information. The columns for a specific table/view is listed out within the object browser, and the object browser is easy to navigate, for providing a clear picture of the tables/views, and what it's made up of. Including column data types, data length, and space usage. The object browser follows a collapsible format, breaking down databases by schema names, following with the table/view names, and then the columns specific to that table/view. This in my opinion, is easier than the object browser that Toad provides, where you have to select into a specific table in order to see it's contents and details, rather than being able to compare and have everything on one page.
  • The output window is easy for further data extraction, one can simply copy the data out onto an email, into an excel spreadsheet, or other places as necessary. Data could also be exported from the output window, into either excel spreadsheets, or CSV format files, without the need to convert between one or the other. A special area is reserved for dragging column headers into, and what it does is it groups information by that column. This allows flexible user grouping, without the need of writing SQL queries to group on columns. Often times, in my experience, I find the need to group columns on a to-go basis, where I review the data output, and find the need to group on certain columns for further research and analysis, this option allow me to manipulate the result I currently have, without the need to rerun a query for grouping inclusions.
  • Able to cascade query windows between different environments. I often need to cascade query windows between an UAT environment, a RESEARCH environment, and a PRODUCTION environment. To be able to cascade between them, and to reference queries and its results, is a huge plus, that I didn't find in some of the other products I've used. This allow me to reference information in between different environments, without the need to connect back and forth.
Roger Luo profile photo
  • Intuitive report and dashboard building tools allow users to customise their day-to-day interaction with the data.
  • Some of the standard data warehouse (DW) design patterns are implemented and come out of the box.
  • GoodData takes care of speed optimisation.
  • Customer support is very responsive and accessible.
Bulat Yapparov 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
  • Need to think like a marketer when developing a platform so it's responsive and mobile friendly.
  • It would be nice to have a closer relationship with understanding how all of the updates could impact me. Basically, when a new feature is rolled out, I watch the webinars, however, it's still at such a high level, I'm not sure how the new feature could be used for my circumstances. And since the team knows how the new features work and what my goals are, they have a much stronger understanding of how I could leverage the new features.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
GoodData8.1
Based on 14 answers
We still have a lot of data to synthesize.
No photo available

Usability

No score
No answers yet
No answers on this topic
GoodData9.0
Based on 1 answer
Each graph/report is defined on the dashboard, which makes it easier to understand what you're analyzing. Another simple example - we changed the standard metric of Region by User to our Region by Account in less than 10 minutes
Rob Gottschalk profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
GoodData7.0
Based on 1 answer
We are approximately one month since go-live. There has been one short outage.
Rob Gottschalk profile photo

Performance

No score
No answers yet
No answers on this topic
GoodData8.0
Based on 1 answer
Performance on refreshing metrics works well.
Rob Gottschalk profile photo

Support

No score
No answers yet
No answers on this topic
GoodData8.7
Based on 2 answers
During the one outage we were clearly communicated to that there was an issue, and that support was working to resolve it. The issue was resolved within an hour.
Rob Gottschalk profile photo

In-Person Training

No score
No answers yet
No answers on this topic
GoodData9.0
Based on 1 answer
Petr was a rock star - patient, knowledgeable, clear and easy to work with.
Mark Brennan profile photo

Online Training

No score
No answers yet
No answers on this topic
GoodData8.0
Based on 1 answer
GoodData implementation team was professional and courteous
Rob Gottschalk profile photo

Implementation

No score
No answers yet
No answers on this topic
GoodData9.0
Based on 2 answers
Thorough, professional and on time.
Rob Gottschalk profile photo

Breadth of Deployment

No answers on this topic
We have 5 departments, 22 users, and it's slowly being rolled out.
No photo available

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
Birst AnalyticsCloud 9PivotLinkQlikView
Mark Brennan profile photo

Collaboration and Sharing

No score
No answers yet
No answers on this topic
GoodData8.0
Based on 12 answers
Everyone loves it thus far.
No photo available

Data Integration

No score
No answers yet
No answers on this topic
GoodData8.4
Based on 12 answers
We have a lot of raw data that needs to have each field brought in separately into the project and that can get frustrating when I'm trying to build a report and I have to go back to my GD team to have them pull the field into the project.
No photo available

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
  • We gained better insight into our lead nurturing programs with much less effort. The data is presented in a clean and simple way that allows us to quickly view our main data points that drive business decisions.
  • Not only did it increase our employee efficiency, but it allowed us to provide better customer service to our clients. Having readily available data allowed us to pull reports for our clients within minutes.
Katie Bullinger profile photo

Pricing Details

Aginity

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

GoodData

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Required
based on implementation*
1.  subscription based on data volume
Additional Pricing Details
Pricing is available upon request based on implementation and data volume.