Analysis
Designing An Analytics Stack Like We Design Software
2017 feels like a turning point for the analytics community—everyone seems to be talking about the sudden proliferation of analytics tools. A technological cell division within our arsenals. Not only is the number of tools increasing, these same tools are also addressing increasingly discrete problems. Whereas we used to evaluate one or two tools to solve an array of data problems, it’s not uncommon now to evaluate a suite of different tools to solve discrete subsets of those same problems.
Editor’s picks in Analysis
Using dbt and Mode to Help Eko Rebuild its Analytics Stack
April 5, 2017• 4 minute read
You might not have heard of Eko, but chances are you’ve interacted with their content. Eko has pioneered the medium of interactive video and captured the interest of viewers and national brands alike. Through their proprietary interactive video player, the Eko team weaves rich stories which viewers can navigate on their smartphones, tablets, PCs, and soon VR headsets. The result is a highly engaged audience of viewers, happy advertisers, and a whole lot of data.
Drew Banin
Co-Founder
Creating Persistent Derived Tables
February 8, 2017•
Now that the Mode SQL editor supports running multiple SQL statements, you can do so much more than pull data back from the database. One door this opens is the ability to create persistent derived tables, which are tables generated when the results of a SQL query are written back into your database. Once in your database, these tables can be queried just like any other table.
Joel Carron
Data Scientist at Mode
