Tag Archives: SQL

New SQL tool for Analysts on Snowflake: Datameer

Posted on 2022-01-05 by Frederic

Over the years, I have been monitoring the analytics software market with a quite simple requirement: I am (still) looking for a tool to let me generate full data pipelines quickly from a browser with the least amount of code. … Continue reading →

Posted in Alteryx, Automation, Productivity, Snowflake, SQL | Tagged , , , | Comments Off on New SQL tool for Analysts on Snowflake: Datameer

How to build a history table with Snowflake and Fivetran

Posted on 2021-03-30 by Frederic

What I mean by history table is what is commonly called a Slowly Changing Dimension, or SCD table of type 2, which retains efficiently all the previous values I decide to track, for accurate historical reports. Why do we care … Continue reading →

Posted in SFDC, Snowflake, SQL, Uncategorized | Tagged , , | Comments Off on How to build a history table with Snowflake and Fivetran

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

Posted on 2020-10-26 by Frederic

Data for analytics can be structured in two different ways: Wide or Long. Here is an illustration of the two types of format for the same data set: When would you use one vs. the other? In general, wide models … Continue reading →

Posted in Alteryx, Snowflake, SQL | Tagged , , , | 1 Comment

Customer Cohorts and Product Sequence with orders data

Posted on 2020-08-25 by Frederic

Whether you work in B2B or B2C, getting a better understanding of customer or account transactions in sequence is core. Customer cohorts will show you how well you are doing acquiring new customers, but also do they conduct repeat business … Continue reading →

Posted in Alteryx, Marketing, Redshift, Sales, Snowflake, SQL, Tableau | Tagged , , , | Comments Off on Customer Cohorts and Product Sequence with orders data

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