Visual Analytics–Best Practices

2012 NCAA football rankings–ranks per poll & overall ranking

by

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 more

2012 NCAA football rankings–top 25 teams per conference

by

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 more

Webcast: “Big Data” on your laptop, fast, informative and at your command

by

NOTE: This fun review of “big data” was inspired by a recent presentation I gave on behalf of Tableau Software at the Big Data Conference in Chicago. You can find the 1st part of this 3 part webcast here, “Performance to Cost Index & my personal history with “Big Data” and Part 2 here, “Big Data” in US History, Exploring the 1790 US Census. This part of the big data series is free, just subscribe or sign in below.

In this presentation, I share an example of working with big data stored on my laptop and the entire analysis happens without any type of connection to remote servers or databases. My analysis uses two tables of interest, the first has 216 million records, over ten years of airline ticket pricing in the US while the second table has 72 million records of US airlines performance data extracted from Hadoop. In the demonstration, which uses currently available technologies, we will quickly explore and analyze this data for interesting trends and patterns.

Read more

Avoid flatline charts—visual analytics best practices

by

Balancing analysis of multiple years by filtering through the same month/day as today
 
 
Topics in this example
 
1) With a line chart, by placing Year(Order Date) on the Color shelf and Month(Date) on the columns, you can easily compare multiple years on the same pane of the graph. Just use Running Totals from the Quick Table Calculation dialog.
 
2) If this were real-world data, you would likely want to keep data through today; otherwise, prior years would likely be much higher since they are based on a full month while this year’s latest month is partially complete, unless it is the last day of the month!
 
3) By creating a calculated field that can check if the month/day is before today’s month/day and placing it on the filter shelf and selecting True, you can keep year-to-date data

Read more

Why choose Complete Tableau Training by Freakalytics?
A recent attendee’s perspective

by

  This review of our 4 day training series was written on LinkedIn by a recent public training attendee, Danyelle.  She works at the US Department of Health and Human Services as a Senior Data Advisor.  I had the great pleasure of speaking with her  outside of the class and was fascinated to hear how … Read more

Quick tutorial on reference lines, bands and distributions – visual analytics best practices

by

The following article features Tableau 6

Reference lines, bands or distributions may be added to your views to emphasize particular values or areas that may be useful in interpreting your data. In particular, when comparing multiple groups or categories of data, reference lines and bands provide immediate feedback on the overall differences between the groups.

Reference lines

Reference lines are vertical or horizontal lines displayed on your view that mark requested values such as average, median, minimum, maximum, sum, total and constants (such as a line that separates the data points as being above or below a target). They can be added on any continuous axis.

1) Open the Sample – Coffee Chain (Access) data source included by default with Tableau 6

2) Place Sales on the Columns shelf and change the aggregate to Average.

3) Place Product on the Rows shelf,
     State and Date on the Level of Detail shelf
     and format Date to ‘MMMM YYYY’.

Read more

State of Washington government salaries from 2010, search all 160,000 employees

by

State of Washington government salary information is now available at WashingtonGovernmentSalaries.com. The dashboard is fully searchable by agency, job title and employee using a dashboard developed by Freakalytics and hosted by Tableau Public. Both companies are based in Seattle, Washington. Freakalytics specializes in expert, in-person analytics training and popular books on analytics. Tableau is a … Read more

Wimbledon winners longevity, by years since 1st win
small form-factor

by

Learn About Tableau         Freakalytics is the exclusive source of the original Complete Tableau Training (4 days) and our new course, Data Management and Visual Analytics with Tableau (2-days).   For a detailed review of Tableau features, pricing and capabilities, visit PowerTrip Analytics.   For the Tableau Online pricing calculator, click here.

Wimbledon winners by ranking (seed) and gender, small form-factor

by

Learn About Tableau         Freakalytics is the exclusive source of the original Complete Tableau Training (4 days) and our new course, Data Management and Visual Analytics with Tableau (2-days).   For a detailed review of Tableau features, pricing and capabilities, visit PowerTrip Analytics.   For the Tableau Online pricing calculator, click here.