Category Archives: Excel

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

Automate Target to Date Attainment

Posted on 2016-02-23 by Frederic

This post is an extension of the previously covered topic: Display optional business Targets to your Actuals in Tableau The business scenario used to introduce the topic in the previous post was kept basic, on purpose. I’d like to introduce … Continue reading →

Posted in Alteryx, Automation, Excel, Tableau | Tagged , , , | 3 Comments

How to easily Document your Tableau Reports

Posted on 2015-11-03 by Frederic

Every shiny Tableau dashboard comes, or should come, with less glamorous strings attached: documentation… If you want to share the Tableau love, you ought to document how you drove from a data source to a new indicator, and ultimately to … Continue reading →

Posted in Alteryx, Excel, Qlik, SFDC, SQL, Tableau | Tagged , | 1 Comment

Coloring Tableau Worksheet

Posted on 2015-08-04 by Frederic

This post is most certainly more relevant to Tableau beginners coming from Excel, but advanced Tableau users might still find some value, since the question looks easy but turns out the solution is less than obvious…

Posted in Excel, Tableau | 1 Comment

Avoid Sampling Your Google Analytics Data

Posted on 2015-07-28 by Frederic

Google Analytics (GA) is a good freemium tool to analyze traffic flowing through your web properties. It is the most widely used for web analytics, with a 82.4% market share for July 2015, commensurate to Google’s share of the web … Continue reading →

Posted in Alteryx, Excel, Qlik, Tableau | Tagged , | Comments Off on Avoid Sampling Your Google Analytics Data