Analysis
September 23, 2020• 4 minute read
Now Live: Analytic Functions in Calculated Fields
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.
July 23, 2020• 5 minute read
The Top 5 Most Popular Window Functions and How to Use Them
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.
June 29, 2020• 2 minute read
How to Do Linear Regression in SQL
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."
June 16, 2020• 4 minute read
Use Common Table Expressions (CTE) to Keep Your SQL Clean [with example]
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.
May 27, 2020• 1 minute read
Newly Remote Workers Left Internet Explorer at the Office
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.
May 21, 2020• 4 minute read
Reassessing Customer Health Scores in a Fluctuating Market
Lizz Harrell
VP of Customer Success
Here’s how we launched a volatility-driven customer health score model in days, not weeks.