The World Chess Championship 2018, a match between reigning champion Magnus Carlsen and challenger Fabiano Caruana, just came to a conclusion in London. Since all twelve classical games were drawn, the players entered a tiebreak round, where Carlsen was crowned world champion. This is the first time all classical games have been drawn, and many chess fans expressed disappointment in what seemed to be a “dull” or “bloodless” series of games.

In case you missed it, we launched a free product earlier this year, Mode Studio.

Free products aren't common in the world of analytics. Even less common, we launched ours after already having built a strong business around a paid product. Quite often in the last six months, we've been asked why we did it.

The internet is awash in Venn diagrams of SQL JOINs and explanations of why they're necessary. Though it would be nice if we could answer every data question with a single table, more often than not, to get a complete picture, we need to combine different data sets.

As analysts, we know that each question we ask of our data can be answered with multiple potential languages and toolkits. Each language has its strengths and we've often pondered the distinctions. We've previously examined Group By, window functions and a general framework for thinking in SQL and Python.