mode helix
NEXT WEBINARHow companies should be thinking about data governanceRegister now

Analysis

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
Analysis

May 21, 2020 4 minute read

Reassessing Customer Health Scores in a Fluctuating Market

Image of author

Lizz Harrell

VP of Customer Success

Here’s how we launched a volatility-driven customer health score model in days, not weeks.

Continue Reading
Analysis

April 27, 2020 5 minute read

13 Shortcuts for Mode Power Users

Image of author

Sam Novak

Senior Product Design Lead

Have a lot of analysis to get through? Here’s a quick list of handy shortcuts for Mode power users.

Continue Reading

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

Get the latest.