17 years helping Irish businesses
choose better software
Trevor.io
What Is Trevor.io?
Your Next-gen BI Tool
Enable your whole team to build reports, perform look ups, and get ad hoc answers from your data using a simple, intuitive query builder (or SQL).
Easily create beautiful visualisations, dashboards and reports:
- export into your favourite formats
- send alerts via email, Zapier or to Slack
- share internally with your team
- share with your customers via embedded dashboards
Trevor uses a secure, read-only transaction, and takes only 20 minutes to set up. dbt compatible.
Who Uses Trevor.io?
Trevor.io is the self-serve analytics tool for your business if you aspire to be a data driven organisation, or if data requests have become a distraction for your engineering and/or data teams.
Not sure about Trevor.io?
Compare with a popular alternative
Trevor.io
Reviews of Trevor.io
Alternatives Considered:
SQL + Analytics, the easy way
Pros:
I never learned SQL because I've been in a Mongo environment for a while, so I was a bit intimidated to have to learn that alongside all my other responsibilities. I also didn't want to bother my engineering team with requests.With Trevor.io, I could get started in literally 10 minutes analyzing everything I needed to know about our users, their usage, and set up Slack alerts so our team could stay informed of how users were engaging.
Cons:
There's nothing I can think of, it's been pleasant all round.
Alternatives Considered:
Quick and easy to get started, active development and great customer support
Comments: Trevor is an easy to use product with a great team behind it.
Pros:
It was very quick and easy to connect our database and get started creating queries and dashboards. Inviting team members and sharing resources was also very straight forward.During the months that we used Trevor, the product team released a lot of updates and improvements. Nice to see a product taking shape :)When I had issues I usually got a reply from Trevor's customer service within 30 minutes and they were often able to get me back on track right away.
Cons:
The visuals of dashboards was a bit limited wrt. adding static elements (text, images, "lines", sections). The UI for building dashboards could also be improved by adding tools for aligning and sizing elements evenly.
A great product to support making business decisions based on data insights
Comments: Love it. It changed the way we run our business.
Pros:
Trevor was easy to implement and start using. No costly/lenghty implementations but the ability to have relevant data insights on day one is what we absolutely love in using Trevor. It does take some understanding of the data structures of your databases but once you have those, Trevor will enable you to retrieve and visualize your data fast.
Cons:
It can be a bit limited in the sense that you're restricted to querying on one database, it is not possible to combine datasets from different databases. If that's a requirement, you probably need another solution. Also, the import/export function is relatively limited in number of records but depends on the plan you have.
Trevor.io is amazing
Comments: The features help us deliver insights to our customers, so it is a crucial application in our data stack. The support is amazing and they have consistently rolled out new features which add to the overall impact.
Pros:
The most impactful feature for us is the data delivery methods: Live streaming query results into a google sheet, daily emails of files, and daily sends to Amazon S3 buckets are all cornerstones of our data operations.Also, combining SQL with the in-app filters, and then exporting the entire thing as SQL is great
Cons:
The SQL editor could use some work. The window is quite small which is cumbersome when reviewing large queries. Also the auto-complete references your entire db, not just the table you're using. I find my self often writing code in my IDE (DataSpell) then pasting into Trevor once done, so not not a huge deal
Trevor has become a critical tool for our Product, Sales, Customer Success, and Finance teams
Comments: As mentioned in the title: "Trevor has become a critical tool for our Product, Sales, Customer Success, and Finance teams". In addition to using it for historical reporting, most of our teams use it in real time (on calls) to answer questions which come up during the call.
Pros:
I love that it democratises access to data for non-technical teams across our business. It was also quick to set-up and doesn't have a steep learning curve.
Cons:
As we've baked Trevor into our processes, we have found things which would make it even better and the Trevor team have been very keen to hear our feedback. E.g. changing the default background colour of charts from grey to white (so they can be used in documents).
Making SQL Easy
Comments: I have never interacted with the team at Trevor.io, but using this product has been a breeze. I would recommend!
Pros:
Trevor.io is great because it allows you to both write SQL or use the platform's plug and play method when creating reports and pulling data. For team members that are less familiar with SQL, this is a great intro pulling specific metrics.
Cons:
There is still a big learning curve when it comes to understanding how to best use Trevor.io. Much of it depends on your your own company structures data.
The ultimate single-source of truth
Comments: One of the best tools for startups and scaleups. Automation tools and data connectors are outstanding with respect to the market. Definitely high value to cost ratio!
Pros:
It's easy to use and every feature is useful - alerts, query constructor, data sdownload
Cons:
The onboarding process of the tool was almost non existing and not obvious. I think they improved it a lot in the past months.
I love using Trevor!
Pros:
Trevor has helped us massively in so many aspects and has empowered so many of our team to become data-driven. From reporting, to customer dashboards, to integrations that automate flows–it’s become an indispensable tool for us and has benefited company-wide operations massively!
Cons:
The only thing is having template dashboards but it is on the roadmap - so no cons really!
Very good tool to crunch data
Comments: Is a very good tool to allow people that are not specialized in data, to play with numbers and to understand the raw data behind databases.
Pros:
The easy of use and the customer service attention.
Cons:
The time to execute some queries; the visuals are not very attactive.
Trevor.io
Comments: Couldn't be happier.
Pros:
Trevor.io is fantastic! Very powerful tables with data that is extremely helpful to our team.
Cons:
Setting up and getting teammates acquainted with the software is a bit tricky
Easy to use, incredible support team
Pros:
As someone with no prior background in data analysis, Trevor has been really user-friendly and the platform has helped me greatly in my day-to-day work. The team offers great resources to help you understand the platform, regardless of your level of experience. They're always on hand to assist should you have any questions.
Cons:
No cons that I've noticed, anything that I've struggled with the team has always been very supportive in helping me find the solution.
Trevor usecase
Comments: I had a good experience + Customer support is really helpful in resolving issues.
Pros:
It helps to see the data easily + easy no coding platform
Cons:
sometimes it take time to load data into travor from Panoply
Leveraging data analysis simply
Comments: Thus far excellent, improving my overall knowledge of query structuring
Pros:
The ease of querying available data, as well as the overall presentation of data sets
Cons:
Certain perceived limitations would be mitigated by a searchable knowledgebase
Kierans Review
Comments: You're support team are very much appreciated
Pros:
Very simple and support are amazing, would
Cons:
Some things could be simplified further for people with minimal sequel backgrounds
WOW! Product and company are amazing
Comments: As the title suggests, we are very pleased, in all aspects.
Pros:
- Extremely easy to "setup" - No coding required(but you can still SQL) - You can export/display in many ways - 3rd party integrations and triggers
Cons:
The only thing we are missing are permissions on the table level.
Quicker and simpler
Comments: Overall, I am very happy at how easy it is to use, very pleasing visually and customer support is outstanding!
Pros:
How quick and easy it was compared to other BI tools. What took me hours in other tools, took a matter of minutes with Trevor.io.
Cons:
Slightly confused at how the credit system works.
Great tool for non-technical SQL users
Pros:
Great product that integrates well with our data, with an easy to use visual editor for creating complex queries.
Cons:
The product needs more granular security, but it is on their roadmap.
Great dashboard tool
Pros:
Easy to integrate with tools and share data across platforms
Cons:
The UI is hard to follow for some of the team