Tag Archives for: "SQL"

September 13, 2016

Enhance your Google BigQuery with Treasure Data Result Output

Stay tuned for our video of this integration! 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. W...

Calculate Salesforce Account Coverage with Treasure Data and SQL

You can check out the video of this integration. 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 d...

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

Recently, we released the latest Treasure Data Console as a public beta. We also produced a short webinar last week explaining the main goals of the new release. If you missed it, you can get a summary here. Those main goals are: Goal 1: Performance Compared to when we began, we have a lot more...

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 raw event data emp...

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