Tag Archives: Alteryx

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

Overcome 10 Excel limitations with Alteryx

Various sources estimate that Excel has between 750 million and 1 billion users worldwide. Odds are that the vast majority of analysts start manipulating data with Excel. Beyond its ubiquity, and from my days of analytics at Microsoft, I have come to appreciate Excel for … Continue reading

Posted in Alteryx, Excel, Performance | Tagged , , | 9 Comments

Getting Started with Alteryx and Tableau

This post will finally address a topic a bit overdue for this blog: How to get started with the powerful combo of Alteryx + Tableau. If you are reading this post, you necessarily belong to one of those categories: New … Continue reading

Posted in Alteryx, Tableau | Tagged , | 2 Comments