Category Archives: Performance

YoY YTD dashboard made easy in Tableau

When using a set of dated transactions which gets updated, how do you provide a report which will track visually a monthly  YoY (Year over Year) YTD (Year to Date) comparison? This needs to work at the day level, to … Continue reading

Posted in Performance, Quick & Dirty, Sales, Tableau | 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

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

Optimize Performance by Adjusting Automatically Fields Width

Field width is not a very sexy topic compared to Visualization or Spark R. That’s a very good reason to get that basic topic out of the way with an approach that will save you time to spend on much … Continue reading

Posted in Alteryx, Performance, SFDC, Tableau | Tagged , | Leave a comment