Freakalytics®Practical Analytics for Better Decisions |
|
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 OffThe following article features Tableau 6
Whether you are exploring your data for new insights, answering specific questions or even deciding what questions to ask, Tableau gives you unprecedented control to investigate, communicate and take action with the valuable information hidden in your data! Tableau has it all – a wide variety of options to graph your data, the ability to adjust your data so that you are using the right data in the right form for the questions at hand, and a user-friendly interface that’s designed around how people think about analysis, allowing you to follow your thoughts as you question and explore your data. You can work with every major data source, from Excel workbooks to the largest databases. You can even extract data from larger sources into a local “extract” file that will make your data exploration more efficient and allow offline analysis when you are away from the office.
Profit and planned profit by product
Red is below plan, green is above
Percentage is actual versus plan
Black line in 2010 shows prior year profit amount
Displaying profit versus sales by region and customer segment Average profit ratio = size of bubble;
Minimum and maximum percents labeled per region
Colors are customer segments
Read the rest of this entry »
A recent training attendee asked for assistance with mapping Canadian customers by Postal Code. Tableau can do this, but you must complete two steps before mapping data at the Canadian Postal Code level.
Read the rest of this entry »
A recent training attendee asked how to show year over year growth in a map. In particular, they wanted to use the Year over Year growth selection from the Quick Table Calculation menu. This simple dashboard
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 »
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 HereSAS 9.2 is a big leap forward in many areas. One of them is a variety of new graph types and easy access to creation in SAS Enterprise Guide 4.2. I think these two charts offer a fascinating look at the 2008 Presidential Election Results using SAS Maps and Tile Charts from the upcoming book, “SAS for Dummies”, updated for SAS 9.2 and available for purchase this Spring!
One of my favorite new examples added to the 9.2 edition of the book shows the 2008 presidential election results in two views: a map of the US with the winner by % margin of victory and a tile chart showing the state size, the winner and their % margin of victory. Due to the black and white nature of the book, these are shown in grayscale in the book and here on the blog.
2008 Presidential Election Results on a Map, Winner by State with Margin of Victory Read the rest of this entry »
