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

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.

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

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.

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

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.

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.

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

Today, we welcome Gaurav Rewari as Mode’s new CEO.

Get a tour of Visual Explorer and see how it makes data exploration easier.

With Visual Explorer, analysts can customize their visualizations to help stakeholders better understand their data.

You can now explore your data faster in Mode with Visual Explorer, our new flexible visualization system.

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Ensure that the right teams have the right level of access to data with granular Collection permissions.

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Mode has achieved the Amazon Redshift Ready designation, part of the Amazon Web Services (AWS) Service Ready Program.

We’re pulling the curtains back on the tech stack for our award-winning customer success team.

For new R coders, or anyone looking to hone their R data viz chops, CRAN’s repository may seem like an embarrassment of riches. There are so many data viz packages out there, it’s hard to know where to start. So here's an overview of 9 useful interdisciplinary R data visualization packages.

This list is an overview of 10 interdisciplinary Python data visualization libraries including matplotlib, Seaborn, Plotly, Bokeh, pygal, geoplotlib, & more.

We're featuring 12 of our favorite ggplot2 extensions, to help you add more power and polish to your ggplots—or just to make them easier to create.

Usage data is like gold for software development teams. Software companies are constantly analyzing user behavior to create valuable insight for decision-making and feature development. But the data generated by users isn't only valuable to the company whose products are being used; it can be valuable to the users themselves.

Now, before going back to the analyst to ask your next big game-changing question, you can answer more of the simple stuff on your own—right in the Mode report they've shared with you. Here's how it works.

Analysts and product teams now work together to build White-Label Embeds that solve all sorts of data delivery use cases. Most commonly, they use Mode to power in-app User Stats pages. We've used it for this exact purpose in our product, too.

The applications of color theory in business are vast. One of the most useful applications of color theory is the visualization and presentation of data.

Colors are key to understanding data visualizations. They represent your data and guide people through charts and dashboards, making them easier to digest. Colors also represent your brand, providing a recognizable look and feel to everything your company produces.