Category Archives: Redshift

Customer Cohorts and Product Sequence with orders data

Posted on 2020-08-25 by Frederic

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 , , , | Comments Off on Customer Cohorts and Product Sequence with orders data

Alteryx INDB Traps and Limitations Series: Filtering Nulls

Posted on 2019-04-11 by Frederic

I get to spend a lot of quality time with INDB tools, which represent 90% of my workflows. I love them, I can generate code almost at the speed of thoughts. They are fast to put together but also very … Continue reading →

Posted in Alteryx, Redshift, Snowflake, SQL | 1 Comment

Faster field name edits in Alteryx

Posted on 2018-10-15 by Frederic

From a distance, editing field names might not seem such a big issue, worth dedicating a blog post. Yet, I realize how much experience I gained over time, dealing with such minor issues, which end up affecting my productivity significantly … Continue reading →

Posted in Alteryx, Performance, Productivity, Redshift, Snowflake | Tagged , | 1 Comment

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

Posted on 2018-01-03 by Frederic

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 , , | 2 Comments

10 Tricks to adopt Redshift In-DB

Posted on 2016-12-01 by Frederic

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