Tag Archives: SQL

Customer Cohorts and Product Sequence with orders data

Whether you work in B2B or B2C, getting a better understanding of customer or account transactions in sequence is core. Customer cohorts will show you how well you are doing acquiring new customers, but also do they conduct repeat business … Continue reading

Posted in Alteryx, Marketing, Redshift, Sales, Snowflake, SQL, Tableau | Tagged , | Leave a comment

How to filter transactions by a calculated category using SQL Window Functions

Have you ever found yourself in a situation where you need to filter a set of transactions based on categories which need to be calculated from that same set? Let’s say you have a data set containing all the customer … Continue reading

Posted in Alteryx, Marketing, Performance, Redshift, Snowflake, SQL | Tagged , | 1 Comment

How to Load Data in Bulk to Snowflake with Alteryx

Why a post about Snowflake? What does Alteryx and Tableau have to do with Snowflake? Here is some context: as I was planning to launch my Data Lake consulting business, which is now launched, I was looking for a place … Continue reading

Posted in Alteryx, Performance, Snowflake, SQL, Tableau | Tagged , , , , | 12 Comments

10 Tricks to adopt Redshift In-DB

If you are still manipulating data in Excel, why should you care about In-DB and Redshift? Whether you are accessing your Redshift data through Alteryx or through Tableau, knowing how to prepare your data within Redshift, with In-DB tool in … Continue reading

Posted in Alteryx, Performance, Redshift, SQL, Tableau | Tagged , , , | 1 Comment

How to Translate SQL Joins to Alteryx

Old habits die hard… The main obstacle I found when ramping up on Alteryx was to understand how to perform a very basic task: Joining two tables! The mainstream SQL way to Joins was ingrained in me, reinforced by Tableau Blending … Continue reading

Posted in Alteryx, SQL | Tagged , , | 2 Comments