Mask / Anonymize your data with Alteryx

If you handle data, chances are, you have run into this situation where, upon creating a masterpiece visualization, or an innovative report, you need to share it outside your organization for, say:

  • presenting at a conference
  • obtaining vendor technical assistance
  • or just to brag!

And then you realize: oh no, my underlying data set is confidential, can’t share customers PII, or even can’t risk letting this performance data fall into the wrong hands…

Handling that situation is actually more common than I believed until recently, when I found out there is a whole industry addressing that need, with its own Gartner Magic Quadrant! That industry is called Data Masking with data obfuscation solutions aplenty, which most likely costs absurd amounts to license, and months to deploy.

What can you do without tons of resource? What if you have only 1h and need something quick & dirty, but clean enough to not get into trouble?
Continue reading

Posted in Alteryx, Excel, Qlik, SQL, Tableau | Tagged | 5 Comments

Extracting Salesforce.com (SFDC) data to Tableau

For convenience, I will systematically refer to Salesforce.com as SFDC.

As the largest CRM vendor according to Gartner, SFDC is pretty ubiquitous, and the odds are that most Tableau users dealing with sales figures have already run into this data source.

This leadership offers convenience when it comes to handling data from many cloud database platforms, as both Tableau and Alteryx provide standard connectors to extract transactions. In fact, this functionality is often used between other applications, such as a Salesforce ActiveCampaign connection option that can help fully populate user data with what each side of the system has. Returning to Tableu though, with both options, which one should be used? I will offer my perspective, as each is attractive in the right context:
Continue reading

Posted in Alteryx, SFDC, Tableau | Tagged , , | 1 Comment

Add a Time Stamp in Tableau using Alteryx to Inform Users of Data freshness

When introducing new dashboards with possible hiccups in refresh operations, or ad hoc reports, users are often confronted with doubts about the timeliness of the data exposed:

  • Does that include yesterday’s orders?
  • Why am I not seeing the activity I was expecting here and there?
  • How come this deal is already appearing?

To address these questions and enhance the user experience, a best practice is to include a time stamp, inconspicuous but easy to access. Tableau offers a standard feature to display Data Update time:

http://kb.tableau.com/articles/howto/adding-data-refresh-time-stamp-to-view

Unfortunately, I haven’t been able to make it work properly when using a TDE file as the Data Source, and it seems I am not alone… For me, that standard function is displaying the time the workbook was last opened, which is of little value to the users of Tableau Server or Tableau Online…

Alteryx to the rescue!
Continue reading

Posted in Alteryx, Tableau, User Experience | Tagged , | 1 Comment

Wean Off VLOOKUP with the Index-Match Combo

Whether you need to perform a quick & dirty join of two tables in Excel to fetch an attribute, or to build more robust (!) data blending for your data preparation, you might still be limiting yourself to just the ubiquitous VLOOKUP() Excel function.

I don’t blame you, VLOOKUP() is convenient, fairly easy to use as it has been around and is well documented, not too treacherous if you sort well and properly use the final Range_lookup Argument…

Nevertheless, there are better options out there!

<Update Jan 2020: Actually there is a brand new feature in Excel 2019 that rebuilds the concept and does away with many issues. It is a new function called XLOOKUP! More details here)
Continue reading

Posted in Excel | Tagged , , , | 1 Comment

Extreme Close Up: let Tableau Users drill down from Aggregates to Transactions to expose Audit Trail

When it comes to businesses, there are many ways that they can be successful. For example, some businesses like to use things like a microsoft dynamics implementation to help them when it comes to CRM (and also ERP). ERP and CRM tend to not only help users streamline the business by improving their workflow but also helps increase efficiency by storing all the data in one unique database! If you would like to know more about the same, you could always visit Syte Consulting Group for a consultation or maybe visit their website to know more about the work done by them.

That said, this isn’t the only thing that they can do. If you are a business owner, then you might have heard of Business Intelligence solutions. One key benefit of Business Intelligence solutions is to let users gain what I call data altitude. Namely, they can see large volumes of transactions in ways that are, hopefully, business relevant.

Taking specifically the example of salesforce.com’s CRM solution, or SFDC for short. Users will often look at a specific record directly in SFDC, with a wealth of details on, say, a prospect, a campaign or an account. If they want to take a look at a group of accounts, they can look at a SFDC report, which will pull literally a list of those accounts, with a handful of relevant attributes. This can also be maintained and automated with software that has been tested by Parasoft systems for extra efficiency.

But frankly, that’s a fairly low altitude. Altitude requires real aggregates, such as buckets of accounts that fall into such and such category for instance, which is great for segmenting. For that purpose, Tableau offers a much better experience than SFDC. Salesforce Wave, an add on to the core CRM product, is intended to bridge that gap, but it lacks in maturity and is very costly in my opinion.

Presenting SFDC aggregates in Tableau is therefore a great idea, and is already widely done. It is such a common scenario for Tableau owners that Tableau comes with a native SFDC connector. Internally, Tableau the company presents SFDC data through Tableau the product. Note that they are not using their native connector, but rather a 3rd party OLE DB connector, as explained in this great description of their internal dog food approach.

Continue reading

Posted in SFDC, Tableau, User Experience | Tagged , , , , | 2 Comments