In the first edition, I’m showcasing tools that bring all the data in an organization, present in multiple siloes, to one destination of choice - a sophisticated data warehouse or the plain old spreadsheet.
Have a great week ahead!
OUR TOP POPULAR SaaS OF THE WEEK
Fivetran
2012 Founded, 4.2/5 on G2
I have personally been using Fivetran from their early days and it’s a heavy-lifting service that has pioneered the ELT (Extract-Load-Transform) revolution in the field of data engineering. In one line, it’s a no-code, (almost) one-click data gatherer for your data warehouse.
Using Fivetran is one of the easiest ways to populate your brand new Redshift, Snowflake, or BigQuery cluster with the data from all the tools that your organization uses. With 300+ connectors, encompassing every popular SaaS out there, it can get you all the data you need to start making sense of in an analytics team. And all this without needing any engineering help, whatsoever!
OUR TOP ASPIRING SaaS OF THE WEEK
Coefficient.io
2020 Founded, 4.9/5 on Google Workspace Marketplace
If Fivetran provides data for SQL-writing analysts, Coefficient makes it even more accessible by bringing all the data directly to a Google Spreadsheet. That makes it a delight for those spreadsheet ninjas that thrive on complex sheet formulas and an astonishing amount of linking of cells together.
With the humble spreadsheet still being the most used analytical tool in the world (by a huge margin), Coefficient really democratizes data in a true sense for non-technical marketing, sales, and operations teams. It removes dependencies on technical teams for their day-to-day reports as well as for any exploration they would feel like doing. If you feel stiffled by lengthy timelines for your basic data requests, try Coefficient and say goodbye to creating get-me-data tasks that never get done.
OUR TOP NEW SaaS OF THE WEEK
Sherloq
2022 Founded, Y-Combinator W23
Most people who write SQL to analyze data are haunted by the fact that almost all SQL remains on their computer, completely inaccessible to anyone on their team. Github-like tools for data analysis haven’t become popular yet, and Sherloq is the latest attempt to make collaboration easier for SQL analysts.
Three things it does well:
Connects with your existing query editor (instead of being another one of them)
Works in the browser via a Chrome Extension, so super easy to start with
Organizes SQL queries in folder structures
It’d be great to see how Sherloq goes from here and if it is able to solve the collaboration problem at scale.
That’s all for this week. The next edition of the newsletter will arrive on Wednesday, April 26.
Cheers,
Ankur
Note: This newsletter is inspired by The Watch - check them out here.
I have read about Sherloq and love the idea! Great finds btw.