mode helix
NOW LIVEEmpower your end users with Explorations in Mode.Try it now

Analysis

Analysis

November 13, 2020 4 minute read

Lessons Data Teams Can Learn From the 2020 Election Polls

Image of author

Nate Coleman

Data Scientist

Has polling played too big of a role in our elections? And similarly, how much weight should data have in our business decisions?

Continue Reading
Analysis

September 23, 2020 4 minute read

Now Live: Analytic Functions in Calculated Fields

Image of author

Ying Luo

Product Manager

Analytic functions make Calculated Fields even more powerful by allowing you to calculate metrics based on specified partitions of your data.

Continue Reading
Analysis

July 23, 2020 5 minute read

The Top 5 Most Popular Window Functions and How to Use Them

Image of author

Nate Coleman

Data Scientist

The data team at Mode loves SQL. We code it, we write about it and empower people to use it all over the world. So, in that vein, we thought it would be fun to use some SQL to analyze some SQL.

Continue Reading
Analysis

June 29, 2020 2 minute read

How to Do Linear Regression in SQL

Image of author

Julia Glick

Senior Data Scientist

"We’ve all had to work with simpler tools than we might like from time to time, and I have gotten a lot of mileage out of doing regression analyses directly in SQL."

Continue Reading
Analysis

June 16, 2020 4 minute read

Use Common Table Expressions (CTE) to Keep Your SQL Clean [with example]

Image of author

Joel Carron

Data Scientist at Mode

Here at Mode, we put a lot of emphasis on writing good, clean SQL. As a collaborative team, it’s important that our queries can be easily read and understood by our teammates.

Continue Reading
Analysis

May 27, 2020 1 minute read

Newly Remote Workers Left Internet Explorer at the Office

Image of author

Joel Carron

Data Scientist at Mode

As COVID-19 caused many people to start working from home, we observed an interesting trend: a steep decline in the rate of web traffic to our site from people using the Internet Explorer web browser.

Continue Reading

Get our weekly data newsletter

Work-related distractions for every data enthusiast.