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

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.

"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."

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.

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.

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