Sisense Data Team avatar image

Sisense Data Team

Splitting Comma-Separated Values In MySQL
BI Best Practices | 3 min read

Splitting Comma-Separated Values In MySQL

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.

Sisense Data Team avatar image Sisense Data Team
4 Ways to Join the First Row
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 avatar image Sisense Data Team

Subscribe to our blog

Sign up to get the latest news and developments in business analytics, data analysis and Sisense.

Advanced Analytics | 16 min read

How to Build a Performant Data Warehouse in Redshift

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

Sisense Data Team avatar image Sisense Data Team
A/B Test Reporting and Visualization in SQL
Tech Talk | 10 min read

A/B Test Reporting and Visualization in SQL

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

Sisense Data Team avatar image Sisense Data Team
Improving Healthcare with a Unified Data Platform
BI Best Practices | 3 min read

Improving Healthcare with a Unified Data Platform

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

Sisense Data Team avatar image Sisense Data Team
Comparing Python vs. R for Data Analysis with Sisense
Tech Talk | 1 min read

Comparing Python vs. R for Data Analysis

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

Sisense Data Team avatar image Sisense Data Team
How Joins Work
Tech Talk | 4 min read

How Joins Work

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

Sisense Data Team avatar image Sisense Data Team
Data Warehouse Management: Redshift, Bigquery, and Snowflake
Tech Talk | 4 min read

Data Warehouse Management: Redshift, Bigquery, and Snowflake

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

Sisense Data Team avatar image Sisense Data Team
Tracking KPIs using SQL for Effective Revenue Growth Analysis
Business Perspectives | 3 min read

Tracking KPIs using SQL for Effective Revenue Growth Analysis

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

Sisense Data Team avatar image Sisense Data Team
Calculating Proportional Values in SQL
Business Perspectives | 2 min read

Calculating Proportional Values in SQL

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

Sisense Data Team avatar image Sisense Data Team
Valuing User Subscriptions Over Time with SQL
Tech Talk | 3 min read

Valuing User Subscriptions Over Time with SQL

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

Sisense Data Team avatar image Sisense Data Team
Common Salesforce Reports in SQL
Tech Talk | 2 min read

Common Salesforce Reports in SQL

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

Sisense Data Team avatar image Sisense Data Team
Converting MySQL Syntax and Functions into Redshift
Tech Talk | 6 min read

Converting MySQL Syntax and Functions into Redshift

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

Sisense Data Team avatar image Sisense Data Team
TOP