Introducing Visual Explorer, a new tool for data visualization.Learn more
Mode
Categories
Analysis
Mode updates
Visualization
Data teams
All articles

Analysis

Group By in SQL and Python: a Comparison

Analysts and data scientists with a deep understanding of multiple analytical programming languages find themselves at an advantage in today’s data landscape. The prevailing dialogue around this kind of multi-lingual approach, especially with SQL and Python, typically portrays the languages as complementary, yet functionally discrete. But there are actually many overlapping functions that can be accomplished by both SQL and Python.

Read more

Editor’s picks in Analysis

Analysis
Use Common Table Expressions (CTE) to Keep Your SQL Clean

May 13, 2022• 4 minute read

Analysis
13 Shortcuts for Mode Power Users

May 13, 2022• 5 minute read

Analysis
Cohort Analysis: An Introductory Guide for Better Retention

May 13, 2022•

Group By in SQL and Python: a Comparison

December 3, 2021• 11 minute read

Analysts and data scientists with a deep understanding of multiple analytical programming languages find themselves at an advantage in today’s data landscape. The prevailing dialogue around this kind of multi-lingual approach, especially with SQL and Python, typically portrays the languages as complementary, yet functionally discrete. But there are actually many overlapping functions that can be accomplished by both SQL and Python.

Image of author

David Wallace

Data Science Evangelist

Our Take On Prescriptive Analytics and How We Used it in 2020

October 28, 2021• 7 minute read

In 2020, Mode used prescriptive analytics to field turbulent economic conditions; here’s a closer look at what we did and how it helped us in rapid planning.

Image of author

Rochel Maday

Technical contributor

Analyzing JSON data with SQL

October 25, 2021• 5 minute read

Use SQL to manipulate & restructure JSON data and streamline your analytical workflow. This process makes it easy to repeat analysis whenever necessary.

Image of author

Nathan Vos

Senior Data Engineer

Types of Product Usage Segmentation

May 18, 2021• 8 minute read

Users will teach us more about our own product than any amount of self-study possibly could. Here's a closer look at product segmentation.

Image of author

Ethan Alter

Product Marketing Manager

How to Avoid Inflated A/B Test Results

March 19, 2021• 4 minute read

Our A/B tests could be leading us astray. If we understand and account for the statistical significance filter, we can get more trustworthy results.

Image of author

Julia Glick

Senior Data Scientist

(At Least) 5 Ways Data Analysis Improves Product Development

December 8, 2020• 3 minute read

Traditional BI tools are great at answering static questions, but not the big-picture questions that determine your product roadmap.

Image of author

Maura Ginty

Chief Marketing Officer

123

Get our weekly data newsletter

Work-related distractions for every data enthusiast.