Category Archives: Alteryx

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 , , , | 10 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

Pathways to Analytics Automated Operations Nirvana

I already wrote a couple of posts on the topic of Automation of Operations using Alteryx, but I felt an update was in order, as the possibilities evolve so fast lately. I gauged some interest on the topic as well … Continue reading

Posted in Alteryx, Automation, Performance, Power BI, Qlik, Redshift, Tableau | Tagged , , | Leave a comment