Arm Treasure Data Blog - Part 35

Serverless Data Integration for Data Analysts with Zapier

If you’re familiar with IFTTT.com and the simple If This Then That task automation recipes, then you already also have a pretty good idea how Zapier’s trigger-response mechanism works: you perform a simple ...

Supercharge your Salesforce Data Search Efforts with Treasure Data and Elasticsearch

Elasticsearch benefits not just those looking for text search, but those looking for instant insights and business intelligence from their textual and unstructured data. You might see Elasticsearch implemented ...

Accurate Sales Forecast for Data Analysts: Building a Random Forest model with Just SQL and Hivemall

Rossman is a pharmacy chain with over 3,000 stores in seven countries within Europe. The manager of each store has been tasked to predict the sales of the store for up to six weeks in advance. Sales of each store depends on various factors such......

Using Analytics to Uncover the Best Path to Monetization

At some point, every successful app needs to turn a profit - no two ways about it. Those millions of daily active users don't mean jack to your investors until you find something they'll actually pay for. And, when it comes to mucking around with your user experience looking for paydirt, good analyt...

AdWords Reports: An Awfully Partial View

Which AdWords campaign has the best return on ad spend (ROAS)? Every digital marketer has been asked this question at least once, if not every week. You would think such a simple question could be answered with an AdWords report. But as you dig deeper into your data and product, you realize that ...

Capture your Kinesis Stream Analytics Events in Treasure Data

With data-driven companies like Coinbase, Dash and Supercell all getting on board with Amazon Kinesis for real-time delivery of in-app data, handling billions of events per day, we can imagine why you too might...

We Analyzed Over 6 Million SQL Queries & Here’s What We Found

As part of our effort to improve product usability, I decided to take a look at how other analysts and TD users write their SQL. Like any other language, you can develop your own style over the years, and we should design our query editor accordingly......

Customer Highlight: Bringing Data Science to Mobile Shopping at Wish

Wish needed scalable data infrastructure that worked right out of the box. Back in early 2012, the recommendations based shopping app had grown from a data science experiment at ContextLogic into a full web and mobile e-commerce platform......

Wrangling Huge .CSVs Made Simple (with a little help from SQL)

Let's say you have a very large .csv (containing more than 80k rows) that you want to analyze and visualize. Usually, given only Excel and Tableau (or Looker, Chartio, etc.), you would have one of two options: Put it into Excel and run pivot tables, charts, and whatnot, OR Ingest the data di...

Dimensionality Reduction Techniques: Where to Begin

When dealing with huge volumes of data, a problem naturally arises. How do you whittle down a dataset of hundreds or even thousands of variables into an optimal model? How do you visualize data through countless dimensions? Fortunately, a series of techniques called dimensionality reduction aim to...

35

Forrester Study: The Total Economic Impact™ of Arm Treasure Data Download Report