Saturday 11:40 a.m.–12:20 p.m.

How We Turned Everyone at Our Company into Analysts with Python and SQL

Arik Fraimovich

Audience level:
Intermediate

Description

In the past 2 years, we turned all of our employees at EverythingMe - from software developers to our CEO, into data analysts using Python and SQL. This was facilitated by our open source tool, re:dash. In this talk I'll review the past 2 years, what we learned and what we plan to do next to improve decision making in the company using data.

Abstract

In the past 2 years we started a mission, of making our company data available to everyone at the company to help with better decision making. We first loaded all of our data into AWS's Redshift, but then we needed a tool to make this data accessible to everyone at the company. We first tried "traditional" BI tools, like Tableau and YellowFin, but it didn't feel right and it wasn't giving us the full power of Redshift.

This was the point when we decided to make our own tool - re:dash, that better aligns with our "hacker"/engineering culture at the company. We made a simple tool, that allowed you to write a query, utilizing the full power of Redshift, and share its result (along with the query) with your peers.

This high level of transparency in the work with data, helped us bring data to everyone's daily work. No more it was the realm of few, but accessible to everyone - with varying levels of knowledge of SQL. Some wrote queries, others just changed existing queries, but everyone had the same level of access.

In this talk I would like to review what we learned from this experience, and what new challenged we discovered beyond giving everyone access to the data, and how we plan to tackle them.

Sponsors


Become a sponsor.