Category Archives: Performance

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 , , | Comments Off on How to Concatenate Strings in Snowflake with Alteryx INDB

Easy Fuzzy Match on Names in Tableau with SQL

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 | Comments Off on Easy Fuzzy Match on Names in Tableau with SQL

Snowflake Summit 2019 Debrief

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 | Comments Off on Snowflake Summit 2019 Debrief

Faster field name edits in Alteryx

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 compare your customers by visual cohort chart

When trying to get a better grip on the performance of a large number of customers (or accounts, or pupils for the matter), and  progression over time of their count, their revenue  or their conversion from one status to another, … Continue reading

Posted in Marketing, Performance, Sales, SFDC, Tableau | Tagged | Comments Off on How to compare your customers by visual cohort chart