Author Archives: Frederic

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

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

How to Load Data in Bulk to Snowflake with Alteryx

Why a post about Snowflake? What does Alteryx and Tableau have to do with Snowflake? Here is some context: as I was planning to launch my Data Lake consulting business, which is now launched, I was looking for a place … Continue reading

Posted in Alteryx, Performance, Snowflake, SQL, Tableau | Tagged , , , , | 13 Comments

Access and Process Leads Activity History with Marketo Bulk Extract APIs

Every business wants to find the perfect solution that will allow them to automate their content and marketing campaigns. It not only makes their life easier but also improves the results of any campaign that’s run. For analysts and executives … Continue reading

Posted in Alteryx, Marketing, Tableau | Tagged , | 6 Comments

Word clouds with Alteryx and R

In a previous post, I explained how to build word clouds easily with a combination of Alteryx and Tableau. But what happens without Tableau? It turns out that Alteryx can leverage the power of existing R libraries to easily generate … Continue reading

Posted in Alteryx, Automation | Tagged , , | 1 Comment

Navigating Alteryx Maze of Tools

Alteryx is objectively an amazing tool to manipulate data and models, without coding (much). As I mentioned in earlier posts, that simplicity involves trade offs. One of those is the initial difficulty to apprehend the potential and capabilities of the … Continue reading

Posted in Alteryx | Comments Off on Navigating Alteryx Maze of Tools