Category Archives: Alteryx

Connect to Google Analytics 4 (GA4) and Extract with Alteryx

Posted on 2022-09-22 by Frederic

Have you noticed that ominous warning every time you connect to Google Analytics (abbreviated to GA for the remainder of this post)? Yes, the Google Analytics you have used and loved (mostly because it’s free, admit it…) is about to … Continue reading →

Posted in Alteryx | Tagged , , | Comments Off on Connect to Google Analytics 4 (GA4) and Extract with Alteryx

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 Concatenate Strings in Snowflake with Alteryx INDB

Posted on 2021-04-20 by Frederic

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 , , | Comments Off on How to Concatenate Strings in Snowflake with Alteryx INDB

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

Use API with Alteryx to import QuickBooks GL reports to Tableau

Posted on 2020-09-29 by Frederic

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