Articles Databases Top 5 tools to get live data into Google Sheets from your SQL database, 2021 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 Written by Harry Marshall December 11, 2020December 11, 2020
Articles Securely connecting external tools to your GCP SQL database 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 Written by Tom Gardiner July 27, 2020July 27, 2020
Sprints Sprint 11: Dashboard Filters 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 Written by Tom Gardiner June 30, 2020June 30, 2020
Databases Top 7 tools to create an Entity Relationship Diagram (ERD), 2020 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. Written by Harry Marshall June 16, 2020November 4, 2020
Sprints Sprint 13: building a brand 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 Written by Harry Marshall May 18, 2020May 27, 2020
Sprints Sprint 10: creating a blog we WANT to write. 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 Written by Harry Marshall March 30, 2020March 30, 2020
Sprints Sprint 9: Make Filters Great Again 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 Written by Harry Marshall February 21, 2020May 27, 2020
Sprints Sprint 8: Addressing New World feedback 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 Written by Tom Gardiner December 16, 2019February 18, 2020
Sprints Sprint 7: Slack integration By far the most popular use-case of Trevor-to-Zapier by our customers is Trevor-to-Zapier-to-Slack, so in this sprint we’re adding a direct Trevor-to-Slack integration to smooth out that experience. Sprint goals: customers can receive notifications in a Slack channel whenever a chosen Trevor Written by Tom Gardiner November 8, 2019February 18, 2020
Sprints Sprint 6: New World Beta! The results of Sprint 4 are in and it’s a green light! The learning curve for new users was significantly improved and all test users were seen comfortably using the “New World” prototype to add, remove and edit query steps without difficulties. 🙌 The next stage is New Wo Written by Tom Gardiner October 17, 2019February 18, 2020