Author Archives: Frederic

How to analyze easily Google Search Console data in Tableau

Posted on 10 July, 2018 by Frederic

Whether you are deeply versed in the intricacies of SEO, or simply curious to optimize your web property’s organic search performance, you must likely are involved with the Google Search Console and its analytics. It is a very useful (and free!) … Continue reading →

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

Unboxing Tableau Prep 2018.1

Posted on 29 May, 2018 by Frederic

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

Posted on 3 May, 2018 by Frederic

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

Posted on 3 January, 2018 by Frederic

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 , | 1 Comment

How to Load Data in Bulk to Snowflake with Alteryx

Posted on 31 October, 2017 by Frederic

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 , , , , | 12 Comments