Category Archives: Alteryx

Turn text column reviews into a Tableau word cloud

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 , , | 1 Comment

Alteryx v11 after 100 days

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

10 Tricks to adopt Redshift In-DB

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

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 , , , | 13 Comments

How to address INDB Union Error With Alteryx and Redshift

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