Author Archives: Frederic

How to Concatenate Strings in Snowflake with Alteryx INDB

Suppose you have a set of transactions, such as Superstore orders for instance, each with one to many line items, with each line item belonging to a product category: Note that this is a single order with actually 14 line … Continue reading

Posted in Alteryx, Performance, Snowflake, SQL | Tagged , , | Leave a comment

How to build a history table with Snowflake and Fivetran

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

Snowflake Power Up with Snowsight

One of the many appeals of using Snowflake for me, is the user interface in the browser, which allows not only to perform many admin tasks, but also to poke around data. Yet, that legacy environment, while the envy of … Continue reading

Posted in Uncategorized | Leave a comment

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

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

Use API with Alteryx to import QuickBooks GL reports to Tableau

QuickBooks Online delivers a variety of great reports online and the tools it offers to developers are top notch. The reports themselves could use some more visual zazz… Seriously, I need the accounting data available in a data base to … Continue reading

Posted in Alteryx, Automation, Tableau | Tagged | 3 Comments