17 years helping Irish businesses
choose better software

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.

Trevor.io Software - Use the no-code query builder to get answers from your data
Trevor.io Software - Visualise your data in highly-customisable graphs
Trevor.io Software - Easily create beautiful interactive dashboards

Not sure about Trevor.io? Compare with a popular alternative

Trevor.io

Trevor.io

4.8 (18)
US$75.00
month
Free version
Free trial
95
3
4.8 (18)
4.3 (18)
4.9 (18)
VS.
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
US$10.00
month
Free version
Free trial
30
15
4.6 (24)
4.8 (24)
4.4 (24)
Green rating bars show the winning product based on the average rating and number of reviews.

Other great alternatives to Trevor.io

Retool
Top rated features
Drag & Drop
Web/Mobile App Development
Workflow Management
Looker
Top rated features
Data Visualisation
Multiple Data Sources
Reporting/Analytics
Sisense
Top rated features
Data Visualisation
KPI Monitoring
Reporting/Analytics
Redash
Top rated features
Dashboard
Publishing/Sharing
Visual Analytics
Metabase
Top rated features
Dashboard
Key Performance Indicators
Visual Analytics
Adriel
Top rated features
Dashboard
Performance Metrics
ROI Tracking
MicroStrategy Analytics
Top rated features
Data Connectors
Data Visualisation
Performance Metrics
Yellowfin
Top rated features
Data Import/Export
Data Visualisation
Reporting/Analytics
Qlik Sense
Top rated features
Data Import/Export
Data Visualisation
Reporting/Analytics

Reviews of Trevor.io

Average score

Overall
4.8
Ease of Use
4.8
Customer Service
4.9
Features
4.4
Value for Money
4.3

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001

Find reviews by score

5
78%
4
22%
Ahmad
Ahmad
VP of Product in Canada
Verified LinkedIn User
Computer Software, 11–50 Employees
Used the Software for: 1-5 months
Reviewer Source

Alternatives Considered:

SQL + Analytics, the easy way

5.0 2 years ago

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.

Christofer
CTO in Sweden
Information Technology & Services, 2–10 Employees
Used the Software for: 1-5 months
Reviewer Source

Alternatives Considered:

Quick and easy to get started, active development and great customer support

5.0 2 years ago

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.

Bart
Product Owner in Netherlands
Retail, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

A great product to support making business decisions based on data insights

4.0 2 years ago

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.

Terence
Data Analyst in US
Internet, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Trevor.io is amazing

5.0 2 years ago

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

Kevin
Head of Product in UK
Internet, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Trevor has become a critical tool for our Product, Sales, Customer Success, and Finance teams

5.0 last year

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).

Sarah
Sarah
Program Ops Manager in US
Verified LinkedIn User
Computer Software, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Making SQL Easy

5.0 3 years ago

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.

Alexandros
Alexandros
Product Owner in Italy
Verified LinkedIn User
Financial Services, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

The ultimate single-source of truth

5.0 2 years ago

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.

Nathalie
Onboarding Lead in UK
Information Technology & Services, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

I love using Trevor!

5.0 2 years ago

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!

Sasha
BI project manager in France
Consumer Services, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Very good tool to crunch data

4.0 2 years ago

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.

Jack
Jack
Co-Founder in US
Verified LinkedIn User
Food & Beverages, 2–10 Employees
Used the Software for: 1-5 months
Reviewer Source

Trevor.io

5.0 6 years ago

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

Kirsten
Operations Executive in UK
Hospital & Health Care, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

Easy to use, incredible support team

5.0 2 years ago

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.

Shrikant
Business Analyst in Ireland
Health, Wellness & Fitness, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Trevor usecase

5.0 2 years ago

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

Kaleem
Support Agent in Spain
Hospitality, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

Leveraging data analysis simply

5.0 2 years ago

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

Kieran
Marketing Executive in UK
Education Management, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Kierans Review

4.0 2 years ago

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

Yair
Operations manager in Israel
Nonprofit Organisation Management, 11–50 Employees
Used the Software for: 1-5 months
Reviewer Source

WOW! Product and company are amazing

5.0 4 years ago

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.

Catherine
Platform Lead in UK
E-Learning, 2–10 Employees
Used the Software for: 1-5 months
Reviewer Source

Quicker and simpler

5.0 2 years ago

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.

Manuel
CIO in US
Marketing & Advertising, 51–200 Employees
Used the Software for: 1-5 months
Reviewer Source

Great tool for non-technical SQL users

5.0 3 years ago

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.

Liam
Liam
Digital Marketing in UK
Verified LinkedIn User
Hospitality, 11–50 Employees
Used the Software for: 1-5 months
Reviewer Source

Great dashboard tool

4.0 6 months ago

Pros:

Easy to integrate with tools and share data across platforms

Cons:

The UI is hard to follow for some of the team