Sean Cook avatar image

Sean Cook

Sean Cook @Seancook View articles
SQL Order of Operations
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 avatar image Sean Cook
Building a Customer Health Score Dashboard
Tech Talk | 6 min read

Building a Customer Health Score Dashboard in SQL

Sisense has always taken a customer-centric approach to our business, relying on a range of product usage and customer...

Sean Cook avatar image Sean Cook

Subscribe to our blog

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

By submitting this form, I agree to Sisense's
privacy policy and terms of service.

Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude
Tech Talk | 4 min read

Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude

Previously, we’ve demonstrated using the Haversine Formula to calculate distances on a globe in SQL. Today we’ll extend that...

Sean Cook avatar image Sean Cook
Building a Wall-Mounted Dashboard
Tech Talk | 4 min read

Using Raspberry Pis to Build Beautiful Wall-Mounted Dashboards

One common challenge I have frequently encountered is how to display a wall-mounted dashboard. While it may seem like...

Sean Cook avatar image Sean Cook
Using Python to Write a Create Table Statement
Tech Talk | 4 min read

Using Python to Write a Create Table Statement and Load a CSV into Redshift

Usually, the easiest way to upload a CSV is to use Sisense’s CSV functionality. It’s fast, easy, lets you...

Sean Cook avatar image Sean Cook
Connecting Python and Periscope Data by Sisense
Tech Talk | 4 min read

Connecting Python and Sisense for Cloud Data Teams

Sometimes you need to step away from reporting and analytics and do some data science. You might want to...

Sean Cook avatar image Sean Cook
Communication tips for analysts
BI Best Practices | 6 min read

3 Ways Communication Can Help Analysts Be More Successful

There is nothing more satisfying than creating the perfect dashboard. You’ve found the data, created the right charts, your...

Sean Cook avatar image Sean Cook
Your SQL History and Your Data
Tech Talk | 4 min read

SQL History and Why Your Database Isn’t Really Relational

It’s easy to think of the relational database as the standard model in data storage, but like everything else,...

Sean Cook avatar image Sean Cook
How to Get Started With AWS Spectrum in Minutes
Tech Talk | 5 min read

How to Get Started With AWS Spectrum in Minutes

It’s no secret that we’re huge fans of AWS Redshift. We’ve written popular guides to setting it up, tested it against...

Sean Cook avatar image Sean Cook
What you need to know about SQL Group by
Tech Talk | 4 min read

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...

Sean Cook avatar image Sean Cook
SQL Text Analysis with Donald Trump’s Tweets
Business Perspectives | 7 min read

Text Analysis with Donald Trump’s Tweets

There were many unique aspects of the 2016 U.S. presidential election, with one of the most interesting being Donald...

Sean Cook avatar image Sean Cook
Net Promoter Score and Survey Analysis in SQL
Tech Talk | 10 min read

Net Promoter Score and Survey Analysis in SQL

Introduced by Fred Reichheld in 2003, Net Promoter Score (NPS) is a simple method for measuring the likelihood your...

Sean Cook avatar image Sean Cook