Category Archives: Tableau

SAT performance versus school spending dashboard

This dashboard provides a comparison of per student spending with performance on the SAT exam based on the 2009 New Jersey Report Card data. DFGs are based on economic and demographic data. These are assigned by the New Jersey State Department of Education.

This work was created in collaboration with Bob Morrison of Quadrant Arts Education Research. Bob has extensive experience with helping school systems measure educational results related to how and where funds are spent. I have a great admiration for Bob as a passionate advocate for growing both music and arts education. Bob has expertise in advocating on behalf of students around the many ways that music and arts education can engage students and improve their academic performance.
Continue reading

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

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 use as long as you like, which includes free hosting of your content to share with the world on your web site!

Dashboard Nirvana and Visual Management of Marketing Programs

View and interact with the strategic customer sales and analyst exploratory dashboards below, both hosted by tableau public.

Read Eileen's white paper, "Visual Management of Marketing Programs", for detailed explanations on maximizing Marketing ROI with visual marketing dashboards.

In this case study, we used customer demographic and sales databases from a boutique winery in combination with Tableau Software Continue reading

Waterfall Chart in Tableau and a Superior Alternative…

The 1st workbook walks you through building a standard Waterfall chart in Tableau. Waterfall charts are intended to show you how cash balances change over time based on transactions that either add to or subtract from the cash account of a business.

As this example demonstrates, many non-standard chart types can be created in Tableau using advanced features of the product. This chart type is a frequent request of students in our public and on-site Tableau training courses.

Continue reading

Stephen Few’s latest book, “Now you see it”

Stephen's latest book is a brilliant interplay of simple to advanced statistical concepts with powerful visual equivalents and methods. It offers wonderful guidance with great examples around visualizing time series, correlations and multivariate analysis problems. It will have a major impact for many years to come in changing how business analysts work, think and improve their companies!

A friend of mine recently asked "... are statisticians becoming irrelevant" (hey, that's me!) with the advent of advanced visualization tools like Tableau. I think the answer is yes and no. New tools like Tableau combined with methods expounded by Stephen will allow daily business questions to be answered rapidly. This should allow the statisticians to focus on tackling very high value problems where even a 1% improvement in the outcome is a huge win.

I have personally found that combining my work in data mining with beautiful stories about the results (created with Tableau) is truly impressive and informative for guiding decision-makers. Business decision-makers gain the advantages offered by advanced data mining algorithms such as decision trees, logistic regression and neural networks to identify primary predictive patterns and variables. The analyst can then clearly explain the results with compelling visuals to easily convey the findings and recommendations.

I think Stephen's latest book will become the "gold" standard for data exploration books to follow. If you need the next step past "Show Me the Numbers", this is it! BTW- it is even better than "Show Me the Numbers", which is indeed very impressive. I plan to incorporate some of this book into my advanced Tableau course, "Data Exploration and Elegant Dashboards with Tableau".