Freakalytics

Rapid Analytics to Explore, Understand, Communicate & Act

Freakalytics™ header image
 

Map dashboard, state budget shortfalls for 2011, just 30 minutes with Tableau

Time magazine recently published a map of state budget shortfalls for 2011 by state. While this was a good attempt, I thought it would be informative to show this data in Tableau to offer additional insight. The image of Time’s map is not as clear as a regular scanned image since I used my iPhone- taking the photo on a flight!

There are three primary areas for improvement

Read the rest of this entry »

Add Your Comment Here

The BI Challenge, “Feature lists miss the point” on DataDoodle

From datadoodle,

So many people who should know better seem to miss the point when they mention Tableau. Why? I asked BI veteran Stephen McDaniel for his thoughts — which he gave, but then went on to suggest an almost unheard of challenge: a data analysis face-off among vendors

Read the rest of this entry »

Add Your Comment Here

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.

Read the rest of this entry »

Add Your Comment Here

Thoughts about “Circle-Lust Continues”, just 30 minutes with Tableau

I read with fascination that this visualization won the Sunlight Foundation’s $5,000 prize for “Best Visualization Using Data about US Spending”.


 
 
This graphic is

Read the rest of this entry »

→ 2 Comments- Add Yours

Creating a data-driven culture in your company

A great summary of key requirements to build a data-driven culture, by Chris Stolte, Tableau co-founder:

1. Don’t fear the user,
2. Encourage corporate curiosity,
3. Manage to the outliers,
4. Measure, experiment and then measure again, and
5. Build trust and understanding.

I would add two more points, one of which Chris is too modest to state,

6. From my experience working at Netflix, no matter the level of decision-maker, ask them for the data to back up their decision and to examine the results of their decisions.
7. Deploy Tableau in your business- speed of insight is critical to the value of data in many business needs. Tableau quickly delivers beautiful insights that are understandable by all of your employees. There is no other application like it!

Read the article and see Chris’s comments first hand.

→ 3 Comments- Add Yours

Dashboard tips by example- maps to inform, standard and novel approaches

Dashboards developed for clients frequently incorporate maps. Tableau offers quick, simple yet insightful mapping capabilities out of the box.

I have noticed that many maps used in my client’s dashboards attempt to display continuous measures. Examples include sales in the past quarter, year to date expenses versus budget or number of open sales opportunities. All of these metrics have shared issues in maps- a small range of the metric may be the dominant value in the display, making it difficult to differentiate amongst the values on the map.

In this post, I will review some common and novel approaches to mapping this type of metric.

Read the rest of this entry and view the maps and dashboards

Add Your Comment Here

Dashboard tips by example- viewing detailed tables beneath the data with Tableau Reader

Many students in class ask, “Is it possible for Tableau Reader to show the detailed data using View Data functionality available in Tableau Desktop?” The answer is no, this feature is not available in Tableau Reader.

However, while you can’t use View Data in Tableau Reader, you can

Read the rest of this entry »

Add Your Comment Here

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 cascading filters based on key customer attributes

Read the rest of this entry and view the dashboard

Add Your Comment Here

Simple Dashboard Design Strategies Presentation and Making Oil Personal Dashboard

The “Simple Business Dashboard Design Strategies” presentation can be downloaded here. I am presenting this presentation today at 4 PM Pacific on Stacey Barr’s Measure and More Webinar.

The dashboard example in this presentation is available below.

Read the rest of this entry »

Add Your Comment Here

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 the rest of this entry »

Add Your Comment Here

Tableau Tips: Synchronizing Multiple Data Sources in a Tableau Dashboard

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 the rest of this entry »

Add Your Comment Here

Agriculutural subsidies working against the health of America???

Inspired by a post at Flowing Data, I present three visuals that demonstrate how the Physicians Committee for Responsible Medicine could improve the presentation of this vital information. I personally found it shocking that US agricultural subsidies were so small

Read the rest of this entry »

→ 7 Comments- Add Yours

Green living dashboard – green activities in the daily lives of Americans

Which “green” activities are consumers performing in their everyday lives?

Activities that-

Add Your Comment Here

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!

 
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!

Add Your Comment Here

Some of our favorite articles from Stephen Few…

Stephen Few has has been an inspiration to us through the years. He has patiently prodded software companies to improve their tools for visual presentation of information, motivated by the sincere hope to improve the world we all live in.

At Freakalytics, we incorporate his content

Read the rest of this entry »

Add Your Comment Here