Category Archives: Alteryx

Turn text column reviews into a Tableau word cloud

Posted on 2017-06-13 by Frederic

After getting my hands on a data set containing a large number of user reviews in a column, I was trying to get an overall sense of those reviews with a quick glance. Visually, there are several options to get … Continue reading →

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

Alteryx v11 after 100 days

Posted on 2017-04-11 by Frederic

As far as Alteryx major releases go, V11 was appealing with many feature enhancements, in no particular order: A modern web based job scheduler A modern formula editor, which makes Excel blemish with its autocomplete and data preview window Addition … Continue reading →

Posted in Alteryx, User Experience | Tagged | Comments Off on Alteryx v11 after 100 days

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

How to Calculate Headcount dynamically from Employees Transaction Records

Posted on 2016-09-01 by Frederic

Many business dashboards track headcount figures, since it is quite a vital indicator for most organizations. Conceptually, headcount is a straight forward concept. Technically, it is actually very complex to render for analysis, as it should not be stored, but … Continue reading →

Posted in Alteryx, Tableau | Tagged , , , | 19 Comments

How to address INDB Union Error With Alteryx and Redshift

Posted on 2016-08-09 by Frederic

When playing with Alteryx on a Amazon Redshift database with INDB tools, have you ever come up with the impenetrable error: Error: Browse In-DB (36): Error SQLPrepare: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: UNION … Continue reading →

Posted in Alteryx, Redshift, SQL | Tagged , , | Comments Off on How to address INDB Union Error With Alteryx and Redshift