The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

Data Munging Crowdsourced Information without SQL, Using Chartio's Data Stores

Chartio's great for analyzing and reporting on data on your company's systems, but what if you don't have all the data you need to complete your analysis?  

We recently held a joint demo with CrowdFlower to show how to crowdsource the information you need and analyze it in Chartio. 

In this post, I'm going to explain how we collected the data, and show you the analysis we performed that night.

Understanding Interleaved Sort Keys in Amazon Redshift, Part 2

Previously, we discussed the role of Amazon Redshift's sort keys and compared how both compound and interleaved keys work in theory. Throughout that post we used some dummy data and a set of Postgres queries in order to explore the Z-order curve and interleaved sorting without getting bogged down in implementation details. In this post, we will explore some of these implementation details, discuss a common tactic that can benefit from using compound and interleaved sort keys together, and run some benchmark queries against a data set with billions of rows. Throughout this post we will link to code that can be used to recreate our results.