Tag Archives: CTE

How to Concatenate Strings in Snowflake with Alteryx INDB

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

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

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

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

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