Category Archives: Performance

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

Posted on 2018-01-03 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 , , | 2 Comments

How to Load Data in Bulk to Snowflake with Alteryx

Posted on 2017-10-31 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 , , , , | 13 Comments

YoY YTD dashboard made easy in Tableau

Posted on 2017-05-31 by Frederic

When using a set of dated transactions which gets updated, how do you provide a report which will track visually a monthly  YoY (Year over Year) YTD (Year to Date) comparison? This needs to work at the day level, to … Continue reading →

Posted in Performance, Quick & Dirty, Sales, Tableau | Tagged , , | 8 Comments

10 Tricks to adopt Redshift In-DB

Posted on 2016-12-01 by Frederic

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

Pathways to Analytics Automated Operations Nirvana

Posted on 2016-06-29 by Frederic

I already wrote a couple of posts on the topic of Automation of Operations using Alteryx, but I felt an update was in order, as the possibilities evolve so fast lately. I gauged some interest on the topic as well … Continue reading →

Posted in Alteryx, Automation, Performance, Power BI, Qlik, Redshift, Tableau | Tagged , , | Comments Off on Pathways to Analytics Automated Operations Nirvana