Every once in a while, a quick decision is made to store data in a comma-separated fashion, and the SQL analyst is left to pick up the pieces during analysis.

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.

Reporting and business intelligence are often used to refer to the same thing — but wrongly so!

Having seven years of experience with managing Redshift, a fleet of 335 clusters, combining for 2000+ nodes, we (your...

Editor’s Note: This post was originally written by Ryan Iyengar. If you’re interested in seeing more of Ryan’s content,...

The explosion of data in recent years has impacted the health tech industry enormously, opening new doors to collect...

With today’s updates, you’ll now be able to work with SQL, Python and R all on Sisense for Cloud...

The SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is...

BigQuery, Snowflake, and Redshift all have web-based consoles where you control your data, clusters, user management, query logging, and...

Tracking revenue is crucial to understanding the health of your business. Whether your long-term growth is declining, has plateaued,...

SQL is great for aggregating: counting, summing, averaging numbers are straightforward tasks in SQL. When looking at a distribution,...

We recently launched the instant-classic underwater warfare game Scope: Battle for the High Seas, and our investors are excited...

At Sisense, we depend on our sales team to bring in revenue from the leads our marketing team generates....

In this post, we will cover some of the more common MySQL functions that differ in syntax from Redshift,...