mode helix
NEWIntroducing Helix—the first instant, responsive data engine.Learn more

Mode Blog

Analysis

October 25, 2018 8 minute read

How to Make Your Product Freemium

Image of author

Benn Stancil

Chief Analyst

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.

Continue Reading
General

September 25, 2018 2 minute read

The Role of an Analyst in the Age of the Citizen Data Scientist

Image of author

Derek Steer

CEO

Anytime you look for patterns in previous experiences, or make a tradeoff between one option and another, you're analyzing something. This means nearly everyone in the workforce does some sort of analysis every day, every time they make a decision.

The need for hard data to help make these decisions in the workplace gave birth to the idea of an “Analyst” as we know it.

Continue Reading
General

September 18, 2018 8 minute read

More Cool Public Datasets and Lots of Ideas for Exploring Them

Image of author

Asha Hill

Customer Success Analyst

A few weeks ago, Google announced a new feature, Dataset Search, that aims to make it easier for anyone to discover public datasets. Journalists, analysts, and data nerds will likely find Dataset Search useful: it uses metadata to help people discover different versions of a dataset and publications that reference it.

Continue Reading
Analysis

September 12, 2018 7 minute read

JOINs in SQL, Python, and R

Image of author

Sadavath Sharma

Data Scientist

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.

Continue Reading
Analysis

August 30, 2018 5 minute read

4 Things You Should Stop Doing in SQL and Start Doing in Python

Image of author

Sadavath Sharma

Data Scientist

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.

Continue Reading
General

August 16, 2018 5 minute read

Get More From Your Salesforce Data: 4 SQL Queries to Write First

Image of author

Sadavath Sharma

Data Scientist

If your company is one of the thousands using Salesforce on a daily basis, their customer-relations management (CRM) tool is a treasure-trove of information for your business. This data provides a window into your potential and actual customers— which helps explain why it's one of the first third-party tools we see Mode customers integrating with their data warehouses.

Continue Reading

Looks like you've got a thing for cutting-edge data news.

Get the latest.