Builder Education Archives

Stronger SQL and More: Essential Skills for Data Teams in Quarantine

This robust list of how-to’s will give you the terms, tricks, and tips you need to get more out of your data and uplevel your skills.

Carmen DeCouto April 2, 2020

Builder Education | 6 min read

Understanding Simpson’s Paradox to Avoid Faulty Conclusions

Spotting a lurking or confounding variable can help you avoid making a decision based on faulty analysis. Read on to learn how.

Ayelet Arditi

Unlock Complex Data | 3 min read

SQL Query Order of Execution

The SQL order of execution defines the order in which the clauses of a query are evaluated. Understanding query order can help you optimize your queries.

Sean Cook

Builder Education | 3 min read

4 Ways to Join Only The First Row in SQL

Joining the First Row is an oft-used technique and a vital tool in the analyst's repertoire. Learn four different ways to pull off this essential move.

Sisense Data Team

Unlock Complex Data | 12 min read

REST API Testing Strategy: What Exactly Should You Test?

The API layer of any application is one of the most crucial software components. It is the channel which...

Roy Mor

Unlock Complex Data | 8 min read

Postgres vs. MongoDB for Storing JSON Data — Which Should You Choose?

What is JSON?What are MongoDB and PostgreSQL?Constraints and LimitationsNative JSON Data Stores PerformanceUse Cases and Factors Have you ever...

Adam Bonefeste

Unlock Complex Data | 5 min read

Business Intelligence vs Business Analytics — Know the Difference

Business Analytics (BA) and Business Intelligence (BI) both provide tools for handling and making sense of your data. Learn the distinctions between these two terms.