Author Archives: Frederic

Automate custom Tableau email updates

Posted on 2016-10-04 by Frederic

Like it or not, looking at you Slack, email remains the preferred way to disseminate information in the workplace. Even applications that help businesses run smoothly use email as a form of communication and efficiency. For example, the Sharepoint alert … Continue reading →

Posted in Automation, Marketing, Sales, Tableau | Tagged , | Comments Off on Automate custom Tableau email updates

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

Pathways to Analytics Automated Operations Nirvana

Posted on 2016-06-29 by Frederic

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 , , | Comments Off on Pathways to Analytics Automated Operations Nirvana

Overcome 10 Excel limitations with Alteryx

Posted on 2016-04-14 by Frederic

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 … Continue reading →

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