Author Archives: Frederic

Unboxing Tableau Prep 2018.1

A year and a half after the first demo of Project Maestro, Tableau has finally released his latest product: Tableau Prep. Tableau Prep is positioned as a standalone tool to “combine, shape, and clean data for analysis”. That puts Tableau … Continue reading

Posted in Alteryx, Tableau | Tagged , | Leave a 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 | Leave a comment

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 , | Leave a comment

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 , , , , | Leave a comment

Access and Process Leads Activity History with Marketo Bulk Extract APIs

Marketo’s core expertise is Marketing Automation, a software category it pioneered along with Eloqua, Pardot, Hubspot, Adobe and now 208 additional vendors and counting. Marketo still holds a solid market share, especially on the West Coast, especially in Tech companies. … Continue reading

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