Category Archives: Snowflake

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

Posted on 26 October, 2020 by Frederic

Data for analytics can be structured in two different ways: Wide or Long. Here is an illustration of the two types of format for the same data set: When would you use one vs. the other? In general, wide models … Continue reading →

Posted in Alteryx, Snowflake, SQL | Tagged , , | Leave a comment

Customer Cohorts and Product Sequence with orders data

Posted on 25 August, 2020 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 , | Leave a comment

Easy Fuzzy Match on Names in Tableau with SQL

Posted on 14 July, 2020 by Frederic

Finding duplicate entities at scale in large databases using only names coming from free text boxes is always a challenge in Marketing, common in B2C, often ignored in B2B. Let’s take a simple scenario: I have a very long list … Continue reading →

Posted in Marketing, Performance, Snowflake, SQL, Tableau, Uncategorized | Tagged | Leave a comment

Snowflake Summit 2019 Debrief

Posted on 11 June, 2019 by Frederic

I was very excited at the thought of attending the first edition of the Snowflake customer event In San Francisco last week, and the event did deliver…

Posted in Alteryx, Automation, Performance, Snowflake, SQL, Tableau, Uncategorized | Leave a comment

Alteryx INDB Traps and Limitations Series: Filtering Nulls

Posted on 11 April, 2019 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 | Leave a comment