Dashboard tips by example- bar charts as cascading filters

This dashboard, a Customer Sales Dashboard for a boutique winery, offers one strategic view of key questions asked by winery management. Information such as amount of sales attributed to various marketing programs, estimated profits by customer segment and number of customers acquired during each of the last four years is displayed. Using a series of … Read more

Upcoming April presentations and books by Freakalytics

We have several presentations and a book release in the the month of April!

We will be at the SAS Global Forum author party Monday afternoon, April 12th. “SAS for Dummies” is being released today, April 5th. I will be at the author party at the SGF conference with Chris Hemedinger (co-author) meeting other authors and SAS conference attendees.

On April 14th at 9 AM, at SAS Global Forum in Seattle, “The Future of Marketing Analytics with SAS Enterprise Guide“.

On April 14th, we are also

Read more

Tips—Multiple Tableau Dashboard Data Sources

The setup
You have connected to more than one data source in your Tableau workbook, for example, your sales database in Oracle and a customer call database in SQL Server.   Tableau seamlessly allows you to connect to multiple data sources in one workbook.   Views developed from both data sources can be placed in a single dashboard.

However, if you try to use global filters or quick filters to synchronize the two data sources, you will find that it isn’t possible; only one data source can be linked to either.   In fact, the term “Global” filter in Tableau can be confounding, since it is only global to views using the current data source.   Global filters will not work with other data sources even if the data items have the same name!

The solution
As of Tableau 5.0 (released in 2009), a new feature

Read more

Great prizes- enter the Tableau Visualization Contest!

Win a great trip to San Francisco to attend the Web 2.0 conference and be featured on the Tableau Public home page and Read Write Web! Enter the Tableau Visualization Contest (now past and the page is no longer posted.)   No matter what happens, you will have your own copy of tableau public to … Read more