Technology - Treasure Data Blog - Part 16

Technology

Four Reasons Presto is the Best SQL-on-Hadoop (That You Haven’t Heard Of)

Presto is an in-memory distributed SQL query engine developed by Facebook that has been open-sourced since November 2013. Presto has a number of key advantages over other SQL-on-Hadoop engines, yet these benefits are not widely recognized or understood. Reason #1: Presto is Plenty Fast Unlike ...

February 27, 2015

Eliminating Schema Rot in MPP Databases Like Redshift

The MPP database is an incredible piece of technology. These databases run large-scale analytic queries very quickly, making them great tools for iterative data exploration. With a cloud offering like Redshift ...

February 25, 2015

Managing the Data Pipeline with Git + Luigi

One of the common pains of managing data, especially for larger companies, is that a lot of data gets dirty (which you may or may not even notice!) and becomes scattered around everywhere. Many ad hoc scripts a...

February 5, 2015

Learn SQL by Calculating Customer Lifetime Value Part 2: GROUP BY and JOIN

This is the second installment of our SQL tutorial blog series. In the first part, we set up the data source with SQLite and learned how to filter and sort data. This time, we will learn two other key concepts ...

December 5, 2014

Learn SQL by Calculating Customer Lifetime Value Part 1: Setup, Counting and Filtering

Motivation As far as technical skills go, SQL is a really nice skill to have for product managers and product marketers. Instead of constantly running into performance issues in Excel or begging "technical" pe...

November 26, 2014

12 Open Source Software Innovations from Treasure Data Engineers

TD is proud to have some of the best technical minds in the world working on our unique managed service. When they’re not working on the TD Service or supporting our customers, many of our engineers continue ...

October 13, 2014

How to Get More Clicks for Digital Advertising: Step by Step Guide to Optimizing CTRs with Real-time Data + Machine Learning

In the digital advertising space, optimizing the CTR (Click Through Rate) is one of the major challenges to increasing the performance of the advertising networks. Often times, machine learning algorithms are used to optimize what ads are relevant to the incoming visitors by learning from the histo...

September 30, 2014

Sharing Insights with Saved Query

This feature allows people to easily share their ‘insights’ with other users on their account. People who can write SQL (e.g. engineers, data analysts, data scientists) can create a query to generate insights, then provide that query to others within their......

September 22, 2014

4 Steps to Big Data Analytics with Tableau and Treasure Data

While TD is a BI tool agnostic service, customers like retailer MUJI are using Tableau for the BI / Visual Analytics. In this article, we want to introduce our customers’ usage pattern of combining TD, Tableau Desktop and Tableau Server......

September 16, 2014

Big Data Visualization with Tableau and Treasure Data

TD has been heavily investing in our Result Output feature, which allows users to export the result of a job into other systems. The new Tableau Result Output feature allows TD users to put the query result directly into Tableau Server from......

16

The new table stakes for CPG? CDPs, says Futurum Research Learn why