Google Sheets is an incredibly powerful tool for analyzing data, especially for non-technical teams who don’t have knowledge of SQL and still prefer spreadsheets to Business intelligence tools like Tableau, Looker, or Trevor.io (that’s us!). The challenge is that business data in a datab
You often need to connect external tools, like MySQLWorkbench, Postico and Trevor.io (disclaimer: I work here) to your Google Cloud Platform SQL database. This is a rapid step-by-step guide on how to do so. There are two steps required in order to connect to a SQL database on GCP: Identify the conne
The missing feature for dashboards is finally here. Dashboard filters! This means applying filters to some property (like “country” in the image below) and having that filter instantly apply to all relevant dashboard widgets. The way they work is that you can add multiple dashboard filte
An entity relationship diagram, ER Diagram, or ERD, is a visual model of your database schema. It shows your tables as boxes, with connecting lines representing the relationships between them. It’s a great way to design a new relational database or make sense of and/or modify an existing one.
A starting point for building a brand is communicating clearly and consistently. In this sprint, this is what I wanted to focus on. We’ve iterated on every part of our product many, many times without having the “brand” conversation. I think this is pretty normal, especially in the
Once upon a time, there was a blog. This blog’s name was…well, I don’t really remember. It didn’t have many readers. It didn’t have much content to read, to be fair. It lived at blog.trevor.io, but really wanted to be at trevor.io/blog. That’s where all the other
If you’ve been following our sprint series, in which we detail what we’re working on, you’ll know that our primary focus since summer ’19 has been building “New World“, a new and improved version of Trevor.io’s interface. A major benefit of New World is that
So, the feedback on Sprint 6 came back thick and fast. Huge thanks to all of you who tried out the New World Beta and left us your feedback. Feedback was mainly very positive, which was great to hear, but among the feedback there were a few recurring themes: “The steps in the sidebar ar