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

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

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

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

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

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

tableau public – share your visual insights with the world!

tableau public is now available! What’s not to love? Free web hosting of your visualization and a free desktop license of tableau public, based on the award-winning, rapid data visualization tools in Tableau Desktop and Tableau Server. With tableau public, you can learn the breadth of Tableau while sharing your insights with the world on any blog or web site.
 
Freakalytics is excited to be featured on the home page of tableau public, highlighting our stock market returns dashboard!
 

Click here to read the details about this dashboard, from our blog post last June.

Embedding tableau public content is simple and quick. Your web site visitors will need NO software installation, since Tableau depends on native Ajax functionality used by sites like GMail. Although not officially supported in the current release, tableau public is viewable and functions interactively on the iPhone based on our simple tests!

On your Tableau journey, consider…

Read the rest of this entry »

Add Your Comment Here

Your favorite Freakalytics blog posts of 2009!

Number 6
Waterfall chart examples with detailed instructions on creating them with your own data in Tableau
Waterfall Chart in Tableau and a Superior Alternative…

Number 5
Do your New Year’s resolutions have you wondering where your money goes? Here’s a snapshot of the average American and their spending habits
How the average American spends their income

Number 4
Trying to figure out how to share customer segmentation and lifetime value insights with your business team?
Customer Segmentation and Lifetime Value Analysis

Number 3
Where’s all that oil money going? Which countries are very dependent on oil imports? Which countries have so much oil their citizens will never need to work?
Visual Metrics to Inform: Petro-Wealth Importance by Region and Country

Number 2
A shocker at number 2 since this post is several years old, a testament to the popularity of SAS and the power of SAS Enterprise Guide,
The Joy of SAS Enterprise Guide

Number 1
And, the top blog post with props to Ellie Fields and Chris Stolte at Tableau for their strong editorial review and support, a 100 year dashboard of S&P stock returns and the historic investing environment S&P Composite Stock Market Returns Dashboard

Wishing all of you a happy, successful 2010! Thanks to our many customers and readers for all of your support! Finally, a special thanks to all of our friends at Tableau Software and SAS!

Add Your Comment Here

Spotlighting Example in Tableau

This workbook is an example of spotlighting in Tableau. Spotlighting involves applying user rules about data values to spot certain outcomes. With Tableau it is simple to apply basic to complex rules for spotlighting. This is beyond the standard highlighting capabilities available by placing measures on the color shelf.

As this example demonstrates, fairly complex rules can be used in Tableau to control spotlighting in simple calculated fields. Comments appear on the captions in each view (bottom of each view area in the Tableau workbook.)

Text Table Spotlighting
Spotlighting1

Bar Chart Spotlighting
Spotlighting2

This example was

Read the rest of this entry »

→ 1 Comment- Add Yours

“Rapid Graphs with Tableau”, free preview and how to purchase it at Amazon

Click here to buy Rapid Graphs with Tableau from Amazon!

Rapid Graphs Front Cover 400 500 Rapid Graphs Back Cover 400 500

Click here for a complimentary preview of the Table of Contents and Chapter 1.

Reviews of “Rapid Graphs with Tableau”
A great work – this is going to be a much loved book.
Marc Rueter- Director of Sales Consulting, Tableau Software

A must read for anyone interested in Tableau. Clear explanations, practical advice and beautiful examples…
Elissa Fink – Vice President of Marketing, Tableau Software

Back Cover Text
Tired of boring spreadsheets and data overload from confusing graphs? Master the art of rapid graphs with Tableau Software. Tableau is designed with one goal in mind – to give you the power to quickly explore and understand your data so that you can use your results in a wide variety of real-world situations. After learning Tableau, you will be able to clearly communicate your findings with audience-friendly graphs and tables.

“A picture is worth a thousand words” is a common saying that is more relevant today than ever as volumes of data multiply and the need for easy access to answers becomes more critical. From simple yet stunning graphs to vibrant multi-graph views capable of communicating incredible insights, this book will cover the extensive range of Tableau capabilities in easy-to-follow examples. Learn the scope and flexibility of this powerful application in just 15 days and go beyond the traditional limits of data presentation!

Read the rest of this entry »

Comments Off

The Value of a Great Analyst- About $3M per Year!

Read the full presentation here, “Overvalued Software Products and Undervalued Analysts? The Value of a Great Analyst in Business Analytics”

I recently pondered the value of a great analyst to a mid-sized public company (revenues around $1-2 billion.)  Based on my experience at multiple companies, I estimate the productivity, typical project benefits, and costs of an average, good and great analyst. The differences in the return to a company are staggering with great analysts yielding double the ROI of a good analyst and triple the ROI of an average analyst!

My conservative estimates of analyst project results (annual value to the firm) are $460k for average analysts, $1.2m for good analysts and $3.1m for great analysts!

Analyst_value

There are two primary drivers behind the much higher value produced by great analysts (illustrated in the following graph):

Read the rest of this entry »

→ 3 Comments- Add Yours

Download Slides- Webinar With Tableau on Visual Data Mining

Thanks for all of your kind comments and wonderful feedback!  I will try to get back to as many of you as the last few weeks of writing the book allows!

Visual Data Mining: Finding Patterns and Key Insights in Online Marketing Data

Date/Time: Already Occured- 6/11/2009
Presented by:
American Marketing Association
Sponsored by:
Tableau Software

Read the rest of this entry »

→ 5 Comments- Add Yours

Data Presentation Principles Part 1- Poor presentation of data

Why don’t you just show me the numbers?

  • Poor presentation of data can make informative interpretation difficult or even impossible.
  • We spend years diagramming sentences & solving equations but have minimal exposure to telling stories with data!
  • The ability to explore, understand and utilize real-world data is a rare skill that can dramatically improve your organization and career.

Sample revenue data from a university

College Quarter Total Revenue Tuition Research Plan Revenue
Arts 2009-01 $5,510,268 $5,230,198 $280,070 $6,000,000
Design 2009-01 $703,770 $408,762 $295,008 $680,000
Engineering 2009-01 $25,139,083 $6,201,932 $18,937,151 $26,800,000
Sciences 2009-01 $4,439,991 $2,159,010 $2,280,981 $4,400,000

A prickly example – Excel chart defaults

Excel defaults are looking sharp, yet uninformative.

Read the rest of this entry »

Add Your Comment Here

Data warehousing success- 100% Vision / 80% Tactical / 20% of the Work

My Background in Data Warehousing

I have been involved in the creation, development, and maintenance of seven data warehouses through the years- one of them before I even knew about the term “data warehousing”!  I have built them with SAS and Oracle, SAS alone, Informatica and Oracle, Oracle alone, and SQL Server.

I have also visited many companies as an adviser, consultant and user of their data warehouse. In these many visits, I have seen some successes and many failures. Often, the failures could have been prevented with some key guiding principles.

Data Warehousing or Enterprise Data Integration?

Data warehousing is now known by a new buzz word, Enterprise Data Integration. In fact, SAS recently renamed SAS ETL Studio as SAS Data Integration Studio (they also added some new features around the EDI area, one new feature was around continual data acquisition so that near real time data feeds are available in the data warehouse.) Another great part of SAS EDI is SAS Data Quality, this should be a consideration throughout the entire process, but I won’t directly comment about data quality in this post. Since most people still use the term data warehousing, so I will keep the popular terminology over the analysts and even SAS.

What Does it Take to Build a Successful Data Warehouse?

Read the rest of this entry »

Add Your Comment Here