NEW GUIDEMarketing metrics for data teamsDownload here
Mode
Categories
Analysis
Mode updates
Visualization
Data teams
All articles

Analysis

How to Master Anti Joins and Apply Them to Business Problems

How to perform an anti join using LEFT JOIN and WHERE. Plus three examples of using anti joins in business scenarios.

Read more

Editor’s picks in Analysis

Analysis
How to Switch from Excel to SQL

January 22, 2022• 10 minute read

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

January 22, 2022•

Analysis
Types of Product Usage Segmentation

January 22, 2022• 8 minute read

How to Master Anti Joins and Apply Them to Business Problems

January 4, 2022• 7 minute read

How to perform an anti join using LEFT JOIN and WHERE. Plus three examples of using anti joins in business scenarios.

Image of author

Joel Carron

Data Scientist at Mode

PostgreSQL Date Functions: 7 Business Analysis Examples

January 4, 2022• 10 minute read

Timestamps are crucial to business analysis for a very simple reason: they tell you when things happen. Imagine trying to suss out trends in your data, like monthly web traffic, or quarterly earnings, or daily order volume without knowing when events occurred. It'd be a nightmare.

Image of author

Joel Carron

Data Scientist at Mode

How to Switch from Excel to SQL

December 10, 2021• 10 minute read

Learning SQL is easy when you know Excel. Learn how to make the transition in this guided example & seriously speed up your workflow.

Image of author

Melissa Bierly

Content Marketing

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•

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

123

Get our weekly data newsletter

Work-related distractions for every data enthusiast.