SQL - Treasure Data Blog

Tag Archives for: "SQL"

September 13, 2016

Enhance your Google BigQuery with Treasure Data Result Output

Google BigQuery is the choice for many. It’s the go-to for interactive analysis of enormous datasets and can process billions of rows in seconds. With no infrastructure to manage and the need for an administ...

Calculate Salesforce Account Coverage with Treasure Data and SQL

Salesforce is the de facto cloud CRM tool for sales. But even though it’s ubiquitous in most sales organizations, there are still a few clear challenges to doing analytics with Salesforce: like limited visual...

Rolling Retention Done Right in SQL

SaaS's Most Important Metric: Retention If you are a product manager or in a growth role at a SaaS company, rolling retention (also called cohort analysis) is a key metric to monitor your growth. It's so important that every analytics service worth their salt (Google Analytics, Mixpanel,...

Webinar sum-up: Introducing the new Treasure Data Console

Compared to when we began, we have a lot more users and data ingested. So, if you’ve seen the spinning wheel lately, it was because the old console simply wasn’t optimized for the large volume of data we have today. We’ve added two things to......

Mixpanel Doesn’t Like SQL

A couple of weeks ago, Mixpanel released JavaScript Query Language (JQL) as a new way of analyzing event data inside Mixpanel. It's clear that the Mixpanel team has realized that giving non-clunky access to...

February 17, 2016

Elasticsearch, and How to Make it Faster for ALL Queries

With millions of downloads since launch, Elasticsearch has become the open-source tool of choice for full text search. Also, it has become increasing popular for analytics use cases thanks to its ease of setup and JSON-based RESTful API. Like any other technology, however, Elasticsearch excels i...