Freakalytics®

Practical Analytics for Better Decisions

Freakalytics™ header image
 
 

Webinar today–What can visual analytics & big data do for you? (3 PM Eastern)

What can visual analytics & big data do for you?AA v 31 front cover 2 225 300

In this 45 minute webinar, Stephen McDaniel will review visual analytic examples and demonstrate what big data analytics can do for you. Stephen will demonstrate this using Tableau 8.

Visual analytics- how is it different than traditional analytics?
Review several examples of visual analytics and how they empower decision-makers quickly and clearly
Build new analytic content from scratch in a matter of minutes

If time permits, a brief question and answer session will follow.

Register here

Add Your Comment Here

SAS versus R for business analysts

Click to read this post

Over on R4Stats, I replied to Bob Muenchen’s article, Forecast Update: Will 2014 be the Beginning of the End for SAS and SPSS?

Personally, I think SAS is a wonderful application, with my SAS experience starting in SAS programming back in 1989 (mainframes, along with Fortran), SAS Enterprise Guide (I wrote SAS for Dummies, the first two editions with Chris Hemedinger) and SAS Enterprise Miner.  Additionally, I have used JMP, SAS Data Integration Studio, SAS Forecast Studio and several other SAS tools.

On the other hand, I have used R since 2004 on several projects and S (precursor to R) since the 90′s in biopharm. I find R truer to being a modern programming language while SAS is truer to being an analyst programming language. Perhaps I am biased? But, the way I think of attacking problems with data and my typical need to massage the data in a wide range of ways, SAS is simply superior in my opinion. The flow of the language, the ease of readability and the powerful DATA step are still my favorite programming world. However, if I am seeking most any statistical test under the sun, R is clearly superior.

Unfortunately, R doesn’t have a clear, de-facto GUI (graphical user interface) that is well-designed

Read the rest of this entry »

→ 1 Comment- Add Yours

Joyful circle charts or informative bar charts? Best practices in visual analytics

Small_packed_bubble_chartStephen Few, noted visual analytics expert and the original inspiration for our work in the field, recently wrote about criticisms of best data visualizations practices by people who should know better. In particular, Amanda Cox of the New York Times said, “There’s a strand of the data viz world that argues that everything could be a bar chart. That’s possibly true but also possibly a world without joy.” And Nathan Yau of Flowing Data wrote, “in visualization you eventually learn that there’s more to the process than efficient graphical perception and avoidance of all things round. Design matters, no doubt, but your understanding of the data matters much more.” These are both people who have a body of work that I admire but I am also surprised at these comments.

This discussion reminds me of a similar problem in marketing and web analytics. Generating traffic that leads to sales is good. Eventually, someone finds a way to generate traffic that leads to not many new sales, but management is misled to think this must be good since traffic leads to sales. This is similar to “look, this chart is beautiful“, but hard to interpret or understand. So, while we delivered fun graphs, minimal information is shared. This may be good for traffic, but not so much for higher sales.

I suspect that part of this recent criticism can be traced back to Stephen’s recent criticism of Tableau, “Tableau Veers from the Path“. In it, he mentions a new graph type in Tableau, packed bubble charts and contrasts them with bar charts. This is an example of the “avoidance of all things circular”. Is Stephen truly anti-joy? Will an example show him to be wrong? Let’s give it a try and you can judge for yourself.

Here’s a packed bubble chart example

Read the rest of this entry »

Add Your Comment Here

Tableau Tips: Nested sorting not as expected- a simple fix

Many students have been confused about the Tableau data sort behavior.  A common question is how to sort the data at a lower level correctly within each higher level of data in a view.  One student recently came to us with this view and asked, “What’s up? I thought it would sort each state independently within each Product Type! In the first group, Herbal Tea, Nevada is clearly number one yet it is shown in the fourth position.”

 

Tableau_Tips_Nested_Sorting_1_Freakalytics

 

Solution

I replied that Tableau was sorting State overall across every product type once for the entire table and then displaying this sort order for every Product Type.  She said this is “stupid, how can I fix it! I wasted hours trying to fix it already.”

Login to see the solution including a solution workbook! If you haven’t joined Freakalytics yet, it’s free and easy.  Just click signup.

Read the rest of this entry »

Add Your Comment Here

Freakalytics Timeline since 2007

Freakalytics_Timeline_Since_2007_Map

Click for the detailed timeline of Freakalytics activities

 

Since 2007, we have traveled 365,000 miles
to help tens of thousands of people via

8 books,
24 conference talks,
47 public trainings,
26 on-site trainings,
5 conference seminars,
15 analytic advisory engagements
and 36 consulting projects.

Click to review our detailed timeline.

Comments Off

Alteryx Inspire 2013 Tableau Talk

0 Picture This

Download the presentation Picture This! Your Data in Tableau.

Watch my big data talk here and download the example workbooks here (requires Tableau 8 to open).

Attending this conference was a great experience. Based on multiple customer discussions at the conference, Alteryx is a great product for personal data integration, data enrichment and predictive analytics. Some amazing things we saw in Alteryx includes upcoming direct integration with the Tableau Data Engine, interactive location mapping to generate demographic profiles in Tableau, support of Revolution R 3.0 and integration with social data API’s including Yelp, Google + and Facebook.

Here is a screenshot of one of the marketing performance dashboards built in Tableau. It was based on data built with Alteryx. Alteryx was used for data integration, data enrichment and predictive modelling of customer likelihood to respond to future coupon offers. Enrichment included fuzzy matching of customer demographics using Alteryx-bundled 3rd party data sources from Experian.

Tableau 8 Dashboard where are we performing well

If you are looking for a great compliment to Tableau, I recommend that you consider Alteryx.

Add Your Comment Here

Rapid Graphs with Tableau 8 – now on Amazon

Rapid_Graphs_Tableau_8_Freakalytics_Copyright_346_433
Rapid Graphs with Tableau 8
The Original Guide for the Accidental Analyst

+ Written by Tableau insider & product manager,
  teaching Tableau to thousands since 2009

+ Real-world examples that you can follow include
  tips and tricks to save you time

+ High-def videos & solutions

+ New dashboard section taught at MBA programs

+ The fourth edition–proven & trusted

+ Buy it on Amazon

 
 
 

Tired of boring spreadsheets and data overload from confusing graphs? Master the art of rapid graphs with Tableau! Our hands-on case study approach and more than 225 illustrations teach you how to quickly explore and understand your data to make informed decisions in a wide variety of real-world situations. We include best practices of visual analytics for ideas on how to communicate your findings with audience-friendly graphs, tables and maps.

A picture is worth a thousand words” is a common saying that is more relevant today than ever as data volumes grow and the need for easy access to answers becomes more critical. This book covers the core of Tableau capabilities in easy-to-follow examples, updated and expanded for Version 8, as the fourth edition of the first book on Tableau. Learn how to be successful with Tableau from the team that started the original training program as the founding Tableau Education Partner!
 
 
A must read for anyone interested in Tableau. Clear explanations, practical advice and beautiful examples!”
Elissa Fink – Chief Marketing Officer, Tableau Software

“A great work- this is going to be a much-loved book.”
Marc Rueter – Senior Director of Technology, Consulting and Strategy, Tableau Software

“Well written, easy to use book that has something for everyone.
  A great resource if you are new to Tableau… but also useful tips for advanced users as well.”
Bob Morrison – Founder/CEO, Quadrant Arts Education Research and Chairman at MakeMusic
 
 
Stephen McDaniel
Stephen is passionate about helping people understand, present and take action with their data. He is author of SAS for Dummies, The AccidentalAnalyst and the Rapid Dashboard Reference Card. He has been on the Faculty of The American Marketing Association and The Data Warehouse Institute and is currently Director of Analytics at Tableau Software and Principal Analyst at Freakalytics, LLC.

Eileen McDaniel
Co-founder of Freakalytics, Eileen directs the development of books and course materials. She is lead author of The Accidental Analyst: Show Your Data Who’s Boss. This book provides a step-by-step analysis framework to help people who didn’t plan for a career as an analyst, but now must analyze data quickly and effectively.
 
 
244 pages
Black and white
 
 
+ Buy it on Amazon

Comments Off

Free Webinar Videos and Solutions—Part 2 of Better Analytics in Tableau 8 (Video)

 
Forecasting-better-analytics-tableau-8-freakalytics-2If you display information the right way,
anybody can be an analyst.

—JOHN TUKEY
Prominent American statistician
who first used the word “software”

 
 
 
 

Topics with links
      + Treemaps and packed bubble charts
      + Automatically selecting the right data for your analysis
      + Forecasting for smarter planning
      + Google Analytics on the desktop—fast, beautiful and blend it with your data

The following videos are grouped by topic from our recent webinar, Better Analytics in Tableau 8. The work done in Tableau is also available for download (as a packaged workbook) below the relevant video. Tableau 8 is required to open the packaged workbooks on this page. The videos on this page are available to view in high-quality 1280×720 size, just click the four-arrow box in the bottom right of the video before clicking the play button.
 
 
 
Understanding relative contribution and finding extremes at a glance
Treemaps and packed bubble charts (8:43)


Download the Treemaps and packed bubble charts workbook (requires Tableau 8)
 
 
 
Automatically selecting the right data for your analysis
Data source filters (3:42)

Read the rest of this entry »

Add Your Comment Here

Free Webinar Videos and Solutions—Part 1 of Better Analytics in Tableau 8 (Video)

 
Map-better-analytics-tableau-8-freakalytics-2If you display information the right way,
anybody can be an analyst.

—JOHN TUKEY
Prominent American statistician
who first used the word “software”

 
 
 
 

Topics with links
      + Multi-item color encoding
      + Multi-item data labels
      + Creating sets in Tableau 8
      + Union, intersection and partial sets; using sets in calculated fields

The following videos are grouped by topic from our recent webinar, Better Analytics in Tableau 8. The work done in Tableau is also available for download (as a packaged workbook) below the relevant video. Tableau 8 is required to open the packaged workbooks on this page. The videos on this page are available to view in high-quality 1280×720 size, just click the four-arrow box in the bottom right of the video before clicking the play button.
 
 
 
Finding data in your view
Multi-item color encoding (4:14)


Download the multi-item color encoding workbook (requires Tableau 8)
 
 
 
Finding data in your view
Multi-item data labels (3:04)

Download the data labels with multi-item details workbook (requires Tableau 8)
 
 
 
Selecting data with predefined filters
Creating sets in Tableau 8 (8:45)

Read the rest of this entry »

Add Your Comment Here

Estimating future success rates from initial experience, surveys and observation (tutorial)

A wide range of common business questions are often decided incorrectly because decision-makers overlook, forget or neglect the application of a simple concept from statistics.  In this tutorial we will walk you through several examples to avoid this potentially costly mistake.  Examples where this technique can help include:

Is my ad worth the price?
Conversion (CTR): how many customers converted to a paying customer after clicking on an Google ad and visiting a special offer web page?  Based on the revenue generated is the ad price too high?

How many of my customers have children?
Estimating customer demographics: based on a one day survey in every store, what percent of our entire customer base have children?

Who will win the election?
Survey results: what percent of likely voters will vote for Obama based on the responses from a 1,000 people in a poll?

Bringing down the house?
Winning a bet: if my friend flips a coin 10 times and it landed on heads 9 times, is this a “fair” coin?

All of these questions and many others can be answered with the technique explained and demonstrated in this article.

 

Which states have the most Miss America winners?

Here is a fun example about the Miss America pageant, it appeared on the Ask.com home page.

Notice that 27% of Ask.com users picked the correct state for the most Miss America winners, is that good? Well, we should ask how you would perform if you had no information and simply guessed at the answer. With four choices and only one correct answer, you have a 1 in 4 chance (that’s 1/4 = 25%) of guessing the answer even if you have no clue.

So, is 27% actually better than all of these people just guessing? The answer is “it depends” on a missing piece of information- how many people answered this question. If 100 people answered it and 27 answered correctly, there is a good chance that they are all simply guessing. However, if 10,000 answered this question and 2,700 answered it correctly, there is a good chance that some of them answered better than just guessing.

 

The classic illustration of success- flip a coin

You may be puzzled at this point. Don’t fear. Let me move to a simpler example, flipping a coin. Believe it or not, it is very similar to the multiple choice question above, with the main difference being the chance of “success”- guessing heads or tails correctly, which is 1 in 2 or 50%. So, if I flip it once and you are right, then 100% of flips were guessed correctly. However, this one flip being guessed correctly wouldn’t lead me to believe that you had the ability to see the future (or that the coin is an unfair coin that is always heads). How many flips guessed correctly would it take? Like I have seen followed in many business situations, what does your intuition or gut say?

Five out of five correct?
Twelve out of fourteen?
80 out of 100?

Here’s the good news, there is a simple

Read the rest of this entry »

Add Your Comment Here

Precise layout of filters and legends when exporting from Tableau to PDF and image files

 
A reply to a recent Tableau User Forum Idea, “Option To Place Legend Horizontally Across Bottom For Image And PDF”.
 
 
 
 
 
A Solution
This can be done, but not on the worksheet. If you move it

Read the rest of this entry »

Add Your Comment Here

How to show growth over time and conceal the baseline time period in Tableau

A client asked,

What I want to show is a YoY (year over year) or WoW (week over week) comparison – however the first data point is always missing – even when the underlying data are available.

For example:
The full set of data shows a null value for 2006 – just because there is no data available to compute a comparison.
Now I want to move the date filter to start @ 2007 – and now 2007 has a null value even though we have data available to compute that metric.
” What’s the issue and how can I display only years

Read the rest of this entry »

Add Your Comment Here

Data Driven Conference 2012 and our special discount for attendees

We are having a great time at the Data Driven Conference in Columbus! Our first session was standing room only and we are presenting the same talk a second time at 1:30 in E161.

Interesting questions include “how do you become better at asking the right questions that lead to better analysis” and “how do you communicate with IT to get better data”?

To buy The Accidental Analyst directly from us at the special attendee discount, please visit www.AccidentalAnalyst.com/ddc and place your order before this Thursday.

Here is our infographic that we created

Read the rest of this entry »

Add Your Comment Here

Patriotic colors and maps in Tableau (US colors)

 
While preparing for a conference, we decided to create a map to show the US states using patriotic (US flag) colors.  The colors of the US flag are precise, so we needed to modify the Tableau preferences file to use the correct colors (also, white is not part of the Tableau color palette for discrete data items.)

After modifying our Preferences.TPS file with a new US Flag color palette and saving it to My Tableau Repository (a directory, typically in My Documents), we were able to create the red, white and blue map of the US!  To download the Maps, a sample workbook and the changed Preferences.TPS file, just log in below.

Read the rest of this entry »

Add Your Comment Here

Book Excerpt: Tableau 7 Quick Table Calculations and Custom Table Calculations

This is a free preview from Rapid Graphs with Tableau Software 7, available in print and Kindle on Amazon and on the Nook at Barnes and Noble. Due to width constraints on this blog, you may notice some loss in resolution compared with the purchased book, which has approximately 2.5 times better resolution.
 
 
 
 
 
 

Read the rest of this entry »

→ 1 Comment- Add Yours

2012 NCAA football rankings—ranks per poll & overall ranking

Teams inlcuded in this week:
USC, LSU, Alabama, Oklahoma, Oregon, Georgia, Florida State, Michigan, South Carolina, Arkansas, West Virginia, Michigan State, Wisconsin, Clemson, Texas, Ohio State, Stanford, Nebraska, TCU, Virginia Tech, Oklahoma State, Kansas State, Florida, Boise State, Notre Dame, Louisville, Washington, Auburn, Georgia Tech, North Carolina, Utah, NC State, Baylor, South Florida, Texas A&M, Cincinnati, Brigham Young, Tennessee, Mississippi State, Virginia, Louisiana Tech, UCF, Houston, Rutgers, Southern Miss, Missouri, Florida Intl, Northern Illinois, Texas Tech

Conferences included in this week:
SEC, Big 12, ACC, Big Ten, Pac-12, Big East, USA, Ind, Mid-Amer, Mntn Wst, Sun, WAC
 
 
 
 

Read the rest of this entry »

Add Your Comment Here