Enterprise Customer Data Platform - Treasure Data Blog - Part 29

December 22, 2015

How Data Is Transforming Our Design

Earlier this year, I joined Treasure Data as the team's first UX Designer. I'm here to craft delightful experiences for data scientists, analysts, and fellow data lovers. Since its inception, Treasure Data's product strategy has been to roll with the punches by responding expertly to individual ...

November 17, 2015

Getting Direct, SQL Access to Your Mixpanel Data in 6 Easy Steps

I have a love hate relationship with Mixpanel. The love part is fairly obvious: Mixpanel allows users to create funnels with minimal technical integrations, and its visualization and reporting functionality have improved tremendously over the years. Interested in which campaign is performing best...

November 16, 2015

Postgres + Presto = Prestogres, My Nifty Hack for Putting Them Together

When I co-founded Treasure Data four years ago, our primary database was MySQL. Since then, I have grown to love “the other” open source RDBMS: PostgreSQL. There are many reasons to love PostgreSQL, and I plan to share my thoughts on Postgres' internals this week at PGConf 2015 Silicon Valley...

November 6, 2015

Spark Community By the Numbers: A Few Surprises

Without a doubt, Apache Spark is taking the data science world by storm. An open-source, in-memory distributed data processing engine that can run atop Hadoop, Cassandra, and others, Spark has become a welcomed addition to the data scientist toolbox. Growing in popularity, Spark is not without it...

November 5, 2015

We Treasure PyData. See you in NYC!

You may have noticed on the PyData NYC's website that Treasure Data will be joining PyData NYC as a Platinum Sponsor. Treasure Data has quite a bit of history with Python and PyData. Yuu, one of our devops engineers, is the creator of pyenv, a popular Python environment manager, and one of our ba...

October 26, 2015

Announcing Data Tanks: Faster Reporting and Unlimited Connectivity

Today I'm happy to announce a new addition to Treasure Data's world-class analytics infrastructure: Data Tanks. Data Tanks provide easy access to your aggregated metrics through convenient, fully hosted data marts on Treasure Data's core platform. They can be used to drive a variety of external ...

October 8, 2015

Redshift is 400x Bigger than MySQL Yet MySQL is More Popular

The Amazon Redshift COPY Command Guide is now available! There are good reasons for the hype around Amazon Redshift. Redshift is blazing fast and not that much more expensive than MySQL or PostgreSQL, the traditional mainstay of data engineers. But is Amazon Redshift really becoming predominant i...

October 7, 2015

Treasure Data brings you: The Amazon Redshift COPY command cheatsheet

Although it's getting easier, ramping up on the COPY command to import tables into Redshift can become very tricky and error-prone. Following the accordion-like hyperlinked Redshift documentation to get a complete command isn't exactly straighforward, either. Treasure Data got in on the act (we...

29