Category Archives: SQL

How to Concatenate Strings in Snowflake with Alteryx INDB

Posted on 20 April, 2021 by Frederic

Suppose you have a set of transactions, such as Superstore orders for instance, each with one to many line items, with each line item belonging to a product category: Note that this is a single order with actually 14 line … Continue reading →

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

How to build a history table with Snowflake and Fivetran

Posted on 30 March, 2021 by Frederic

What I mean by history table is what is commonly called a Slowly Changing Dimension, or SCD table of type 2, which retains efficiently all the previous values I decide to track, for accurate historical reports. Why do we care … Continue reading →

Posted in SFDC, Snowflake, SQL, Uncategorized | Tagged , , | Leave a comment

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