Sisense Blog

By Maria Ciampa November 12, 2024

5 Compelling reasons to meet with Sisense at AWS re:Invent

What: Sisense at AWS re:Invent
Date: December 2-6, 2024
Where: Las Vegas, NV
Booth: 225

By Maria Ciampa August 20, 2024

Will AI data analytics tools assist or replace data engineers?

Discover how AI data analytics tools assist data engineers in seven key ways, including automating routine tasks and supercharging data prep and ETL processes.

By Paul Turner and Maria Ciampa August 14, 2024

4 Strategies for success with AI, machine learning, and analytics

Explore top AI machine learning strategies for analytics success. From predictive modeling to explainable AI, unlock key insights for your projects.

By Sisense Team July 31, 2023

Business Intelligence case study in Retail: How to better your brand

The retail analytics industry is constantly evolving, meaning there is a consistent swathe of data that’s being collected every single day – from emerging trends and sales, to changes in the global market and everything in between. Gathering, measuring, and…

By Sisense Team July 25, 2023

SQL GROUP BY — Everything you need to know

A brief tutorial Group by is one of the most frequently used SQL clauses. It allows you to collapse a field into its distinct values. This clause is most often used with aggregations to show one value per grouped field…

By Sisense Team July 19, 2023

When to buy, when to sell? Behavioral economics behind exchanging Dollars to Euros

Here’s a compelling question: Do we make rational or emotional investment decisions? You may consider yourself as someone who carefully considers every financial decision, but when it comes to selling and buying dollars and euros, we have found some behavioral…

By Sisense Team July 13, 2023

How Joins Work

The SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is paid to how the internal SQL engine breaks down the tasks of join operations. This post will explore the common algorithms…

By Sisense Team July 7, 2023

String parsing in SQL

String parsing is a common task for data analysts and data engineers working with raw data. With the growth of unstructured qualitative data, parsing strings efficiently has become increasingly important for fast analysis. One common use of string parsing is…

By Sisense Team July 7, 2023

Outlier detection in SQL

Inevitably, the unexpected happens. A historically low-traffic channel brings in 10x the normal amount of users. Or your user login rate drops by half. In either case, these are important events that are easy to miss in a sea of…

By Sisense Team July 3, 2023

How to really use SQL views

Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra…

By Sisense Team June 27, 2023

Concatenating rows in Redshift, Postgres, & MySQL

Sometimes it’s helpful to look at an aggregated overview of many rows. With numeric columns, it’s easy to sum or average many values, but for string columns we need something different. We can concatenate strings from multiple rows with concatenating…

By Sisense Team June 21, 2023

Solving the traveling salesman problem with Postgres recursive CTEs

Many SQL implementations don’t have loops, making some kinds of analysis very difficult. Postgres, SQL Server, and several others have the next best thing — recursive CTEs! We’ll use them to solve the Traveling Salesman Problem and find the shortest…

By Sisense Team June 15, 2023

10 rules for a better SQL schema

There are a lot of decisions to make when creating new tables and data warehouses. Some that seem inconsequential at the time end up causing you and your users pain for the life of the database. We’ve worked with thousands…

By Sisense Team June 9, 2023

Exact row counts for all tables in MySQL and Postgres

Keeping track of your row counts can be helpful for budgeting and capacity planning, yet accurate counts are surprisingly hard to get. Databases keep row counts in their stats tables for planning query execution, but the results are only approximate…

By Sisense Team June 5, 2023

Rolling averages in MySQL and SQL server

Previously we discussed how to write rolling averages in Postgres. By popular demand, we’re showing you how to do the same in MySQL and SQL Server. We’ll cover how to annotate noisy charts like this: With a 7-day preceding average…